Paul McCullagh <paul.mccull...@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. _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp