Kristian Nielsen <knielsen@knielsen-hq.org> writes:
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.
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.