Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(12)

Unified Diff: third_party/sqlite/sqlite-src-3080704/mptest/crash01.test

Issue 2363173002: [sqlite] Remove obsolete reference version 3.8.7.4. (Closed)
Patch Set: Created 4 years, 3 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
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

Powered by Google App Engine
This is Rietveld 408576698