/ File History
Login

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

History of test/distinct.test

2020-03-23
19:14
[e7d0cf37] part of check-in [aee1c12f] Further simplification and modularization of the EXPLAIN logic. (check-in: [aee1c12f] user: drh branch: bytecode-function, size: 9174)
2020-01-06
17:06
[8b6c652f] part of check-in [1409758f] Ensure the SF_Aggregate flag on a SELECT statement is set if a DISTINCT is transformed to a GROUP BY. Ticket [9c944882]. (check-in: [1409758f] user: dan branch: trunk, size: 9187)
2018-04-17
16:16
[fd7cebcc] part of check-in [907b5a37] New test cases for upsert. (check-in: [907b5a37] user: drh branch: upsert, size: 8576)
2015-11-24
02:10
[a1783b96] part of check-in [824ad96f] Remove an incorrect ALWAYS() macro. Fix for ticket [e5c6268dd807fa8950] - a problem introduced in SQLite 3.9.0 and found by libFuzzer. (check-in: [824ad96f] user: drh branch: trunk, size: 8576)
2014-12-04
21:54
[175d49ee] part of check-in [0d3aef97] 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: [0d3aef97] user: drh branch: trunk, size: 8107)
2014-03-19
23:24
[086e70c7] part of check-in [01afbf97] 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: [01afbf97] user: drh branch: orderby-planning, size: 7197)
2014-02-08
19:12
[c7b194ef] part of check-in [e2303d1b] Change the OP_Found opcode so that it expands zero-blobs prior to comparing them. Fix for ticket [fccbde530a6583b] (check-in: [e2303d1b] user: drh branch: trunk, size: 7197)
2014-02-05
18:15
[b9f34f38] part of check-in [2997e181] 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: [2997e181] user: drh branch: subquery-codegen-refactor, size: 6318)
2013-06-12
17:08
[44028aaf] part of check-in [addd7f46] "make test" now passing. (check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 6394)
2012-12-08
03:34
[84da1414] part of check-in [7b96115e] Veryquick passes all tests now. (check-in: [7b96115e] user: drh branch: ticket-71e333e7, size: 6394)
2012-09-19
21:15
[c2395582] part of check-in [94b48064] Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword handling. (check-in: [94b48064] user: drh branch: trunk, size: 6394)
2012-09-15
18:45
[328c3930] part of check-in [cfaa7bc1] 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: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 5954)
2012-04-20
16:59
[da36612d] part of check-in [7b8548b1] 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: [7b8548b1] user: dan branch: trunk, size: 5939)
2012-02-13
10:00
[8c6d12ba] part of check-in [76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649e] user: dan branch: trunk, size: 5353)
2012-01-17
15:29
[76908ed0] part of check-in [96900c47] Remove the undocumented PRAGMA omit_readlock hack. (check-in: [96900c47] user: drh branch: trunk, size: 5305)
2011-09-01
16:01
[df5b11ad] part of check-in [ebf819aa] Use OP_SorterOpen instead of OP_OpenEphemeral to implement GROUP BY. (check-in: [ebf819aa] user: drh branch: merge-sort, size: 5305)
2011-07-02
13:34
[b3c4ebe6] part of check-in [c593792c] Cherrypick [45e581bff7] into the 3.7.2 branch. (check-in: [c593792c] user: dan branch: branch-3.7.2, size: 5408) Added
06:44
[8c4d951f] part of check-in [090b2917] Fix a broken assert() in where.c. (check-in: [090b2917] user: dan branch: experimental, size: 5278)
2011-07-01
18:26
[dbedaddb] part of check-in [6c202ea0] Improve use of indexes to optimize DISTINCT queries. (check-in: [6c202ea0] user: dan branch: experimental, size: 5186)
14:21
[17985484] part of check-in [7337293c] Improvements and tests for detection of redundant DISTINCT qualifiers. (check-in: [7337293c] user: dan branch: experimental, size: 3422) Added