Import SQLite 3.10.2.

third_party/sqlite/src/test/vtabA.test

 # 2007 June 26
 #
 # 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.
 #
 #***********************************************************************
@@ skipping 56 matching lines @@
   execsql {
     SELECT a, b, c FROM t1e;
   }
 } {{value a} {} {value c}}
 
 do_test vtabA-1.6 {
   execsql {
     SELECT * FROM t1e;
   }
 } {{value a} {value c}}
+do_execsql_test vtabA-1.7 {
+  DELETE FROM t1e;
+  INSERT INTO t1e SELECT 'abc','def';
+} {}
+do_execsql_test vtabA-1.8 {
+  INSERT INTO t1e VALUES('ghi','jkl'),('mno','pqr'),('stu','vwx');
+} {}
+do_execsql_test vtabA-1.9 {
+  SELECT a,b,c, '|' FROM t1e ORDER BY 1;
+} {abc {} def | ghi {} jkl | mno {} pqr | stu {} vwx |}
+
 
 # Test that the expansion of a '*' expression in the result set of
 # a SELECT does not include the hidden column.
 #
-do_test vtabA-1.7 {
+do_test vtabA-1.20 {
   execsql {
     INSERT INTO t1e SELECT * FROM t1e;
   }
 } {}
-do_test vtabA-1.8 {
+do_test vtabA-1.21 {
   execsql {
-    SELECT * FROM t1e;
+    SELECT * FROM t1e ORDER BY 1;
   }
-} {{value a} {value c} {value a} {value c}}
+} {abc def abc def ghi jkl ghi jkl mno pqr mno pqr stu vwx stu vwx}
 
 # Test that the declaration type of the hidden column does not include
 # the token "HIDDEN".
 #
-do_test vtabA-1.9 {
+do_test vtabA-1.22 {
   get_decltype t1e b
 } {VARCHAR}
-do_test vtabA-1.10 {
+do_test vtabA-1.23 {
   get_collist t1e
 } {a c}
 
 #----------------------------------------------------------------------
 # These tests vtabA-2.* concentrate on testing that the HIDDEN token
 # is detected and handled correctly in various declarations.
 #
 proc analyse_parse {columns decltype_list} {
   db eval { DROP TABLE IF EXISTS t1e; }
   db eval { DROP TABLE IF EXISTS t1; }
@@ skipping 35 matching lines @@
     CREATE TABLE t2(x,y);
     INSERT INTO t2 VALUES(3,4);
     CREATE VIRTUAL TABLE vt1 USING echo(t1);
     CREATE VIRTUAL TABLE vt2 USING echo(t2);
     UPDATE vt2 SET x=(SELECT a FROM vt1 WHERE b=2) WHERE y=4;
     SELECT * FROM t2;
   }
 } {1 4}
 
 finish_test