MySQL Bugs: #14: query results in a differnt number of rows depending if sql_big

Bug #14	query results in a differnt number of rows depending if sql_big_tables
Submitted:	21 Dec 2002 9:21	Modified:	27 Dec 2002 20:46
Reporter:	Michael Widenius	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	3.23.44	OS:
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
This query results in a differnt number of rows depending if sql_big_tables
is set.

select count(incidents.ref_no) from incidents, labels where
incidents.ref_no like '020531%' group by labels.label, incidents.ref_no;

I uploaded the tables involved to
support.mysql.com/pub/mysql/secret/hasbro_mysql.tgz

How to repeat:

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Fixed in 3.23.55