Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | New test case for ticket [1d958d90596593a77420e59]. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
b7bf3c9832bde26b359f4d58ebcf7788 |
| User & Date: | drh 2018-12-09 18:55:05 |
Context
|
2018-12-10
| ||
| 01:48 | Add support for the VACUUM INTO command. check-in: 77f150b8 user: drh tags: trunk | |
| 00:40 | Merge fixes from trunk. check-in: ab1e58fa user: drh tags: vacuum-into | |
|
2018-12-09
| ||
| 18:55 | New test case for ticket [1d958d90596593a77420e59]. check-in: b7bf3c98 user: drh tags: trunk | |
|
2018-12-08
| ||
| 20:30 | Do not use a partial index as a table scan in an IN operator. Fix for ticket [1d958d90596593a77420e59]. check-in: 15bc915d user: drh tags: trunk | |
Changes
Changes to test/index6.test.
403 404 405 406 407 408 409 410 411 |
CREATE TABLE t2(x);
INSERT INTO t2 VALUES(1);
INSERT INTO t2 VALUES(2);
SELECT 'one', * FROM t2 WHERE x NOT IN (SELECT a FROM t1);
CREATE INDEX t1a ON t1(a) WHERE b=1;
SELECT 'two', * FROM t2 WHERE x NOT IN (SELECT a FROM t1);
} {}
finish_test
|
< > > > |
403 404 405 406 407 408 409 410 411 412 413 |
CREATE TABLE t2(x);
INSERT INTO t2 VALUES(1);
INSERT INTO t2 VALUES(2);
SELECT 'one', * FROM t2 WHERE x NOT IN (SELECT a FROM t1);
CREATE INDEX t1a ON t1(a) WHERE b=1;
SELECT 'two', * FROM t2 WHERE x NOT IN (SELECT a FROM t1);
} {}
do_execsql_test index6-12.2 {
SELECT x FROM t2 WHERE x IN (SELECT a FROM t1) ORDER BY +x;
} {1 2}
finish_test
|