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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
