/ File History
Login

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

History of test/where4.test

2015-11-05
22:30
Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now. file: [4a371bfc] check-in: [997ce6c9] user: drh branch: seekeq-experiment, size: 8705
2015-09-04
12:54
Continue to support the (broken) legacy syntax of allowing strings for column names in CREATE INDEX statements and in UNIQUE and PRIMARY KEY constraints. file: [44f506bf] check-in: [3d3df79b] user: drh branch: trunk, size: 8705
2015-05-15
19:59
Do not assume that "col IS ?" matches at most a single row of a UNIQUE column unless the column is also NOT NULL. file: [68aa5ad7] check-in: [e038ce89] user: dan branch: trunk, size: 8605
2015-05-14
01:05
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. file: [a4603fa0] check-in: [4541688b] user: drh branch: index-is-operator, size: 8131
2014-02-14
23:49
Seek past NULLs in a top-constrained search. Avoid checking for NULLs in the body of the search. file: [d8420cee] check-in: [e07a32f3] user: drh branch: trunk, size: 7774
2007-12-10
05:03
Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) file: [e9b9e2f2] check-in: [0b34a186] user: danielk1977 branch: trunk, size: 7774
2007-09-12
17:01
Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) file: [1b1cd72d] check-in: [c8405b15] user: danielk1977 branch: trunk, size: 7729
2007-06-02
07:54
Fix a vdbe stack leak that could occur where one side of a WHERE clause inequality evaluated to SQL null. (CVS 4045) file: [f80207a4] check-in: [17152bf1] user: danielk1977 branch: trunk, size: 7673
2007-03-28
14:30
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) file: [b6849650] check-in: [26348556] user: drh branch: trunk, size: 6845
2007-01-25
16:56
Fix an additional problem with the IS NULL optimization on LEFT JOINs. Ticket #2189. See also ticket #2177. (CVS 3602) file: [3fcf53c5] check-in: [358dd82d] user: drh branch: trunk, size: 5472
2007-01-19
01:06
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) file: [c6b6cca0] check-in: [335863e4] user: drh branch: trunk, size: 4505 Added