Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update test file eval.test to account for caching in the RowDecoder. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
3bbe9e80b89958271e770649f5c4a671 |
| User & Date: | dan 2013-07-25 14:18:56 |
Context
|
2013-07-25
| ||
| 15:13 | Reenable the whereShortCut() optimization. check-in: 97c7b5580f user: dan tags: trunk | |
| 14:18 | Update test file eval.test to account for caching in the RowDecoder. check-in: 3bbe9e80b8 user: dan tags: trunk | |
| 12:12 | Fixes to sqlite4FindInIndex so as to handle WHERE clauses of the form "x IN (SELECT a FROM tbl)" where there are usable indexes on both "a" and "x". check-in: 856ed13e06 user: dan tags: trunk | |
Changes
Changes to test/eval.test.
48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 |
#
do_test eval-2.1 {
execsql {
CREATE TABLE t2(x,y);
INSERT INTO t2 SELECT x, x+1 FROM t1 WHERE x<5;
SELECT x, test_eval('DELETE FROM t2 WHERE x='||x), y FROM t2;
}
} {1 {} {} 2 {} {} 3 {} {} 4 {} {}}
do_test eval-2.2 {
execsql {
SELECT * FROM t2
}
} {}
# Modify a row while it is being read.
#
do_test eval-3.1 {
execsql {
INSERT INTO t2 SELECT x, x+1 FROM t1 WHERE x<5;
SELECT x, test_eval('UPDATE t2 SET y=y+100 WHERE x='||x), y FROM t2;
}
} {1 {} 102 2 {} 103 3 {} 104 4 {} 105}
do_test eval-4.1 {
execsql { SELECT test_eval('SELECT ''abcdefghij''') }
} {abcdefghij}
finish_test
|
| | |
48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 |
#
do_test eval-2.1 {
execsql {
CREATE TABLE t2(x,y);
INSERT INTO t2 SELECT x, x+1 FROM t1 WHERE x<5;
SELECT x, test_eval('DELETE FROM t2 WHERE x='||x), y FROM t2;
}
} {1 {} 2 2 {} 3 3 {} 4 4 {} 5}
do_test eval-2.2 {
execsql {
SELECT * FROM t2
}
} {}
# Modify a row while it is being read.
#
do_test eval-3.1 {
execsql {
INSERT INTO t2 SELECT x, x+1 FROM t1 WHERE x<5;
SELECT x, test_eval('UPDATE t2 SET y=y+100 WHERE x='||x), y FROM t2;
}
} {1 {} 2 2 {} 3 3 {} 4 4 {} 5}
do_test eval-4.1 {
execsql { SELECT test_eval('SELECT ''abcdefghij''') }
} {abcdefghij}
finish_test
|