Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix where9.test so that it works with the "no_optimization" permutation. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
d46adf9d8f741838b9c30f915231d6a3 |
| User & Date: | dan 2014-08-12 20:13:22 |
Context
|
2014-08-13
| ||
| 11:39 | Minor change to unixDelete for VxWorks with a DOS filesystem. (check-in: f01d42cc user: drh tags: trunk) | |
|
2014-08-12
| ||
| 20:13 | Fix where9.test so that it works with the "no_optimization" permutation. (check-in: d46adf9d user: dan tags: trunk) | |
| 16:13 | Fix compilation issue in the Win32 VFS when manually defining SQLITE_WIN32_NO_ANSI. (check-in: 67159912 user: mistachkin tags: trunk) | |
Changes
Changes to test/where9.test.
777 777 catchsql { 778 778 UPDATE t1 INDEXED BY t1b SET a=a+100 779 779 WHERE (+b IS NULL AND c NOT NULL AND d NOT NULL) 780 780 OR (b NOT NULL AND c IS NULL AND d NOT NULL) 781 781 OR (b NOT NULL AND c NOT NULL AND d IS NULL) 782 782 } 783 783 } {1 {no query solution}} 784 + 785 +set solution_possible 0 784 786 ifcapable stat4||stat3 { 787 + if {[permutation] != "no_optimization"} { set solution_possible 1 } 788 +} 789 +if $solution_possible { 785 790 # When STAT3 is enabled, the "b NOT NULL" terms get translated 786 791 # into b>NULL, which can be satified by the index t1b. It is a very 787 792 # expensive way to do the query, but it works, and so a solution is possible. 788 793 do_test where9-6.8.3-stat4 { 789 794 catchsql { 790 795 UPDATE t1 INDEXED BY t1b SET a=a+100 791 796 WHERE (b IS NULL AND c NOT NULL AND d NOT NULL)