/ Check-in [a0c08d26]
Login

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

Overview
Comment:The optimization on this branch is logically incorrect. It changes the return value of "SELECT 0 OR 'xyzzy'" FROM 0 to 'xyzzy'.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | simplify-or-clause
Files: files | file ages | folders
SHA1:a0c08d2689804958937662f2529f182812c4aaa6
User & Date: drh 2015-10-29 14:29:01
Original Comment: Remove an "exit" call in the where2.test script that accidentally left in the code following a debugging session.
Context
2015-10-29
14:29
The optimization on this branch is logically incorrect. It changes the return value of "SELECT 0 OR 'xyzzy'" FROM 0 to 'xyzzy'. Closed-Leaf check-in: a0c08d26 user: drh tags: simplify-or-clause
12:27
Apply optimizations to simplify OR clauses that contain constant terms. check-in: d533e23f user: drh tags: simplify-or-clause
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/where2.test.

   294    294       }
   295    295     } {99 6 10000 10006 nosort t1 i1w}
   296    296   }
   297    297   
   298    298   # Verify that OR clauses get translated into IN operators.
   299    299   #
   300    300   set ::idx {}
   301         -exit
   302    301   ifcapable subquery {set ::idx i1w}
   303    302   do_test where2-6.1.1 {
   304    303     queryplan {
   305    304       SELECT * FROM t1 WHERE w=99 OR w=100 ORDER BY +w
   306    305     }
   307    306   } [list 99 6 10000 10006 100 6 10201 10207 sort t1 $::idx]
   308    307   do_test where2-6.1.2 {