pingcap / pingcap/docs

Document ANY and ALL comparison operators

Open
#21,869 2 comments 0 reactions 2 assignees View on GitHub

@hawkingrei is already working on this.

Since Nov 14, 2025.

  • #22057 by @hawkingrei — merged
Dominant language
Python
Stars
617
Forks
724
Avg merge
2d 10h
Merged PRs (30d)
223

Description

Change Request

Please answer the following questions before submitting your issue. Thanks!

  1. 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

  1. 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 ANY or ALL, with reference to the new page.

  2. Provide some reference materials (such as documents and websites) if you could.
    See above.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.