Query Planner GROUP BY and HAVING clauses optimization ?

Jean-Baptiste Gardette <[email protected]> Tue, 14 Jan 2020 14:57:30 +0100

Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<[email protected]>

Hi,
Consider the following exemple :

CREATE TABLE t1 (
a TEXT PRIMARY KEY,
b INTEGER);

SELECT *
FROM t1
GROUP BY a
HAVING b > 1;

Will the GROUP BY clause be supressed and HAVING clause be rewritten in 
WHERE clause by the optimizer ?

Jean-Baptiste
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users