Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/distinct2.test
|
2024-06-28
| ||
| 17:14 | [4d6316b648] part of check-in [fcb669cfaa] Do not convert an expression node that is already TK_REGISTER into a new TK_REGISTER. This is a follow-up to [663f5dd32d9db832] that fixes a bug discovered by dbsqlfuzz. (check-in: [fcb669cfaa] user: drh branch: trunk, size: 11327) | |
|
2024-06-03
| ||
| 18:04 | [931a242fcc] part of check-in [b37ac2d020] Address a corner-case associated with the call-function-once optimization of check-in [663f5dd32d9db832] that was causing a (harmless) use of an uninitialized bytecode register. dbsqlfuzz 8a44f675401a8b1f68a43bf813c4f4f72ad8f0ea (check-in: [b37ac2d020] user: drh branch: trunk, size: 10804) | |
|
2024-05-24
| ||
| 18:31 | [c936bb8652] part of check-in [4555d66547] Ensure that queries like "SELECT indeterministic(a) FROM tbl GROUP BY 1" invoke the indeterministic function only once for each row of tbl. (check-in: [4555d66547] user: dan branch: group-by-consistency, size: 9879) | |
|
2023-03-20
| ||
| 14:59 | [bb71cc7b5e] part of check-in [1b3abc1dae] Fix a problem causing a cursor to retain an out-of-date cell-info cache when processing a DISTINCT query on values that are identical according to their collation sequence, but different on disk. Forum post e123e6cde4. (check-in: [1b3abc1dae] user: dan branch: trunk, size: 9327) | |
|
2020-10-22
| ||
| 15:47 | [cd1d15a4a2] part of check-in [0f42099ad6] Sometimes it makes sense to do a full table scan rather than try to use an index when most of the rows will be selected. This branch is trying to tune the query planner to make that happen more often. (check-in: [0f42099ad6] user: drh branch: avoid-bad-indexes, size: 9053) | |
|
2019-10-29
| ||
| 16:18 | [11b0594c93] part of check-in [4d424f3047] 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: [4d424f3047] user: drh branch: trunk, size: 9049) | |
|
2019-08-21
| ||
| 14:54 | [b854b44211] part of check-in [d02490a2f0] Avoid assuming that "column IS ?", where column is declared UNIQUE, matches only a single row (as "?" might be NULL). Fix for [b8689402]. (check-in: [d02490a2f0] user: dan branch: trunk, size: 9050) | |
|
2019-07-29
| ||
| 14:42 | [1a01038083] part of check-in [b47169319a] 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: [b47169319a] user: dan branch: tkt-6749cb3c, size: 8486) | |
|
2017-11-23
| ||
| 00:45 | [df0bb52b75] part of check-in [b7595cf2ca] Completely disable the skip-ahead-distinct optimization for all but the inner-most loop of a DISTINCT join. Fix for ticket [ef9318757b152e3a26e9592] (check-in: [b7595cf2ca] user: drh branch: trunk, size: 7333) | |
|
2017-11-21
| ||
| 23:38 | [ba239e9674] part of check-in [2dcef5a9ae] 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: [2dcef5a9ae] user: drh branch: trunk, size: 6203) | |
|
2017-04-13
| ||
| 21:29 | [faef8a3f27] part of check-in [ce1e2b8877] Fix the skip-ahead-distinct optimization so that it works with indexes that have repeated columns with different collating sequences. (check-in: [ce1e2b8877] user: drh branch: skip-ahead-distinct, size: 5418) | |
| 18:33 | [5bf7cb4233] part of check-in [70ac9ea1a6] New test cases and minor fixes for the optimization on this branch. (check-in: [70ac9ea1a6] user: dan branch: skip-ahead-distinct, size: 4093) | |
|
2016-04-15
| ||
| 16:17 | [2d5245672d] part of check-in [db5a2364eb] Skip-ahead does not always work. So we still have to check for redundancy. (check-in: [db5a2364eb] user: drh branch: skip-ahead-distinct, size: 3123) | |
| 14:13 | [5ae90d12ee] part of check-in [0379f2cff6] Several new test cases that cause failures. (check-in: [0379f2cff6] user: drh branch: skip-ahead-distinct, size: 2907) | |
| 13:24 | Added: [7e3d6488f6] part of check-in [2afcb2c752] Fixed crash bugs. Still sometimes gets the wrong answers. (check-in: [2afcb2c752] user: drh branch: skip-ahead-distinct, size: 2027) | |