/ Check-in [5830cf72]
Login

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

Overview
Comment:Remove some randomness from test script temptable2.test.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 5830cf72e9e870830d088399f1ccb03ed6522582
User & Date: dan 2016-05-02 19:05:05
Context
2016-05-03
00:04
Avoid left-shifts of signed integers. check-in: 0715ce16 user: drh tags: trunk
2016-05-02
19:05
Remove some randomness from test script temptable2.test. check-in: 5830cf72 user: dan tags: trunk
16:59
Fix a test case in temptable2.test so that it works on systems that lack a coherient cache (ex: OpenBSD) and thus do not support the "PRAGMA mmap_size" command. check-in: 088cf838 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/temptable2.test.

   226    226   #
   227    227   reset_db
   228    228   do_execsql_test 8.1 {
   229    229     PRAGMA auto_vacuum = OFF;
   230    230     CREATE TABLE t2(a, b);
   231    231     CREATE INDEX i2 ON t2(a, b);
   232    232     WITH x(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM x WHERE i<20 )
   233         -  INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM x;
          233  +  INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM x ORDER BY 1, 2;
   234    234     PRAGMA page_count;
   235    235   } {13}
   236    236   
   237    237   do_test 8.2 {
   238    238     sqlite3 tmp ""
   239    239     execsql {
   240    240       PRAGMA auto_vacuum = OFF;
   241    241       PRAGMA page_size = 8192;
   242    242       CREATE TABLE t1(a, b);
   243    243       CREATE INDEX i1 ON t1(a, b);
   244    244       WITH x(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM x WHERE i<100 )
   245         -    INSERT INTO t1 SELECT randomblob(100), randomblob(100) FROM x;
          245  +    INSERT INTO t1 SELECT randomblob(100), randomblob(100) FROM x ORDER BY 1, 2;
   246    246       PRAGMA page_count;
   247    247     } tmp
   248    248   } {10}
   249    249   
   250    250   do_test 8.3 {
   251    251     sqlite3_backup B tmp main db main
   252    252     B step 5