/ File History
Login
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/distinct2.test

2019-08-21
14:54
Avoid assuming that "column IS ?", where column is declared UNIQUE, matches only a single row (as "?" might be NULL). Fix for [b8689402]. file: [b854b442] check-in: [d02490a2] user: dan branch: trunk, size: 9050
2019-07-29
14:42
When using an index for both DISTINCT and ORDER BY, do not confuse the number of columns required for distinctness with the number required to get the correct sort order. Fix for [6749cb3c]. file: [1a010380] check-in: [b4716931] user: dan branch: tkt-6749cb3c, size: 8486
2017-11-23
00:45
Completely disable the skip-ahead-distinct optimization for all but the inner-most loop of a DISTINCT join. Fix for ticket [ef9318757b152e3a26e9592] file: [df0bb52b] check-in: [b7595cf2] user: drh branch: trunk, size: 7333
2017-11-21
23:38
Fix the skip-ahead-distinct optimization on joins for cases there the table in the inner loop of the join does not contribute any columns to the result set. Proposed fix for ticket [ef9318757b152e3a2] file: [ba239e96] check-in: [2dcef5a9] user: drh branch: trunk, size: 6203
2017-04-13
21:29
Fix the skip-ahead-distinct optimization so that it works with indexes that have repeated columns with different collating sequences. file: [faef8a3f] check-in: [ce1e2b88] user: drh branch: skip-ahead-distinct, size: 5418
18:33
New test cases and minor fixes for the optimization on this branch. file: [5bf7cb42] check-in: [70ac9ea1] user: dan branch: skip-ahead-distinct, size: 4093
2016-04-15
16:17
Skip-ahead does not always work. So we still have to check for redundancy. file: [2d524567] check-in: [db5a2364] user: drh branch: skip-ahead-distinct, size: 3123
14:13
Several new test cases that cause failures. file: [5ae90d12] check-in: [0379f2cf] user: drh branch: skip-ahead-distinct, size: 2907
13:24
Fixed crash bugs. Still sometimes gets the wrong answers. file: [7e3d6488] check-in: [2afcb2c7] user: drh branch: skip-ahead-distinct, size: 2027 Added