6 Commits

Author	SHA1	Message	Date
drh	175b8f06f7	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. FossilOrigin-Name: 1e17ea2fd1df4ad49138c787c8fe3207dd0c25c93f9001d52a9b69f8c12e841c	2019-08-08 15:24:17 +00:00
dan	192418bd49	Fix a problem with queries of the form "SELECT min(<expr>) ... WHERE <expr>=?" where there is an index on <expr>. Fix for [71e183ca]. ... FossilOrigin-Name: d465c3eef458c851d97eea6e4117247d9c69386b276168080dbff7bb64070c93	2019-08-03 16:37:40 +00:00
dan	ddd7421c91	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]. ... FossilOrigin-Name: a7277ed0623dccdbf775ae6127611d6bc6e150f6942a048ab4281e5136c0e98d	2019-08-02 18:43:59 +00:00
drh	9588ad95c1	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. FossilOrigin-Name: 0bdf1a086b3946722f4d4b328e25917f61c14713	2014-09-15 14:46:02 +00:00
dan	2f56da3f26	Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. ... FossilOrigin-Name: 76bb649ee2633226324130f5898622c348f93769	2012-02-13 10:00:35 +00:00
drh	94a6d998f6	Fix a problem with NULL handling in aggregate min/max when returning ... values from the row containing the min or max. FossilOrigin-Name: f27c7b4fb193126548e6a620ac89664d1efa3856	2012-02-02 18:42:09 +00:00