/ Check-in [55df410b]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Do not run tests for ".dump --preserve-rowids" when testing SQLITE_OMIT_VIRTUALTABLE builds.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 55df410b2cd27dc4c7670bcc1196fa3a0e9e601fc24c42e53d6b0a26ee3e4b45
User & Date: dan 2017-03-25 18:31:42
Context
2017-03-25
19:16
Add the new sqlite3_set_last_insert_rowid() interface to the extension loader thunk. check-in: 8469fc0d user: drh tags: trunk
18:31
Do not run tests for ".dump --preserve-rowids" when testing SQLITE_OMIT_VIRTUALTABLE builds. check-in: 55df410b user: dan tags: trunk
18:15
Disable the new --preserve-rowids option on the CLI ".dump" command if compiled with SQLITE_OMIT_VIRTUALTABLE. check-in: bd5bbe4e user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/shell1.test.

   751    751   INSERT INTO t3 VALUES(2,'');
   752    752   INSERT INTO t3 VALUES(3,1);
   753    753   INSERT INTO t3 VALUES(4,2.25);
   754    754   INSERT INTO t3 VALUES(5,'hello');
   755    755   INSERT INTO t3 VALUES(6,X'807f');
   756    756   COMMIT;}}
   757    757   
          758  +
          759  +ifcapable vtab {
          760  +
   758    761   # The --preserve-rowids option to .dump
   759    762   #
   760    763   do_test shell1-4.1.1 {
   761    764     catchcmd test.db {.dump --preserve-rowids}
   762    765   } {0 {PRAGMA foreign_keys=OFF;
   763    766   BEGIN TRANSACTION;
   764    767   CREATE TABLE t1(x);
................................................................................
   863    866   } {0 {PRAGMA foreign_keys=OFF;
   864    867   BEGIN TRANSACTION;
   865    868   CREATE TABLE t1(_ROWID_,rowid,oid);
   866    869   INSERT INTO t1 VALUES(1,NULL,'alpha');
   867    870   INSERT INTO t1 VALUES(12,'',99);
   868    871   INSERT INTO t1 VALUES(23,1,X'b0b1b2');
   869    872   COMMIT;}}
          873  +
          874  +} else {
          875  +
          876  +do_test shell1-4.1.6 {
          877  +  db close
          878  +  forcedelete test2.db
          879  +  sqlite3 db test2.db
          880  +  db eval {
          881  +    CREATE TABLE t1(x INTEGER PRIMARY KEY, y);
          882  +    INSERT INTO t1 VALUES(1,null), (2,''), (3,1),
          883  +                         (4,2.25), (5,'hello'), (6,x'807f');
          884  +  }
          885  +  catchcmd test2.db {.dump --preserve-rowids}
          886  +} {1 {The --preserve-rowids option is not compatible with SQLITE_OMIT_VIRTUALTABLE}}
          887  +
          888  +}
          889  +
   870    890   
   871    891   # Test the output of ".mode insert"
   872    892   #
   873    893   do_test shell1-4.2.1 {
   874    894     catchcmd test.db ".mode insert t1\nselect * from t1;"
   875    895   } {0 {INSERT INTO t1 VALUES(NULL);
   876    896   INSERT INTO t1 VALUES('');