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