/ File History
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/tkt3824.test

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. file: [150aa00b] check-in: [d78949fc] user: drh branch: trunk, size: 2599
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) file: [3da2f5c8] check-in: [3ceae357] user: drh branch: trunk, size: 2597
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) file: [df7c288c] check-in: [207335fd] user: drh branch: trunk, size: 2279 Added