5 Commits

Author	SHA1	Message	Date
drh	90ab71bdc8	Fix a problem handling sub-queries with both a correlated WHERE clause and a "HAVING 0" clause where the parent query is itself an aggregate. ... The problem was apparently introduced by check-in [6e6b3729e0549de0] FossilOrigin-Name: 30a4c323650cc9498a6dacd1760dd5170d7cc7848c4e96ff6bd64da365f96366	2021-01-19 20:09:44 +00:00
drh	508e2d00f3	Fix unreachable conditionals and revise a testcase that was made obsolete by ... the changes on this branch. FossilOrigin-Name: 71f0adf7ca6824c3aba69104b9976dbb71b377474529e1a36220b4804293501e	2017-09-30 01:25:04 +00:00
drh	a690ff360b	Change the error message text for SQLITE_ERROR to omit the part about ... "missing database" as that meaning is now obsolete (since approx SQLite 2.0). FossilOrigin-Name: 732f90d6327c5c6368fc8b4cc207bd644ef08e3ae6d2e7295258ab099deaba63	2017-07-07 19:43:23 +00:00
dan	181a1167dc	Add extra tests for the optimization on this branch. ... FossilOrigin-Name: 4921cd9520080f9baff70e548f64a56e2204b398b8397a2d318a98c32ec4b00c	2017-05-01 14:09:32 +00:00
dan	ab31a8450b	Automatically transfer terms from the HAVING clause to the WHERE clause of an ... aggregate query in cases where the result of evaluating the term depends only one one or more of the GROUP BY expressions (and on no other inputs). FossilOrigin-Name: 5375a3ce56f1d993b13b469fe33ec7679948f53940f62a15ddbaeb8aaa26a22c	2017-04-29 20:53:09 +00:00