Re: Query Planner GROUP BY and HAVING clauses optimization ?
Dominique Devienne <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAFCRh--371tACzX4NV=ecDK0Mo8sOJEXh42Df0KDeZbdgPAkYA@mail.gmail.com> |
On Tue, Jan 14, 2020 at 2:57 PM Jean-Baptiste Gardette <[email protected]> wrote: > 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 ? My question would be why you wouldn't write it as a WHERE clause in the first place :) Sorry, OT, I know. --DD _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users