/ History for test/where4.test
Login

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

History for test/where4.test

2015-11-05
22:30
[4a371bfc] part of check-in [997ce6c9] Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now. (check-in: [997ce6c9] user: drh branch: seekeq-experiment, size: 8705)
2015-09-04
12:54
[44f506bf] part of check-in [3d3df79b] Continue to support the (broken) legacy syntax of allowing strings for column names in CREATE INDEX statements and in UNIQUE and PRIMARY KEY constraints. (check-in: [3d3df79b] user: drh branch: trunk, size: 8705)
2015-05-15
19:59
[68aa5ad7] part of check-in [e038ce89] Do not assume that "col IS ?" matches at most a single row of a UNIQUE column unless the column is also NOT NULL. (check-in: [e038ce89] user: dan branch: trunk, size: 8605)
2015-05-14
01:05
[a4603fa0] part of check-in [4541688b] A new implementation of indexing with the IS operator that works correctly when the IS operator is in the WHERE clause and the operands are from opposite sides of a LEFT JOIN. (check-in: [4541688b] user: drh branch: index-is-operator, size: 8131)
2014-02-14
23:49
[d8420cee] part of check-in [e07a32f3] Seek past NULLs in a top-constrained search. Avoid checking for NULLs in the body of the search. (check-in: [e07a32f3] user: drh branch: trunk, size: 7774)
2007-12-10
05:03
[e9b9e2f2] part of check-in [0b34a186] Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) (check-in: [0b34a186] user: danielk1977 branch: trunk, size: 7774)
2007-09-12
17:01
[1b1cd72d] part of check-in [c8405b15] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (check-in: [c8405b15] user: danielk1977 branch: trunk, size: 7729)
2007-06-02
07:54
[f80207a4] part of check-in [17152bf1] Fix a vdbe stack leak that could occur where one side of a WHERE clause inequality evaluated to SQL null. (CVS 4045) (check-in: [17152bf1] user: danielk1977 branch: trunk, size: 7673)
2007-03-28
14:30
[b6849650] part of check-in [26348556] Correctly handle NULLs in IN operators. Ticket #2273. The changes in where.c and in the WhereLevel.aInLoop structure are not strictly necessary to fix this problem - they just make the code easier to read. Only the change in OP_Next/OP_Prev operator of vdbe.c is required. (CVS 3735) (check-in: [26348556] user: drh branch: trunk, size: 6845)
2007-01-25
16:56
[3fcf53c5] part of check-in [358dd82d] Fix an additional problem with the IS NULL optimization on LEFT JOINs. Ticket #2189. See also ticket #2177. (CVS 3602) (check-in: [358dd82d] user: drh branch: trunk, size: 5472)
2007-01-19
01:06
[c6b6cca0] part of check-in [335863e4] Make sure the IS NULL optimization introduced by check-in (3494) correctly handles a LEFT JOIN where the a term from the right table of the join uses an IS NULL constraint. Ticket #2177. This check-in also adds the new test cases that were suppose to have been added with (3494) but which were mistakenly omitted. (CVS 3595) (check-in: [335863e4] user: drh branch: trunk, size: 4505) Added