/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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