Morph MORPH
SIGN IN SIGN UP
dhruvhead / sqlite UNCLAIMED
0 0 244 C

COMMITS

/ test/distinct.test
autosetup
March 16, 2023
D
Correctly handle SELECT DISTINCT ... ORDER BY when all of the result set terms
drh committed
b816ca9
March 16, 2022
D
Add extra test cases.
dan committed
247d094
April 7, 2021
D
Do not allow the use of rowid for views and subqueries unless compiled
drh committed
4ad9673
D
Also prohibit the use of rowid from a subquery. Add the
drh committed
6e5020e
April 6, 2021
D
Do not apply the optimization that omits DISTINCT if all result terms are
drh committed
204b634
March 24, 2021
D
Comment improvements to on the distinct-agg optimization. Show a line in
drh committed
9be1339
March 23, 2020
D
Further simplification and modularization of the EXPLAIN logic.
drh committed
cb49f54
January 6, 2020
D
Ensure the SF_Aggregate flag on a SELECT statement is set if a DISTINCT is transformed to a GROUP BY. Ticket [9c944882].
dan committed
9e10f9a
April 18, 2018
D
Fix a test case inside distinct.test.
drh committed
4e8b992
April 17, 2018
D
New test cases for upsert.
drh committed
5015c9b
November 24, 2015
D
Remove an incorrect ALWAYS() macro. Fix for ticket [e5c6268dd807fa8950] -
drh committed
2edc5fd
December 4, 2014
D
Make sure that a DISTINCT query with an ORDER BY works correctly even if
drh committed
dea7d70
March 19, 2014
D
Fix query planner weights associated with choosing block-sorting. Fix
drh committed
6284db9
February 8, 2014
D
Change the OP_Found opcode so that it expands zero-blobs prior to comparing
drh committed
826af37
June 12, 2013
D
"make test" now passing.
drh committed
4fe425a
December 8, 2012
D
Veryquick passes all tests now.
drh committed
580c8c1
September 19, 2012
D
Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword
drh committed
053a128
September 15, 2012
D
Attempt to use a covering index even on a full table scan, under the theory
drh committed
3f4d1d1
April 20, 2012
D
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].
dan committed
6a36f43
February 13, 2012
D
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.
dan committed
2f56da3
January 17, 2012
D
Remove the undocumented PRAGMA omit_readlock hack.
drh committed
33f111d
September 1, 2011
D
Use OP_SorterOpen instead of OP_OpenEphemeral to implement GROUP BY.
drh committed
1c9d835
July 2, 2011
D
Fix a broken assert() in where.c.
dan committed
94e08d9
July 1, 2011
D
Improve use of indexes to optimize DISTINCT queries.
dan committed
6f34396
D
Improvements and tests for detection of redundant DISTINCT qualifiers.
dan committed
50118cd