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