/ Check-in [d46adf9d]
Login

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: d46adf9d8f741838b9c30f915231d6a3986c3591
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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)