aboutsummaryrefslogtreecommitdiff
path: root/test/minmax.test
Commit message (Collapse)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
| | | FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
* Defer deleting subqueries in the compound-SELECT code generator until thedrh2021-08-21
| | | | | | | | end of code generation, in order to avoid deleting expressions out from under the aggregation function sanity checking assert()s that occur near the end of SELECT code generation. This fixes the assertion fault described by [forum:/forumpost/cfcb4b461d|forum post cfcb4b461d]. FossilOrigin-Name: 600f1991e5c0a5d89cd8776a157b6fd72c7489791085876925e8dd7ab146fe1f
* Also prohibit the use of rowid from a subquery. Add thedrh2021-04-07
| | | | | | SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior in case somebody actually needs it. FossilOrigin-Name: 14b1d56ef84b0e62b7f9c4e5f7f985ca10e770c8db59f54004ad892c2a2dcbfb
* Make sure affinity is applied correctly on lower-bound range constraintsdrh2016-07-26
| | | | | in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. FossilOrigin-Name: b819bace9c2a0b0159122b26db96a8f50a6f0eac
* Attempt to further generalize the min/max optimization so that, if an ↵dan2012-12-13
| | | | | 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. FossilOrigin-Name: 7280e14cd8f55896451847b432171e8750a07c81
* Add an optimization that attempts to run a subquery as a coroutine ratherdrh2012-10-30
| | | | | than manifesting it into a temporary table. FossilOrigin-Name: 7af3acbbd49a2114fcdada9ec907c68ba9b053bd
* Improved testing of the min/max optimization. (CVS 5373)drh2008-07-08
| | | FossilOrigin-Name: fa07c360b708324c47c8e9931f1e2b1b24e4faf8
* First pass at optimizing max()/min() as described in #2853. Some refinements ↵danielk19772008-01-05
| | | | | to come. (CVS 4687) FossilOrigin-Name: c449e04f1870b1ff726c95c0bf1c6c6a22ca588a
* SQLite now always chooses the column names for compound selects usingdrh2006-03-26
| | | | | | | the left-most select. This makes SQLite work like other SQL database, but it also is a change from historical behavior and may break some scripts. Ticket #1721. (CVS 3153) FossilOrigin-Name: 80cda9f7ce83f2de6cd2fdaf6150bbc35b670fee
* A SUM() of all NULLs returns NULL. A SUM() of nothing return 0.drh2005-09-08
| | | | | | A SUM() of a mixture of NULLs and numbers returns the sum of the numbers. Ticket #1413. (CVS 2677) FossilOrigin-Name: 2e6230edfd651b40481ebad8aa01a22ac92ce80c
* The SUM() aggregate function returns an integer result if all inputs aredrh2005-09-08
| | | | | | integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) FossilOrigin-Name: 21adf4bd99e732650a1e8e9a1cc954126983a654
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT ↵danielk19772005-01-21
| | | | | macros) is defined. (CVS 2252) FossilOrigin-Name: d4e19efcef68d834c55c7d496cdb3696d63a31a2
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT ↵danielk19772005-01-21
| | | | | macros) is defined. (CVS 2251) FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a
* Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138)danielk19772004-11-22
| | | FossilOrigin-Name: 007be591b7829f9ff38e4b14ba5a5043796c2ff3
* Tcl interface transfers values directly between SQLite and Tcl_Objs, withoutdrh2004-08-20
| | | | | at translation to strings. (CVS 1898) FossilOrigin-Name: e97c331362545ce21117776c7b61d3488668f2bf
* An improved fix for the min() problem of ticket #800. (CVS 1804)drh2004-07-18
| | | FossilOrigin-Name: b6e8b7a13cd9f90e2f7d963d9ddbe591571f3a27
* min() ignores NULL values. Ticket #800. (CVS 1802)drh2004-07-18
| | | FossilOrigin-Name: 166234a2b61e1d6a501e48dde1caec0a02bec90b
* Apply (1679) to version 3. Ticket #777. (CVS 1680)danielk19772004-06-24
| | | FossilOrigin-Name: 0a26b9158095f0995fce2f0ccdfb383ab26c76a5
* Fix the min/max optimizer so that it works when the FROM clause is adrh2004-03-13
| | | | | subquery. Ticket #658. (CVS 1293) FossilOrigin-Name: 31c94acc72d318b5dec0fef1485621943add45c8
* Min() and max() functions honor the distinction between TEXT and NUMERICdrh2004-02-25
| | | | | | data. Ticket #623. typeof() is now a user function. Some tests are now failing due to ticket #521. (CVS 1272) FossilOrigin-Name: adbe31adf1ad0ca723203ca3d7dc480324c60d43
* Make sure min() and max() optimizations work for subqueries. Ticket #587. ↵drh2004-01-30
| | | | | (CVS 1201) FossilOrigin-Name: af73fbca839f8cbe39c21f1f9e439fe9b79005c8
* Make sure the min() and max() optimizer works correctly when theredrh2003-07-19
| | | | | is a LIMIT clause. Ticket #396. (CVS 1057) FossilOrigin-Name: c35e50717678703763c696e3e9b265add2ca6454
* Make sure the min() and max() optimizations work on empty indexed tables.drh2003-04-17
| | | | | Ticket #296. (CVS 914) FossilOrigin-Name: 98ef6110068e5ed3cd77a14b004f890b79b731f7
* Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION.drh2002-05-31
| | | | | | | Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison is considered false, not NULL. With these changes, NULLs in SQLite now work the same as in PostgreSQL and in Oracle. (CVS 600) FossilOrigin-Name: da61aa1d238539dff9c43fd9f464d311e28d669f
* Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL ↵drh2002-05-29
| | | | | entires. (CVS 597) FossilOrigin-Name: 19ae12bef210ae5fe171f10833faa38d640c129f
* Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592)drh2002-05-27
| | | FossilOrigin-Name: 0e268d0c0faa02c3f95e1567cf631b7a04bfbdf0
* New ROWIDs are numbered sequentially. (CVS 383)drh2002-02-19
FossilOrigin-Name: 1686196a8aea326f616bc8205df99cd84d955ec4
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-20 14:40:04 +0000