Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/where4.test
|
2015-11-05
| ||
| 22:30 | [4a371bfcc6] part of check-in [997ce6c90b] Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now. (check-in: [997ce6c90b] user: drh branch: seekeq-experiment, size: 8705) | |
|
2015-09-04
| ||
| 12:54 | [44f506bf17] part of check-in [3d3df79bfa] 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: [3d3df79bfa] user: drh branch: trunk, size: 8705) | |
|
2015-05-15
| ||
| 19:59 | [68aa5ad796] part of check-in [e038ce8955] 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: [e038ce8955] user: dan branch: trunk, size: 8605) | |
|
2015-05-14
| ||
| 01:05 | [a4603fa0d0] part of check-in [4541688b3f] 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: [4541688b3f] user: drh branch: index-is-operator, size: 8131) | |
|
2014-02-14
| ||
| 23:49 | [d8420ceeb8] part of check-in [e07a32f308] Seek past NULLs in a top-constrained search. Avoid checking for NULLs in the body of the search. (check-in: [e07a32f308] user: drh branch: trunk, size: 7774) | |
|
2007-12-10
| ||
| 05:03 | [e9b9e2f2f9] part of check-in [0b34a18651] Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) (check-in: [0b34a18651] user: danielk1977 branch: trunk, size: 7774) | |
|
2007-09-12
| ||
| 17:01 | [1b1cd72d5f] part of check-in [c8405b15c0] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (check-in: [c8405b15c0] user: danielk1977 branch: trunk, size: 7729) | |
|
2007-06-02
| ||
| 07:54 | [f80207a4ea] part of check-in [17152bf1a2] Fix a vdbe stack leak that could occur where one side of a WHERE clause inequality evaluated to SQL null. (CVS 4045) (check-in: [17152bf1a2] user: danielk1977 branch: trunk, size: 7673) | |
|
2007-03-28
| ||
| 14:30 | [b68496500b] part of check-in [26348556d8] 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: [26348556d8] user: drh branch: trunk, size: 6845) | |
|
2007-01-25
| ||
| 16:56 | [3fcf53c5ea] part of check-in [358dd82d3a] Fix an additional problem with the IS NULL optimization on LEFT JOINs. Ticket #2189. See also ticket #2177. (CVS 3602) (check-in: [358dd82d3a] user: drh branch: trunk, size: 5472) | |
|
2007-01-19
| ||
| 01:06 | Added: [c6b6cca085] part of check-in [335863e4d1] 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: [335863e4d1] user: drh branch: trunk, size: 4505) | |