aboutsummaryrefslogtreecommitdiff
path: root/test/minmax.test
Commit message (Expand)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
* Defer deleting subqueries in the compound-SELECT code generator until thedrh2021-08-21
* Also prohibit the use of rowid from a subquery. Add thedrh2021-04-07
* Make sure affinity is applied correctly on lower-bound range constraintsdrh2016-07-26
* Attempt to further generalize the min/max optimization so that, if an appropr...dan2012-12-13
* Add an optimization that attempts to run a subquery as a coroutine ratherdrh2012-10-30
* Improved testing of the min/max optimization. (CVS 5373)drh2008-07-08
* First pass at optimizing max()/min() as described in #2853. Some refinements ...danielk19772008-01-05
* SQLite now always chooses the column names for compound selects usingdrh2006-03-26
* A SUM() of all NULLs returns NULL. A SUM() of nothing return 0.drh2005-09-08
* The SUM() aggregate function returns an integer result if all inputs aredrh2005-09-08
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macr...danielk19772005-01-21
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT ...danielk19772005-01-21
* Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138)danielk19772004-11-22
* Tcl interface transfers values directly between SQLite and Tcl_Objs, withoutdrh2004-08-20
* An improved fix for the min() problem of ticket #800. (CVS 1804)drh2004-07-18
* min() ignores NULL values. Ticket #800. (CVS 1802)drh2004-07-18
* Apply (1679) to version 3. Ticket #777. (CVS 1680)danielk19772004-06-24
* Fix the min/max optimizer so that it works when the FROM clause is adrh2004-03-13
* Min() and max() functions honor the distinction between TEXT and NUMERICdrh2004-02-25
* Make sure min() and max() optimizations work for subqueries. Ticket #587. (CV...drh2004-01-30
* Make sure the min() and max() optimizer works correctly when theredrh2003-07-19
* Make sure the min() and max() optimizations work on empty indexed tables.drh2003-04-17
* Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION.drh2002-05-31
* Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires....drh2002-05-29
* Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592)drh2002-05-27
* New ROWIDs are numbered sequentially. (CVS 383)drh2002-02-19