[Maria-developers] Rev 2784: small changes to WL#43: in http://bazaar.launchpad.net/~maria-captains/maria/5.2/

2010-04-30 Thread serg
At http://bazaar.launchpad.net/~maria-captains/maria/5.2/ revno: 2784 revision-id: ser...@pisem.net-20100430101225-dhby6azvhpef1vme parent: ser...@pisem.net-20100408210307-j82aap23b14h7j3t committer: Sergei Golubchik branch nick: 5.2 ti

Re: [Maria-developers] PBXT test failure in MySQL 5.1.46 merge

2010-04-30 Thread Paul McCullagh
Hi Kristian, 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

Re: [Maria-developers] PBXT test failure in MySQL 5.1.46 merge

2010-04-30 Thread Kristian Nielsen
Paul McCullagh 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 wh

Re: [Maria-developers] Ideas for improving MariaDB/MySQL replication

2010-04-30 Thread Kristian Nielsen
MARK CALLAGHAN writes: > As a further optimization, I want a callback that is called after the > binlog entries are written for a transaction and before the wait for > group commit on the fsync is done. That callback will be used to > release row locks (optionally) held by the transaction. I was

[Maria-developers] Rev 2785: create table options bug: in http://bazaar.launchpad.net/~maria-captains/maria/5.2/

2010-04-30 Thread serg
At http://bazaar.launchpad.net/~maria-captains/maria/5.2/ revno: 2785 revision-id: ser...@pisem.net-20100430200435-1wr1ghgs9ahga0wg parent: ser...@pisem.net-20100430101225-dhby6azvhpef1vme committer: Sergei Golubchik branch nick: 5.2 ti

[Maria-developers] Rev 2786: create table options bug: in http://bazaar.launchpad.net/~maria-captains/maria/5.2/

2010-04-30 Thread serg
At http://bazaar.launchpad.net/~maria-captains/maria/5.2/ revno: 2786 revision-id: ser...@pisem.net-20100430200927-ns4ykuzr2l760bdc parent: ser...@pisem.net-20100430200435-1wr1ghgs9ahga0wg committer: Sergei Golubchik branch nick: 5.2 ti

Re: [Maria-developers] PBXT test failure in MySQL 5.1.46 merge

2010-04-30 Thread Kristian Nielsen
Kristian Nielsen writes: > Paul McCullagh 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 jo

Re: [Maria-developers] PBXT test failure in MySQL 5.1.46 merge

2010-04-30 Thread Kristian Nielsen
Kristian Nielsen writes: > Ah, it works with myisam, but fails with innodb. > > I filed a MySQL bug: > > http://bugs.mysql.com/bug.php?id=53334 I found it is a regression in MySQL 5.1.46 introduced with the fix for this bug: http://bugs.mysql.com/bug.php?id=51494 - Kristian.

[Maria-developers] Please check optimiser regression in MySQL 5.1.46

2010-04-30 Thread Kristian Nielsen
Hi Igor, Timour, Sergey, Can one of you please check this patch from MySQL 5.1.46? It is a commit to fix http://bugs.mysql.com/bug.php?id=51494 This patch introduces a regression: http://bugs.mysql.com/bug.php?id=53334 If I revert the patch, the regression disappears. And interestingly, the

Re: [Maria-developers] Please check optimiser regression in MySQL 5.1.46

2010-04-30 Thread Igor Babaev
Hi! Kristian Nielsen wrote: > Hi Igor, Timour, Sergey, > > Can one of you please check this patch from MySQL 5.1.46? It is a commit to > fix http://bugs.mysql.com/bug.php?id=51494 > > This patch introduces a regression: > > http://bugs.mysql.com/bug.php?id=53334 > > If I revert the patch, t