Hi!
>>>>> "rhuddleston" == rhuddleston <[EMAIL PROTECTED]> writes: >> Description: rhuddleston> The following query results in a different # of rows if the sql_big_tables is set to 1: rhuddleston> select count(incidents.ref_no) from incidents, labels where incidents.ref_no like '020531%' group by labels.label, incidents.ref_no; rhuddleston> The query seems unusual because it was a lot more complicated but I broke it down for better readability. rhuddleston> incidents.refno is [varchar(15) binary] eg '020531-000031' rhuddleston> labels.label is [blob] eg 'Pricing' rhuddleston> Note: The results are only different if there is a large # of results from the query >> How-To-Repeat: rhuddleston> create two tables with the above attributes and of large size. Then run the query with sql_big_tables set to 1 and when it's not set. Sorry, but the above description is not good enough for us to be able to repeat the problem :( In general things like this is very data dependent and it's very hard to repeat bugs without a repeatable test case. Could out make a repeatable test case base on of our benchmark programs in the sql-bench directory ? (test-insert should be a good candidate for this). If you can do a test case, we will do our best to fix this in next MySQL release (if it's not already fixed). Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
