Import SQLite 3.10.2.

third_party/sqlite/src/test/select7.test

 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
 # This file implements regression tests for SQLite library.  The
 # focus of this file is testing compute SELECT statements and nested
 # views.
 #
 # $Id: select7.test,v 1.11 2007/09/12 17:01:45 danielk1977 Exp $
 
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
+set testprefix select7
 
 ifcapable compound {
 
 # A 3-way INTERSECT.  Ticket #875
 ifcapable tempdb {
   do_test select7-1.1 {
     execsql {
       create temp table t1(x);
       insert into t1 values('amx');
       insert into t1 values('anx');
@@ skipping 166 matching lines @@
 } {0 real 0 real}
 
 do_test select7-7.7 {
   execsql {
     CREATE TABLE t5(a TEXT, b INT);
     INSERT INTO t5 VALUES(123, 456);
     SELECT typeof(a), a FROM t5 GROUP BY a HAVING a<b;
   }
 } {text 123}
 
+do_execsql_test 8.0 { 
+  CREATE TABLE t01(x, y);
+  CREATE TABLE t02(x, y);
+}
+
+do_catchsql_test 8.1 {
+  SELECT * FROM (
+    SELECT * FROM t01 UNION SELECT x FROM t02
+  ) WHERE y=1
+} {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
+
+do_catchsql_test 8.2 {
+  CREATE VIEW v0 as SELECT x, y FROM t01 UNION SELECT x FROM t02;
+  EXPLAIN QUERY PLAN SELECT * FROM v0 WHERE x='0' OR y;
+} {1 {SELECTs to the left and right of UNION do not have the same number of result columns}}
+
+
 finish_test
+
+