/ Check-in [d8b1c433]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add a missing ticket number to a comment in index7.test.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d8b1c4336145d436241863c3525530e24a24799b
User & Date: dan 2014-08-27 17:48:15
Context
2014-08-27
17:53
Add a VDBE synopsis comment for clarification. check-in: 029a6dc7 user: mistachkin tags: trunk
17:48
Add a missing ticket number to a comment in index7.test. check-in: d8b1c433 user: dan tags: trunk
17:37
When determining whether or not a partial index is usable, do not assume that the cursor number assigned to each table in the query is the same as its index in the FROM clause. Fix for ticket [98d973b8f5]. check-in: fcebca16 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/index7.test.

   244    244     CREATE INDEX t3b ON t3(b) WHERE xyzzy.t3.b BETWEEN 5 AND 10;
   245    245                                  /* ^^^^^-- ignored */
   246    246     ANALYZE;
   247    247     SELECT count(*) FROM t3 WHERE t3.b BETWEEN 5 AND 10;
   248    248     SELECT stat+0 FROM sqlite_stat1 WHERE idx='t3b';
   249    249   } {6 6}
   250    250   
   251         -# Verify that the problem identified by ticket [] has been fixed.
          251  +# Verify that the problem identified by ticket [98d973b8f5] has been fixed.
   252    252   #
   253    253   do_execsql_test index7-6.1 {
   254    254     CREATE TABLE t5(a, b);
   255    255     CREATE TABLE t4(c, d);
   256    256     INSERT INTO t5 VALUES(1, 'xyz');
   257    257     INSERT INTO t4 VALUES('abc', 'not xyz');
   258    258     SELECT * FROM (SELECT * FROM t5 WHERE a=1 AND b='xyz'), t4 WHERE c='abc';