/ File History
Login

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

History of test/distinct2.test

2019-10-29
16:18
[11b0594c] part of check-in [4d424f30] Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] (check-in: [4d424f30] user: drh branch: trunk, size: 9049)
2019-08-21
14:54
[b854b442] part of check-in [d02490a2] Avoid assuming that "column IS ?", where column is declared UNIQUE, matches only a single row (as "?" might be NULL). Fix for [b8689402]. (check-in: [d02490a2] user: dan branch: trunk, size: 9050)
2019-07-29
14:42
[1a010380] part of check-in [b4716931] 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]. (check-in: [b4716931] user: dan branch: tkt-6749cb3c, size: 8486)
2017-11-23
00:45
[df0bb52b] part of check-in [b7595cf2] Completely disable the skip-ahead-distinct optimization for all but the inner-most loop of a DISTINCT join. Fix for ticket [ef9318757b152e3a26e9592] (check-in: [b7595cf2] user: drh branch: trunk, size: 7333)
2017-11-21
23:38
[ba239e96] part of check-in [2dcef5a9] 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] (check-in: [2dcef5a9] user: drh branch: trunk, size: 6203)
2017-04-13
21:29
[faef8a3f] part of check-in [ce1e2b88] Fix the skip-ahead-distinct optimization so that it works with indexes that have repeated columns with different collating sequences. (check-in: [ce1e2b88] user: drh branch: skip-ahead-distinct, size: 5418)
18:33
[5bf7cb42] part of check-in [70ac9ea1] New test cases and minor fixes for the optimization on this branch. (check-in: [70ac9ea1] user: dan branch: skip-ahead-distinct, size: 4093)
2016-04-15
16:17
[2d524567] part of check-in [db5a2364] Skip-ahead does not always work. So we still have to check for redundancy. (check-in: [db5a2364] user: drh branch: skip-ahead-distinct, size: 3123)
14:13
[5ae90d12] part of check-in [0379f2cf] Several new test cases that cause failures. (check-in: [0379f2cf] user: drh branch: skip-ahead-distinct, size: 2907)
13:24
[7e3d6488] part of check-in [2afcb2c7] Fixed crash bugs. Still sometimes gets the wrong answers. (check-in: [2afcb2c7] user: drh branch: skip-ahead-distinct, size: 2027) Added