Import SQLite 3.10.2.

third_party/sqlite/src/mptest/multiwrite01.test

 /*
 ** This script sets up five different tasks all writing and updating
 ** the database at the same time, but each in its own table.
 */
 --task 1 build-t1
   DROP TABLE IF EXISTS t1;
   CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
   --sleep 1
   INSERT INTO t1 VALUES(1, randomblob(2000));
   INSERT INTO t1 VALUES(2, randomblob(1000));
@@ skipping 343 matching lines @@
 
 --task 1
   SELECT t1.a FROM t1, t2
    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
    ORDER BY t1.a LIMIT 4
   --match 33 34 35 36
   SELECT t3.a FROM t3, t4
    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
    ORDER BY t3.a LIMIT 7
   --match 45 46 47 48 49 50 51
+  PRAGMA integrity_check;
+  --match ok
 --end
 --task 5
   SELECT t1.a FROM t1, t2
    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
    ORDER BY t1.a LIMIT 4
   --match 33 34 35 36
   SELECT t3.a FROM t3, t4
    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
    ORDER BY t3.a LIMIT 7
   --match 45 46 47 48 49 50 51
+  PRAGMA integrity_check;
+  --match ok
 --end
 --task 3
   SELECT t1.a FROM t1, t2
    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
    ORDER BY t1.a LIMIT 4
   --match 33 34 35 36
   SELECT t3.a FROM t3, t4
    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
    ORDER BY t3.a LIMIT 7
   --match 45 46 47 48 49 50 51
+  PRAGMA integrity_check;
+  --match ok
 --end
 --task 2
   SELECT t1.a FROM t1, t2
    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
    ORDER BY t1.a LIMIT 4
   --match 33 34 35 36
   SELECT t3.a FROM t3, t4
    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
    ORDER BY t3.a LIMIT 7
   --match 45 46 47 48 49 50 51
+  PRAGMA integrity_check;
+  --match ok
 --end
 --task 4
   SELECT t1.a FROM t1, t2
    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
    ORDER BY t1.a LIMIT 4
   --match 33 34 35 36
   SELECT t3.a FROM t3, t4
    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
    ORDER BY t3.a LIMIT 7
   --match 45 46 47 48 49 50 51
+  PRAGMA integrity_check;
+  --match ok
 --end
 --wait all