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
