Just to be sure, is it unsafe to write a non agregate SELECT with GROUP BY and HAVING clauses (without sub-SELECT) for the sole prupose explained before (even if the approache is discutable) ?

I understand 2 different answers here :

- "No, this kind of query can't be rewritten by the optimizer for the technical reasons (VDBE, index etc)"

- "Yes it is unsafe, a future version of SQLite may optimize differently this kind of query"

I can't see something related to my problem in the doc https://sqlite.org/optoverview.html
sqlite-users mailing list

Reply via email to