/ File History
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of test/minmax.test

2016-07-26
04:23
[6751e87b] part of check-in [0e9f534f] Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. (check-in: [0e9f534f] user: drh branch: apple-osx, size: 14438)
2012-12-13
16:37
[42fbad0e] part of check-in [7280e14c] 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: [7280e14c] user: dan branch: minmax-opt, size: 14006)
2012-10-30
00:29
[c6151842] part of check-in [7af3acbb] Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. (check-in: [7af3acbb] user: drh branch: subquery-as-coroutine, size: 11468)
2008-07-08
18:05
[722d8081] part of check-in [fa07c360] Improved testing of the min/max optimization. (CVS 5373) (check-in: [fa07c360] user: drh branch: trunk, size: 11467)
2008-01-05
17:39
[5d56f08a] part of check-in [c449e04f] First pass at optimizing max()/min() as described in #2853. Some refinements to come. (CVS 4687) (check-in: [c449e04f] user: danielk1977 branch: trunk, size: 8681)
2006-03-26
01:21
[66434d8e] part of check-in [80cda9f7] 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: [80cda9f7] user: drh branch: trunk, size: 8673)
2005-09-08
19:45
[cad887ab] part of check-in [2e6230ed] 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: [2e6230ed] user: drh branch: trunk, size: 8653)
10:37
[1d6f6cd0] part of check-in [21adf4bd] 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: [21adf4bd] user: drh branch: trunk, size: 8641)
2005-01-21
04:25
[9429a06f] part of check-in [d4e19efc] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 8661)
03:12
[b723a302] part of check-in [bb0254ab] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 8555)
2004-11-22
13:35
[e7048476] part of check-in [007be591] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591] user: danielk1977 branch: trunk, size: 8031)
2004-08-20
18:34
[c0f92d3f] part of check-in [e97c3313] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c3313] user: drh branch: trunk, size: 7933)
2004-07-18
21:33
[6513f9a1] part of check-in [b6e8b7a1] An improved fix for the min() problem of ticket #800. (CVS 1804) (check-in: [b6e8b7a1] user: drh branch: trunk, size: 7921)
21:14
[9dc011a2] part of check-in [223521c0] Min() and max() ignore NULL values. Ticket #800. (CVS 1803) (check-in: [223521c0] user: drh branch: version_2, size: 7923)
20:52
[82fa0957] part of check-in [166234a2] min() ignores NULL values. Ticket #800. (CVS 1802) (check-in: [166234a2] user: drh branch: trunk, size: 7921)
2004-06-24
00:20
[3f87d1d4] part of check-in [0a26b915] Apply (1679) to version 3. Ticket #777. (CVS 1680) (check-in: [0a26b915] user: danielk1977 branch: trunk, size: 6888)
2004-06-23
21:16
[db8cd0e8] part of check-in [78ced6e3] 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: [78ced6e3] user: drh branch: version_2, size: 6883)
2004-03-13
14:00
[9dcf52f7] part of check-in [31c94acc] Fix the min/max optimizer so that it works when the FROM clause is a subquery. Ticket #658. (CVS 1293) (check-in: [31c94acc] user: drh branch: trunk, size: 6237)
2004-02-25
13:47
[d7da9183] part of check-in [adbe31ad] 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: [adbe31ad] user: drh branch: trunk, size: 5861)
2004-01-30
02:01
[6680b8d7] part of check-in [af73fbca] Make sure min() and max() optimizations work for subqueries. Ticket #587. (CVS 1201) (check-in: [af73fbca] user: drh branch: trunk, size: 5314)
2003-07-19
00:44
[6d9b6d6e] part of check-in [c35e5071] Make sure the min() and max() optimizer works correctly when there is a LIMIT clause. Ticket #396. (CVS 1057) (check-in: [c35e5071] user: drh branch: trunk, size: 4916)
2003-04-17
12:44
[b54ac3bc] part of check-in [98ef6110] Make sure the min() and max() optimizations work on empty indexed tables. Ticket #296. (CVS 914) (check-in: [98ef6110] user: drh branch: trunk, size: 4268)
2002-05-31
15:51
[29bc5727] part of check-in [da61aa1d] 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: [da61aa1d] user: drh branch: trunk, size: 3638)
2002-05-29
23:22
[a2340534] part of check-in [19ae12be] Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597) (check-in: [19ae12be] user: drh branch: trunk, size: 3263)
2002-05-27
01:04
[c50bcc76] part of check-in [0e268d0c] Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) (check-in: [0e268d0c] user: drh branch: trunk, size: 3264)
2002-02-19
22:42
[fb6ab400] part of check-in [1686196a] New ROWIDs are numbered sequentially. (CVS 383) (check-in: [1686196a] user: drh branch: trunk, size: 3097) Added