MySQL Bugs: #15553: Manual for v 5.0, sect 1.6.1, has a logical error

Bug #15553	Manual for v 5.0, sect 1.6.1, has a logical error
Submitted:	7 Dec 2005 15:48	Modified:	17 Feb 2006 12:23
Reporter:	Paul Bailey	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.0	OS:
Assigned to:	Jon Stephens	CPU Architecture:	Any

Description:
There is a comment on the page, but no bug report (that I could find).

This section, " A new equality detector finds and optimizes “hidden” equalities in joins. For example, a WHERE clause such as

"t1.c1=t2c2 AND t2.c2=t3.c3 AND t1.c1 < 5

"can be reduced to

t1.c1=t3.c3 AND t2.c2 < 5 AND t3.c3 < 5"

has a tyop (should be "t2.c2", instead of "t2c2") and a logical error. Consider,

t1.c1=4,t2.c1=2,t3.c3=4. This row would be selected in the latter "optimized" query, but not the original query. Perhaps there is additional structure to t1, t2, t3 that you need to include?

How to repeat:
look at manual (5.0 sect 1.6.1)

Suggested fix:
update manual

Thank you for a bug report. This page (http://dev.mysql.com/doc/refman/5.0/en/mysql-5-0-nutshell.html) should really be updated (including not only "typo" correction, but also logical fault you found). 

Looks like we need some better examples of what our optimizer can do in version 5.

Fixed the typo, checking with developers to see if we can devise a better example.

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:

The Manual was updated in 12/05, and again since then. You might also want to look at the Internal documentation for additional / related info.