/ Check-in [ace7e7b6]
Login

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

Overview
Comment:Updates to the backcompat.test test script so that it works with really old (3.6.*) versions.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | omit-rowid
Files: files | file ages | folders
SHA1: ace7e7b64261aeabc9525d5d0cfebe0275c9ddf5
User & Date: dan 2013-11-05 15:02:39
Context
2013-11-05
16:39
Unless the destination table is completely empty, disable the xfer optimization for WITHOUT ROWID tables. check-in: 3877c9f5 user: dan tags: omit-rowid
15:02
Updates to the backcompat.test test script so that it works with really old (3.6.*) versions. check-in: ace7e7b6 user: dan tags: omit-rowid
14:19
Add tests for updates of without-rowid tables that use non-BINARY collation sequences for the primary key columns. And a minor bugfix to the same. check-in: 99b1fa4b user: dan tags: omit-rowid
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/backcompat.test.

   200    200   
   201    201     do_test backcompat-1.2.7 { sql1 { PRAGMA integrity_check } } {ok}
   202    202     do_test backcompat-1.2.8 { sql2 { PRAGMA integrity_check } } {ok}
   203    203   
   204    204     do_test backcompat-2.1 {
   205    205       sql1 {
   206    206         CREATE TABLE t2(a UNIQUE, b PRIMARY KEY, c UNIQUE);
   207         -      INSERT INTO t2 VALUES(1,9,5),(5,5,1),(9,1,9);
          207  +      INSERT INTO t2 VALUES(1,9,5);
          208  +      INSERT INTO t2 VALUES(5,5,1);
          209  +      INSERT INTO t2 VALUES(9,1,9);
   208    210         SELECT * FROM t2 ORDER BY a;
   209    211       }
   210    212     } {1 9 5 5 5 1 9 1 9}
   211    213     do_test backcompat-2.2 {
   212    214       sql2 {
          215  +      SELECT * FROM sqlite_master WHERE rootpage=-1;
   213    216         SELECT * FROM t2 ORDER BY a;
   214    217       }
   215    218     } {1 9 5 5 5 1 9 1 9}
   216    219     do_test backcompat-2.3 {
   217    220       sql1 {
   218    221         SELECT * FROM t2 ORDER BY b;
   219    222       }