Are SQL ANY and SOME keywords synonyms in all SQL dialects?
Few lines after what you're quoting, the SQL92 standard also specifies the semantics for <some>
, namely:
c) If the implied <comparison predicate> is true for at leastone row RT in T, then "R <comp op> <some> T" is true.d) If T is empty or if the implied <comparison predicate> isfalse for every row RT in T, then "R <comp op> <some> T" isfalse.e) If "R <comp op> <quantifier> T" is neither true nor false,then it is unknown.
These rules apply for the <some>
token, independent on whether it is the SOME or ANY alternative, so yes, they are synonyms according to the standard