| Index: third_party/sqlite/sqlite-src-3080704/mptest/crash01.test
|
| diff --git a/third_party/sqlite/sqlite-src-3080704/mptest/crash01.test b/third_party/sqlite/sqlite-src-3080704/mptest/crash01.test
|
| deleted file mode 100644
|
| index 46f170cecc2c2f2a28fa94c123d565592a3e49c7..0000000000000000000000000000000000000000
|
| --- a/third_party/sqlite/sqlite-src-3080704/mptest/crash01.test
|
| +++ /dev/null
|
| @@ -1,102 +0,0 @@
|
| -/* Test cases involving incomplete transactions that must be rolled back.
|
| -*/
|
| ---task 1
|
| - 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));
|
| - --sleep 1
|
| - INSERT INTO t1 SELECT a+2, randomblob(1500) FROM t1;
|
| - INSERT INTO t1 SELECT a+4, randomblob(1500) FROM t1;
|
| - INSERT INTO t1 SELECT a+8, randomblob(1500) FROM t1;
|
| - --sleep 1
|
| - INSERT INTO t1 SELECT a+16, randomblob(1500) FROM t1;
|
| - --sleep 1
|
| - INSERT INTO t1 SELECT a+32, randomblob(1500) FROM t1;
|
| - SELECT count(*) FROM t1;
|
| - --match 64
|
| - SELECT avg(length(b)) FROM t1;
|
| - --match 1500.0
|
| - --sleep 2
|
| - UPDATE t1 SET b='x'||a||'y';
|
| - SELECT sum(length(b)) FROM t1;
|
| - --match 247
|
| - SELECT a FROM t1 WHERE b='x17y';
|
| - --match 17
|
| - CREATE INDEX t1b ON t1(b);
|
| - SELECT a FROM t1 WHERE b='x17y';
|
| - --match 17
|
| - SELECT a FROM t1 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
|
| - --match 29 28 27 26 25
|
| ---end
|
| ---wait 1
|
| ---task 2
|
| - CREATE TABLE t2(a INTEGER PRIMARY KEY, b);
|
| - INSERT INTO t2 SELECT a, b FROM t1;
|
| - UPDATE t1 SET b='x'||a||'y';
|
| - SELECT sum(length(b)) FROM t2;
|
| - --match 247
|
| - SELECT a FROM t2 WHERE b='x17y';
|
| - --match 17
|
| - CREATE INDEX t2b ON t2(b);
|
| - SELECT a FROM t2 WHERE b='x17y';
|
| - --match 17
|
| - SELECT a FROM t2 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
|
| - --match 29 28 27 26 25
|
| ---end
|
| ---task 3
|
| - CREATE TABLE t3(a INTEGER PRIMARY KEY, b);
|
| - INSERT INTO t3 SELECT a, b FROM t1;
|
| - UPDATE t1 SET b='x'||a||'y';
|
| - SELECT sum(length(b)) FROM t3;
|
| - --match 247
|
| - SELECT a FROM t3 WHERE b='x17y';
|
| - --match 17
|
| - CREATE INDEX t3b ON t3(b);
|
| - SELECT a FROM t3 WHERE b='x17y';
|
| - --match 17
|
| - SELECT a FROM t3 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
|
| - --match 29 28 27 26 25
|
| ---end
|
| ---task 4
|
| - CREATE TABLE t4(a INTEGER PRIMARY KEY, b);
|
| - INSERT INTO t4 SELECT a, b FROM t1;
|
| - UPDATE t1 SET b='x'||a||'y';
|
| - SELECT sum(length(b)) FROM t4;
|
| - --match 247
|
| - SELECT a FROM t4 WHERE b='x17y';
|
| - --match 17
|
| - CREATE INDEX t4b ON t4(b);
|
| - SELECT a FROM t4 WHERE b='x17y';
|
| - --match 17
|
| - SELECT a FROM t4 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
|
| - --match 29 28 27 26 25
|
| ---end
|
| ---task 5
|
| - CREATE TABLE t5(a INTEGER PRIMARY KEY, b);
|
| - INSERT INTO t5 SELECT a, b FROM t1;
|
| - UPDATE t1 SET b='x'||a||'y';
|
| - SELECT sum(length(b)) FROM t5;
|
| - --match 247
|
| - SELECT a FROM t5 WHERE b='x17y';
|
| - --match 17
|
| - CREATE INDEX t5b ON t5(b);
|
| - SELECT a FROM t5 WHERE b='x17y';
|
| - --match 17
|
| - SELECT a FROM t5 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
|
| - --match 29 28 27 26 25
|
| ---end
|
| -
|
| ---wait all
|
| -/* After the database file has been set up, run the crash2 subscript
|
| -** multiple times. */
|
| ---source crash02.subtest
|
| ---source crash02.subtest
|
| ---source crash02.subtest
|
| ---source crash02.subtest
|
| ---source crash02.subtest
|
| ---source crash02.subtest
|
| ---source crash02.subtest
|
| ---source crash02.subtest
|
| ---source crash02.subtest
|
|
|