Here are some suggested improvements for the constraints listed under:
https://www.sqlite.org/optoverview.html, section 10. Subquery
flattening
3. The subquery is not the right operand of a LEFT JOIN then the
subquery may not be a join, the FROM clause of the subquery may not
contain a virtual table, and the outer query may not be an aggregate.
Missing "If" and comma before "then". (This one is particularly hard for
me to parse as-is.)
15. The outer query is part of a compound select, then the subquery
may not have a LIMIT clause.
Missing "If.."
16. The outer query is an aggregate, then the subquery may not contain
ORDER BY.
Missing "If.."
17. The sub-query is a compound SELECT, then...
Missing "If.."
21. The subquery uses LIMIT, then the outer query may not be DISTINCT.
Missing "If.."
22. The subquery may not a recursive CTE.
Should read "..may not be..".
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
