Bug #5181 Example query in documentation is incorrect

Submitted: 24 Aug 2004 13:32 Modified: 31 Aug 2004 19:35
Reporter: Sergey Petrunya Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
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).

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.