Import SQLite 3.10.2.

third_party/sqlite/src/test/vtab4.test

 # 2006 June 10
 #
 # 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 39 matching lines @@
     INSERT INTO techo VALUES(1, 2, 3);
   }
   set echo_module
 } {xBegin echo(treal) xSync echo(treal) xCommit echo(treal)}
 do_test vtab4-1.3 {
   set echo_module [list]
   execsql {
     UPDATE techo SET a = 2;
   }
   set echo_module
-} [list xBestIndex {SELECT rowid, * FROM 'treal'} \
+} [list xBestIndex {SELECT rowid, a, b, c FROM 'treal'} \
         xBegin     echo(treal)                    \
-        xFilter    {SELECT rowid, * FROM 'treal'} \
+        xFilter    {SELECT rowid, a, b, c FROM 'treal'} \
         xSync      echo(treal)                    \
         xCommit    echo(treal)                    \
 ]
 do_test vtab4-1.4 {
   set echo_module [list]
   execsql {
     DELETE FROM techo;
   }
   set echo_module
-} [list xBestIndex {SELECT rowid, * FROM 'treal'} \
+} [list xBestIndex {SELECT rowid, NULL, NULL, NULL FROM 'treal'} \
         xBegin     echo(treal)                    \
-        xFilter    {SELECT rowid, * FROM 'treal'} \
+        xFilter    {SELECT rowid, NULL, NULL, NULL FROM 'treal'} \
         xSync      echo(treal)                    \
         xCommit    echo(treal)                    \
 ]
 
 # Ensure xBegin is not called more than once in a single transaction.
 #
 do_test vtab4-2.1 {
   set echo_module [list]
   execsql {
     BEGIN;
@@ skipping 13 matching lines @@
     CREATE VIRTUAL TABLE secho USING echo(sreal);
   }
   set echo_module [list]
   execsql {
     BEGIN;
     INSERT INTO secho SELECT * FROM techo;
     DELETE FROM techo;
     COMMIT;
   }
   set echo_module
-} [list xBestIndex {SELECT rowid, * FROM 'treal'} \
+} [list xBestIndex {SELECT rowid, a, b, c FROM 'treal'} \
         xBegin     echo(sreal)                    \
-        xFilter    {SELECT rowid, * FROM 'treal'} \
-        xBestIndex {SELECT rowid, * FROM 'treal'} \
+        xFilter    {SELECT rowid, a, b, c FROM 'treal'} \
+        xBestIndex {SELECT rowid, NULL, NULL, NULL FROM 'treal'} \
         xBegin     echo(treal)                    \
-        xFilter    {SELECT rowid, * FROM 'treal'} \
+        xFilter    {SELECT rowid, NULL, NULL, NULL FROM 'treal'} \
         xSync   echo(sreal)                       \
         xSync   echo(treal)                       \
         xCommit echo(sreal)                       \
         xCommit echo(treal)                       \
 ]
 do_test vtab4-2.3 {
   execsql {
     SELECT * FROM secho;
   }
 } {1 2 3 4 5 6 7 8 9}
 do_test vtab4-2.4 {
   execsql {
     SELECT * FROM techo;
   }
 } {}
 
 # Try an explicit ROLLBACK on a transaction with two open virtual tables.
 do_test vtab4-2.5 {
   set echo_module [list]
   execsql {
     BEGIN;
     INSERT INTO techo SELECT * FROM secho;
     DELETE FROM secho;
     ROLLBACK;
   }
   set echo_module
-} [list xBestIndex {SELECT rowid, * FROM 'sreal'} \
+} [list xBestIndex {SELECT rowid, a, b, c FROM 'sreal'} \
         xBegin     echo(treal)                    \
-        xFilter    {SELECT rowid, * FROM 'sreal'} \
-        xBestIndex {SELECT rowid, * FROM 'sreal'} \
+        xFilter    {SELECT rowid, a, b, c FROM 'sreal'} \
+        xBestIndex {SELECT rowid, NULL, NULL, NULL FROM 'sreal'} \
         xBegin     echo(sreal)                    \
-        xFilter    {SELECT rowid, * FROM 'sreal'} \
+        xFilter    {SELECT rowid, NULL, NULL, NULL FROM 'sreal'} \
         xRollback  echo(treal)                    \
         xRollback  echo(sreal)                    \
 ]
 do_test vtab4-2.6 {
   execsql {
     SELECT * FROM secho;
   }
 } {1 2 3 4 5 6 7 8 9}
 do_test vtab4-2.7 {
   execsql {
@@ skipping 15 matching lines @@
 do_test vtab4-3.3 {
   set echo_module [list]
   set echo_module_sync_fail sreal
   catchsql {
     BEGIN;
     INSERT INTO techo SELECT * FROM secho;
     DELETE FROM secho;
     COMMIT;
   }
   set echo_module
-} [list xBestIndex {SELECT rowid, * FROM 'sreal'} \
+} [list xBestIndex {SELECT rowid, a, b, c FROM 'sreal'} \
         xBegin     echo(treal)                    \
-        xFilter    {SELECT rowid, * FROM 'sreal'} \
-        xBestIndex {SELECT rowid, * FROM 'sreal'} \
+        xFilter    {SELECT rowid, a, b, c FROM 'sreal'} \
+        xBestIndex {SELECT rowid, NULL, NULL, NULL FROM 'sreal'} \
         xBegin     echo(sreal)                    \
-        xFilter    {SELECT rowid, * FROM 'sreal'} \
+        xFilter    {SELECT rowid, NULL, NULL, NULL FROM 'sreal'} \
         xSync      echo(treal)                    \
         xSync      echo(sreal)                    \
         xRollback  echo(treal)                    \
         xRollback  echo(sreal)                    \
 ]
 
 finish_test