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