SQLite

All files named ”test/distinct.test”
Login

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

History for test/distinct.test

2023-03-16
20:54
[691c9e850b] part of check-in [12ad822d9b] Correctly handle SELECT DISTINCT ... ORDER BY when all of the result set terms are constant and there are more result set terms than ORDER BY terms. Fix for these tickets: [c36cdb4afd504dc1], [4051a7f931d9ba24], [d6fd512f50513ab7]. (check-in: [12ad822d9b] user: drh branch: trunk, size: 15475)
2022-03-16
19:28
[a7687c2fb5] part of check-in [0a922d1417] Add extra test cases. (check-in: [0a922d1417] user: dan branch: vtab-distinct-ordered, size: 10551)
2021-04-07
18:17
[3e4210ef9c] part of check-in [a2ddb89b20] Do not allow the use of rowid for views and subqueries unless compiled with -DSQLITE_ALLOW_ROWID_IN_VIEW. (check-in: [a2ddb89b20] user: drh branch: trunk, size: 9443)
15:45
[cfe34694ed] part of check-in [14b1d56ef8] Also prohibit the use of rowid from a subquery. Add the SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior in case somebody actually needs it. (check-in: [14b1d56ef8] user: drh branch: no-rowid-on-view, size: 9144)
2021-04-06
23:29
[86ad8e57d8] part of check-in [c2f940b028] Do not apply the optimization that omits DISTINCT if all result terms are part of a UNIQUE index if the index is also a partial index. Fix for the bug reported by forum post 66954e9ece. (check-in: [c2f940b028] user: drh branch: trunk, size: 9520)
2021-03-24
19:44
[eefe5a8e47] part of check-in [037ca79e60] Comment improvements to on the distinct-agg optimization. Show a line in the EQP output when using an ephemeral table to implement DISTINCT on an aggregate. (check-in: [037ca79e60] user: drh branch: trunk, size: 9221)
2020-03-23
19:14
[e7d0cf3719] part of check-in [aee1c12f42] Further simplification and modularization of the EXPLAIN logic. (check-in: [aee1c12f42] user: drh branch: bytecode-function, size: 9174)
2020-01-06
17:06
[8b6c652f0b] part of check-in [1409758f72] Ensure the SF_Aggregate flag on a SELECT statement is set if a DISTINCT is transformed to a GROUP BY. Ticket [9c944882]. (check-in: [1409758f72] user: dan branch: trunk, size: 9187)
2018-04-17
16:16
[fd7cebccde] part of check-in [907b5a37c5] New test cases for upsert. (check-in: [907b5a37c5] user: drh branch: upsert, size: 8576)
2015-11-24
02:10
[a1783b960a] part of check-in [824ad96f72] Remove an incorrect ALWAYS() macro. Fix for ticket [e5c6268dd807fa8950] - a problem introduced in SQLite 3.9.0 and found by libFuzzer. (check-in: [824ad96f72] user: drh branch: trunk, size: 8576)
2014-12-04
21:54
[175d49ee78] part of check-in [0d3aef97eb] Make sure that a DISTINCT query with an ORDER BY works correctly even if it uses a descending index. Fix for ticket [c5ea805691bfc4204b1cb9e]. (check-in: [0d3aef97eb] user: drh branch: trunk, size: 8107)
2014-03-19
23:24
[086e70c765] part of check-in [01afbf97c0] Fix query planner weights associated with choosing block-sorting. Fix block sorting of tables with collating functions. Fix various test cases. All "veryquick" tests are now passing, though more tests need to be added. (check-in: [01afbf97c0] user: drh branch: orderby-planning, size: 7197)
2014-02-08
19:12
[c7b194ef95] part of check-in [e2303d1b0c] Change the OP_Found opcode so that it expands zero-blobs prior to comparing them. Fix for ticket [fccbde530a6583b] (check-in: [e2303d1b0c] user: drh branch: trunk, size: 7197)
2014-02-05
18:15
[b9f34f3827] part of check-in [2997e18157] Use a new opcode, OP_OpenHash, to indicate that ephemeral tables can be unordered, rather than using the BTREE_UNORDERED bit in the P5 field. (check-in: [2997e18157] user: drh branch: subquery-codegen-refactor, size: 6318)
2013-06-12
17:08
[44028aaf16] part of check-in [addd7f466d] "make test" now passing. (check-in: [addd7f466d] user: drh branch: nextgen-query-plan-exp, size: 6394)
2012-12-08
03:34
[84da1414b2] part of check-in [7b96115e81] Veryquick passes all tests now. (check-in: [7b96115e81] user: drh branch: ticket-71e333e7, size: 6394)
2012-09-19
21:15
[c239558222] part of check-in [94b48064db] Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword handling. (check-in: [94b48064db] user: drh branch: trunk, size: 6394)
2012-09-15
18:45
[328c3930fc] part of check-in [cfaa7bc128] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 5954)
2012-04-20
16:59
[da36612d05] part of check-in [7b8548b187] Do not consider a DISTINCT clause redundant unless a subset of the result-set is collectively subject to a UNIQUE constraint and it can be guaranteed that all columns of the subset are NOT NULL (either due to NOT NULL constraints WHERE clause terms). Fix for [385a5b56b9]. (check-in: [7b8548b187] user: dan branch: trunk, size: 5939)
2012-02-13
10:00
[8c6d12ba53] part of check-in [76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649ee2] user: dan branch: trunk, size: 5353)
2012-01-17
15:29
[76908ed038] part of check-in [96900c47e4] Remove the undocumented PRAGMA omit_readlock hack. (check-in: [96900c47e4] user: drh branch: trunk, size: 5305)
2011-09-01
16:01
[df5b11ad60] part of check-in [ebf819aaa5] Use OP_SorterOpen instead of OP_OpenEphemeral to implement GROUP BY. (check-in: [ebf819aaa5] user: drh branch: merge-sort, size: 5305)
2011-07-02
13:34
Added: [b3c4ebe6db] part of check-in [c593792ce0] Cherrypick [45e581bff7] into the 3.7.2 branch. (check-in: [c593792ce0] user: dan branch: branch-3.7.2, size: 5408)
06:44
[8c4d951fc4] part of check-in [090b29177f] Fix a broken assert() in where.c. (check-in: [090b29177f] user: dan branch: experimental, size: 5278)
2011-07-01
18:26
[dbedaddb15] part of check-in [6c202ea024] Improve use of indexes to optimize DISTINCT queries. (check-in: [6c202ea024] user: dan branch: experimental, size: 5186)
14:21
Added: [1798548479] part of check-in [7337293c87] Improvements and tests for detection of redundant DISTINCT qualifiers. (check-in: [7337293c87] user: dan branch: experimental, size: 3422)