SQLite

All files named ”test/tkt3824.test”
Login

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

History for test/tkt3824.test

2011-02-11
03:56
[150aa00bb6] part of check-in [d78949fc93] Allow an index paired with an IS NULL constraint to be used for sorting under the condition that the index be treated as a non-unique index. (check-in: [d78949fc93] user: drh branch: trunk, size: 2599)
2009-04-24
20:32
[3da2f5c81b] part of check-in [3ceae3579b] Add another test case for the "x IS NULL" uniqueness problem of ticket #3824. No changes to code. This just double-checks that everything is working now. (CVS 6548) (check-in: [3ceae3579b] user: drh branch: trunk, size: 2597)
14:51
Added: [df7c288c9b] part of check-in [207335fdbf] Make sure that the optimizer realizes that an "x IS NULL" contraint does not necessarily give a single-row result even on a UNIQUE index. Ticket #3824. (CVS 6545) (check-in: [207335fdbf] user: drh branch: trunk, size: 2279)