/ All files named "test/minmax4.test"
Login

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

History for test/minmax4.test

2019-08-17
18:16
[272ca395] part of check-in [f8920664] Add tests to ensure that this branch really does fix ticket [f8a7060ece]. (check-in: [f8920664] user: dan branch: nulls-last, size: 5155)
2019-08-08
15:24
[838fe32b] part of check-in [1e17ea2f] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 4342)
2019-08-03
16:37
[325f0fcc] part of check-in [d465c3ee] Fix a problem with queries of the form "SELECT min(<expr>) ... WHERE <expr>=?" where there is an index on <expr>. Fix for [71e183ca]. (check-in: [d465c3ee] user: dan branch: trunk, size: 4343)
2019-08-02
18:43
[be0b227f] part of check-in [a7277ed0] If a query like "SELECT min(a), b FROM t1" visits no rows where "a" is not null, extract a value for "b" from one of the rows where "a" is null. Possible fix for ticket [41866dc37]. (check-in: [a7277ed0] user: dan branch: tkt-41866dc37, size: 3769)
2014-09-15
14:46
[93694148] part of check-in [0bdf1a08] Do not flatten aggregate subqueries that contain min() or max() functions so that if the min()/max() are discarded by the outer query, they still function and cause non-aggregate expression to be evaluated on the minimal or maximal row. (check-in: [0bdf1a08] user: drh branch: trunk, size: 3085)
2012-02-13
10:00
[536a3360] part of check-in [76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649e] user: dan branch: trunk, size: 2941)
2012-02-02
18:42
Added: [c1fa9505] part of check-in [f27c7b4f] Fix a problem with NULL handling in aggregate min/max when returning values from the row containing the min or max. (check-in: [f27c7b4f] user: drh branch: output-minmax-row, size: 2893)