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

COMMITS

/ test/minmax.test
autosetup
August 21, 2021
D
Defer deleting subqueries in the compound-SELECT code generator until the
drh committed
ce68b6b
April 7, 2021
D
Also prohibit the use of rowid from a subquery. Add the
drh committed
6e5020e
July 26, 2016
D
Make sure affinity is applied correctly on lower-bound range constraints
drh committed
426f4ab
December 13, 2012
D
Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or min(colname) and does not contain a GROUP BY clause.
dan committed
4ac391f
October 30, 2012
D
Add an optimization that attempts to run a subquery as a coroutine rather
drh committed
21172c4
July 8, 2008
D
Improved testing of the min/max optimization. (CVS 5373)
drh committed
0880a74
January 5, 2008
D
First pass at optimizing max()/min() as described in #2853. Some refinements to come. (CVS 4687)
danielk1977 committed
a9d1ccb
March 26, 2006
D
SQLite now always chooses the column names for compound selects using
drh committed
9237825
September 8, 2005
D
A SUM() of all NULLs returns NULL. A SUM() of nothing return 0.
drh committed
3f219f4
D
The SUM() aggregate function returns an integer result if all inputs are
drh committed
3d1d95e
January 21, 2005
D
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252)
danielk1977 committed
e61b9f4
D
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251)
danielk1977 committed
3e8c37e
November 22, 2004
D
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138)
danielk1977 committed
27c7743
August 20, 2004
D
Tcl interface transfers values directly between SQLite and Tcl_Objs, without
drh committed
92febd9
July 18, 2004
D
An improved fix for the min() problem of ticket #800. (CVS 1804)
drh committed
1af3fdb
D
min() ignores NULL values. Ticket #800. (CVS 1802)
drh committed
9eb516c
June 24, 2004
D
Apply (1679) to version 3. Ticket #777. (CVS 1680)
danielk1977 committed
3aeab9e
March 13, 2004
D
Fix the min/max optimizer so that it works when the FROM clause is a
drh committed
6e17529
February 25, 2004
D
Min() and max() functions honor the distinction between TEXT and NUMERIC
drh committed
268380c
January 30, 2004
D
Make sure min() and max() optimizations work for subqueries. Ticket #587. (CVS 1201)
drh committed
0c37e63
July 19, 2003
D
Make sure the min() and max() optimizer works correctly when there
drh committed
e5f5072
April 17, 2003
D
Make sure the min() and max() optimizations work on empty indexed tables.
drh committed
d4d595f
May 31, 2002
D
Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION.
drh committed
f570f01
May 29, 2002
D
Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597)
drh committed
739105c
May 27, 2002
D
Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592)
drh committed
bb11351
February 19, 2002
D
New ROWIDs are numbered sequentially. (CVS 383)
drh committed
5cf8e8c