Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | More minor changes to test scripts. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
ce9b756f09df4feb485bbf9695f8c677 |
| User & Date: | dan 2018-05-29 14:29:28 |
Context
|
2018-05-29
| ||
| 15:18 | Add a comment to justify a goto statement. No code changes. check-in: f141d80647 user: drh tags: trunk | |
| 14:29 | More minor changes to test scripts. check-in: ce9b756f09 user: dan tags: trunk | |
| 14:06 | Fix some test script issues caused by recent EXPLAIN QUERY PLAN enhancements. check-in: f808e22831 user: dan tags: trunk | |
Changes
Changes to ext/expert/expert1.test.
282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 |
CREATE TRIGGER t9t AFTER INSERT ON t9 BEGIN
UPDATE t10 SET a=new.a WHERE b = new.b;
END;
} {
INSERT INTO t9 VALUES(?, ?, ?);
} {
CREATE INDEX t10_idx_00000062 ON t10(b);
-- TRIGGER t9t
SEARCH TABLE t10 USING INDEX t10_idx_00000062 (b=?)
}
do_setup_rec_test $tn.15 {
CREATE TABLE t1(a, b);
CREATE TABLE t2(c, d);
|
< |
282 283 284 285 286 287 288 289 290 291 292 293 294 295 |
CREATE TRIGGER t9t AFTER INSERT ON t9 BEGIN
UPDATE t10 SET a=new.a WHERE b = new.b;
END;
} {
INSERT INTO t9 VALUES(?, ?, ?);
} {
CREATE INDEX t10_idx_00000062 ON t10(b);
SEARCH TABLE t10 USING INDEX t10_idx_00000062 (b=?)
}
do_setup_rec_test $tn.15 {
CREATE TABLE t1(a, b);
CREATE TABLE t2(c, d);
|
Changes to ext/expert/sqlite3expert.c.
1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 |
idxHashAdd(&rc, &hIdx, zSql, 0);
if( rc ) goto find_indexes_out;
}
break;
}
}
pStmt->zEQP = idxAppendText(&rc, pStmt->zEQP, "%s\n", zDetail);
}
for(pEntry=hIdx.pFirst; pEntry; pEntry=pEntry->pNext){
pStmt->zIdx = idxAppendText(&rc, pStmt->zIdx, "%s;\n", pEntry->zKey);
}
idxFinalize(&rc, pExplain);
|
> | > |
1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 |
idxHashAdd(&rc, &hIdx, zSql, 0);
if( rc ) goto find_indexes_out;
}
break;
}
}
if( zDetail[0]!='-' ){
pStmt->zEQP = idxAppendText(&rc, pStmt->zEQP, "%s\n", zDetail);
}
}
for(pEntry=hIdx.pFirst; pEntry; pEntry=pEntry->pNext){
pStmt->zIdx = idxAppendText(&rc, pStmt->zIdx, "%s;\n", pEntry->zKey);
}
idxFinalize(&rc, pExplain);
|
Changes to test/resetdb.test.
28
29
30
31
32
33
34
35
36
37
38
39
40
41
..
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
if {[permutation]=="inmemory_journal"} {
finish_test
return
}
# Create a sample database
do_execsql_test 100 {
PRAGMA page_size=4096;
CREATE TABLE t1(a,b);
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<20)
INSERT INTO t1(a,b) SELECT x, randomblob(300) FROM c;
CREATE INDEX t1a ON t1(a);
CREATE INDEX t1b ON t1(b);
SELECT sum(a), sum(length(b)) FROM t1;
................................................................................
# with a different page size and in WAL mode.
#
db close
db2 close
forcedelete test.db
sqlite3 db test.db
do_execsql_test 300 {
PRAGMA page_size=8192;
PRAGMA journal_mode=WAL;
CREATE TABLE t1(a,b);
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<20)
INSERT INTO t1(a,b) SELECT x, randomblob(1300) FROM c;
CREATE INDEX t1a ON t1(a);
CREATE INDEX t1b ON t1(b);
|
>
>
|
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
..
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
if {[permutation]=="inmemory_journal"} {
finish_test
return
}
# Create a sample database
do_execsql_test 100 {
PRAGMA auto_vacuum = 0;
PRAGMA page_size=4096;
CREATE TABLE t1(a,b);
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<20)
INSERT INTO t1(a,b) SELECT x, randomblob(300) FROM c;
CREATE INDEX t1a ON t1(a);
CREATE INDEX t1b ON t1(b);
SELECT sum(a), sum(length(b)) FROM t1;
................................................................................
# with a different page size and in WAL mode.
#
db close
db2 close
forcedelete test.db
sqlite3 db test.db
do_execsql_test 300 {
PRAGMA auto_vacuum = 0;
PRAGMA page_size=8192;
PRAGMA journal_mode=WAL;
CREATE TABLE t1(a,b);
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<20)
INSERT INTO t1(a,b) SELECT x, randomblob(1300) FROM c;
CREATE INDEX t1a ON t1(a);
CREATE INDEX t1b ON t1(b);
|