| OLD | NEW |
|---|
| 1 /* | 1 /* |
| 2 ** This script sets up five different tasks all writing and updating | 2 ** This script sets up five different tasks all writing and updating |
| 3 ** the database at the same time, but each in its own table. | 3 ** the database at the same time, but each in its own table. |
| 4 */ | 4 */ |
| 5 --task 1 build-t1 | 5 --task 1 build-t1 |
| 6 DROP TABLE IF EXISTS t1; | 6 DROP TABLE IF EXISTS t1; |
| 7 CREATE TABLE t1(a INTEGER PRIMARY KEY, b); | 7 CREATE TABLE t1(a INTEGER PRIMARY KEY, b); |
| 8 --sleep 1 | 8 --sleep 1 |
| 9 INSERT INTO t1 VALUES(1, randomblob(2000)); | 9 INSERT INTO t1 VALUES(1, randomblob(2000)); |
| 10 INSERT INTO t1 VALUES(2, randomblob(1000)); | 10 INSERT INTO t1 VALUES(2, randomblob(1000)); |
| (...skipping 385 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 396 SELECT t1.a FROM t1, t2 | 396 SELECT t1.a FROM t1, t2 |
| 397 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y') | 397 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y') |
| 398 ORDER BY t1.a LIMIT 4 | 398 ORDER BY t1.a LIMIT 4 |
| 399 --match 33 34 35 36 | 399 --match 33 34 35 36 |
| 400 SELECT t3.a FROM t3, t4 | 400 SELECT t3.a FROM t3, t4 |
| 401 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y') | 401 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y') |
| 402 ORDER BY t3.a LIMIT 7 | 402 ORDER BY t3.a LIMIT 7 |
| 403 --match 45 46 47 48 49 50 51 | 403 --match 45 46 47 48 49 50 51 |
| 404 --end | 404 --end |
| 405 --wait all | 405 --wait all |
| OLD | NEW |
|---|
Chromium Code Reviews
Issue 901033002:
Import SQLite 3.8.7.4. (Closed)
Base URL: https://chromium.googlesource.com/chromium/src.git@master