Bug #5181 Example query in documentation is incorrect

• Submitted: 24 Aug 2004 13:32
• Modified: 31 Aug 2004 19:35
• Reporter: Sergey Petrunya
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Assigned to: Paul DuBois
• CPU Architecture: Any

[24 Aug 2004 13:32] Sergey Petrunya

Description:
As  Jon Stephens pointed out, the last example query at page 

http://dev.mysql.com/doc/mysql/en/Comparisons_using_subqueries.html

is incorrect. 

How to repeat:
n/a

Suggested fix:
change to 
select * from t1 X where 2 = (select count(*) from t1 where X.a=t1.a) 
?

[31 Aug 2004 19:35] 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).