/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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