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
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
sqlite-users mailing list