Re: bk commit into 5.1 tree (gkodinov:1.2571) BUG#30244

[Mats Kindahl]

Georgi Kodinov wrote:
> Mats,
>
> On 29.08.2007, at 14:45, Mats Kindahl wrote:
>
>> Patch looks good. OK to push.
>
> Thanks, can you please mark the bug as PA ?

Done.

>
> <cut>
>
>>> +
>>> +CREATE TABLE t1 (a INT); +CREATE TABLE t2 (a INT, b INT); +
>>> +INSERT INTO t1 SELECT 1;
>>> +
>>> +connection master1;
>>> +INSERT INTO t1 VALUES (2),(3),(4),(5),(6);
>>> +
>>> +connection master;
>>> +INSERT INTO t2 SELECT 1, ROW_COUNT();
>>> +
>>> +INSERT INTO t1 VALUES (2),(3),(4);
>>> +INSERT INTO t2 SELECT 1, ROW_COUNT();
>>> +
>>> +#must return 1 and 3
>>> +SELECT b FROM t2 ORDER BY a;
>>>
>>
>> Since they both have the value 1 in the 'a' column, they will be put 
>> in a storage engine- dependent order. Suggest changing the second 
>> "SELECT 1" into "SELECT 2" to get a storage engine-independent order.
>
> This was my original intention, but I've overlooked that typo. Thanks 
> for spotting it. Fixed and re-committed.
>
> Best Regards,
> Joro
> --Georgi Kodinov, Senior Software Engineer
> MySQL AB, Plovdiv, Bulgaria, www.mysql.com
> Office: [phone] Mobile: [phone] Skype: georgekodinov
>
> Are you MySQL certified?  www.mysql.com/certification
>
>
>
> --MySQL Code Commits Mailing List
> For list archives: http://lists.mysql.com/commits
> To unsubscribe:    http://lists.mysql.com/commits?unsub=1
>


-- 
Mats Kindahl
Lead Software Developer
Replication Team
MySQL AB, www.mysql.com