Bug #7869 "<> ANY" explaining as "NOT IN"

• Submitted: 13 Jan 2005 12:18
• Modified: 24 Jan 2005 20:29
• Reporter: Arthur E. Groen
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• CPU Architecture: Any

[13 Jan 2005 12:18] Arthur E. Groen

Description:
In the Mysql online manual
http://www.mysqlfreaks.com/mysql/manual_Reference.html#Data_Manipulation
6.4.2.3 Subqueries with ANY, IN, and SOME

In the explanation for "<> ANY" or "<> SOME" the text tells us
what it means in englisch and  "---- which isn't what is meant by the SQL syntax"
But it does not say what the SQL command really means in Englisch.

In the subparagraph above this, the manual talks about "Collections of numbers"
as in {21,14,7} and i think the subject is easier to understand if the manual
would stick to this for this paragraph.
Adding the example
SELECT s1 FROM t1 WHERE s1 NOT IN  (SELECT s1 FROM t2);
will make englisch and SQL intention equal.
 

How to repeat:
as is

Suggested fix:
see above

[24 Jan 2005 20:29] Paul DuBois

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

Added that the English means "there is some b to which a is
not equal."

Didn't add the suggested example, because it has a different
meaning.

Thanks for the report.