maria-developers team mailing list archive

[Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx>]

Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx> writes:

> Paul McCullagh <paul.mccullagh@xxxxxxxxxxxxx> writes:
>
>> I ran the test below using both InnoDB and PBXT, using MariaDB
>> (lp:~maria-captains/maria/5.1-release) and MySQL 5.1.46.
>>
>> I get the same result from both engines (and both servers).
>>
>> The select "select t1.id,t2.id from t2 left join t1 on t1.id>=74 and
>> t1.id<=0 where t2.id=75 and t1.id is null;"
>
> Thanks for looking into this Paul! I must have mis-interpreted the results
> from main.join.
>
> So it looks like a regression in MySQL 5.1.46, which kind of makes more sense
> than a PBXT-specific problem. I'll take it from here.

Ah, it works with myisam, but fails with innodb.

I filed a MySQL bug:

    http://bugs.mysql.com/bug.php?id=53334

Thanks again for your help! Once again the PBXT test suite finds serious
problems outside of PBXT...

 - Kristian.