Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/minmax.test
2025-04-10
| ||
10:18 | [885d89737b] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 14917) | |
2021-08-21
| ||
16:42 | [fe638b55d7] part of check-in [600f1991e5] Defer deleting subqueries in the compound-SELECT code generator until the 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 post cfcb4b461d. The problem goes back to check-in [6e6b3729e0549de0]. (check-in: [600f1991e5] user: drh branch: trunk, size: 14921) | |
2021-04-07
| ||
15:45 | [0015e5cd5e] part of check-in [14b1d56ef8] Also prohibit the use of rowid from a subquery. Add the SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior in case somebody actually needs it. (check-in: [14b1d56ef8] user: drh branch: no-rowid-on-view, size: 14564) | |
2016-07-26
| ||
04:23 | [6751e87b40] part of check-in [0e9f534fef] Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. (check-in: [0e9f534fef] user: drh branch: apple-osx, size: 14438) | |
2012-12-13
| ||
16:37 | [42fbad0e81] part of check-in [7280e14cd8] 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. (check-in: [7280e14cd8] user: dan branch: minmax-opt, size: 14006) | |
2012-10-30
| ||
00:29 | [c61518429e] part of check-in [7af3acbbd4] Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. (check-in: [7af3acbbd4] user: drh branch: subquery-as-coroutine, size: 11468) | |
2008-07-08
| ||
18:05 | [722d80816f] part of check-in [fa07c360b7] Improved testing of the min/max optimization. (CVS 5373) (check-in: [fa07c360b7] user: drh branch: trunk, size: 11467) | |
2008-01-05
| ||
17:39 | [5d56f08a77] part of check-in [c449e04f18] First pass at optimizing max()/min() as described in #2853. Some refinements to come. (CVS 4687) (check-in: [c449e04f18] user: danielk1977 branch: trunk, size: 8681) | |
2006-03-26
| ||
01:21 | [66434d8ee0] part of check-in [80cda9f7ce] SQLite now always chooses the column names for compound selects using 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) (check-in: [80cda9f7ce] user: drh branch: trunk, size: 8673) | |
2005-09-08
| ||
19:45 | [cad887abca] part of check-in [2e6230edfd] A SUM() of all NULLs returns NULL. A SUM() of nothing return 0. A SUM() of a mixture of NULLs and numbers returns the sum of the numbers. Ticket #1413. (CVS 2677) (check-in: [2e6230edfd] user: drh branch: trunk, size: 8653) | |
10:37 | [1d6f6cd00b] part of check-in [21adf4bd99] The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) (check-in: [21adf4bd99] user: drh branch: trunk, size: 8641) | |
2005-01-21
| ||
04:25 | [9429a06f1f] part of check-in [d4e19efcef] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: [d4e19efcef] user: danielk1977 branch: trunk, size: 8661) | |
03:12 | [b723a302c8] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 8555) | |
2004-11-22
| ||
13:35 | [e704847694] part of check-in [007be591b7] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591b7] user: danielk1977 branch: trunk, size: 8031) | |
2004-08-20
| ||
18:34 | [c0f92d3f7b] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 7933) | |
2004-07-18
| ||
21:33 | [6513f9a1bb] part of check-in [b6e8b7a13c] An improved fix for the min() problem of ticket #800. (CVS 1804) (check-in: [b6e8b7a13c] user: drh branch: trunk, size: 7921) | |
21:14 | [9dc011a23b] part of check-in [223521c04e] Min() and max() ignore NULL values. Ticket #800. (CVS 1803) (check-in: [223521c04e] user: drh branch: version_2, size: 7923) | |
20:52 | [82fa0957d4] part of check-in [166234a2b6] min() ignores NULL values. Ticket #800. (CVS 1802) (check-in: [166234a2b6] user: drh branch: trunk, size: 7921) | |
2004-06-24
| ||
00:20 | [3f87d1d49f] part of check-in [0a26b91580] Apply (1679) to version 3. Ticket #777. (CVS 1680) (check-in: [0a26b91580] user: danielk1977 branch: trunk, size: 6888) | |
2004-06-23
| ||
21:16 | [db8cd0e865] part of check-in [78ced6e309] The MIN() aggregate function returns NULL if any element in the result was NULL. This makes MIN() consistent with ORDER BY which sorts NULL first. Ticket #777. (CVS 1679) (check-in: [78ced6e309] user: drh branch: version_2, size: 6883) | |
2004-03-13
| ||
14:00 | [9dcf52f713] part of check-in [31c94acc72] Fix the min/max optimizer so that it works when the FROM clause is a subquery. Ticket #658. (CVS 1293) (check-in: [31c94acc72] user: drh branch: trunk, size: 6237) | |
2004-02-25
| ||
13:47 | [d7da918301] part of check-in [adbe31adf1] Min() and max() functions honor the distinction between TEXT and NUMERIC data. Ticket #623. typeof() is now a user function. Some tests are now failing due to ticket #521. (CVS 1272) (check-in: [adbe31adf1] user: drh branch: trunk, size: 5861) | |
2004-01-30
| ||
02:01 | [6680b8d79b] part of check-in [af73fbca83] Make sure min() and max() optimizations work for subqueries. Ticket #587. (CVS 1201) (check-in: [af73fbca83] user: drh branch: trunk, size: 5314) | |
2003-07-19
| ||
00:44 | [6d9b6d6ee3] part of check-in [c35e507176] Make sure the min() and max() optimizer works correctly when there is a LIMIT clause. Ticket #396. (CVS 1057) (check-in: [c35e507176] user: drh branch: trunk, size: 4916) | |
2003-04-17
| ||
12:44 | [b54ac3bc45] part of check-in [98ef611006] Make sure the min() and max() optimizations work on empty indexed tables. Ticket #296. (CVS 914) (check-in: [98ef611006] user: drh branch: trunk, size: 4268) | |
2002-05-31
| ||
15:51 | [29bc5727c3] part of check-in [da61aa1d23] Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION. 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) (check-in: [da61aa1d23] user: drh branch: trunk, size: 3638) | |
2002-05-29
| ||
23:22 | [a234053455] part of check-in [19ae12bef2] Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597) (check-in: [19ae12bef2] user: drh branch: trunk, size: 3263) | |
2002-05-27
| ||
01:04 | [c50bcc7604] part of check-in [0e268d0c0f] Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) (check-in: [0e268d0c0f] user: drh branch: trunk, size: 3264) | |
2002-02-19
| ||
22:42 | Added: [fb6ab40027] part of check-in [1686196a8a] New ROWIDs are numbered sequentially. (CVS 383) (check-in: [1686196a8a] user: drh branch: trunk, size: 3097) | |