documentation edits needed

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

documentation edits needed

Mark Brand

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