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 | |