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