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 | |