30 Apr
2010
30 Apr
'10
8:07 p.m.
Paul McCullagh <paul.mccullagh@primebase.org> 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. - Kristian.