MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Georgi Kodinov Date:August 29 2007 11:56am
Subject:Re: bk commit into 5.1 tree (gkodinov:1.2571) BUG#30244
View as plain text  
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 ?

<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: +359 32 634 397 Mobile: +359 887 700 566 Skype: georgekodinov

Are you MySQL certified?  www.mysql.com/certification


Thread
bk commit into 5.1 tree (gkodinov:1.2571) BUG#30244kgeorge21 Aug
  • Re: bk commit into 5.1 tree (gkodinov:1.2571) BUG#30244Mats Kindahl29 Aug
    • Re: bk commit into 5.1 tree (gkodinov:1.2571) BUG#30244Georgi Kodinov29 Aug
      • Re: bk commit into 5.1 tree (gkodinov:1.2571) BUG#30244Mats Kindahl29 Aug