pingcap
Document ANY and ALL comparison operators
Change Request
Please answer the following questions before submitting your issue. Thanks!
- Describe what you find is inappropriate or missing in the existing docs.
Not finding how cmp ANY/ALL (
) works
WHERE a > ANY (<subquery>) is not documented, except indirectly in dev-guide-use-subqueries or explain-subqueries [1],[2] or subquery-optimization.
It is also referenced as 'Expression Syntax' and 'DO' as AnyOrAll
-
Describe your suggestion or addition. It seems like it should be explain somewhere in 'Functions and Operators' or 'Expression Syntax'. I would suggest a separate page under Functions and Operators like 'Sub Queries' or 'Any and ALL Sub Queries' where it would be explained, as well as syntax explained in 'Expression Syntax, that AnyOrAll just means
ANYorALL, with reference to the new page. -
Provide some reference materials (such as documents and websites) if you could. See above.
Maybe also mention that SOME is an alias for ANY (only mentioning SOME in 'optimizer-hits' page.
Could not find anything about IN (<list>) or IN (<subquery>) either, more than for explain and optimizer hints etc. At least it is listed in Comparison functions and operators but links to the MySQL manual.