Re: [Maria-developers] Fwd: MDEV-6838 Using too big key for internal temp tables

2015-02-12 Thread Vicențiu Ciorbaru
Hi Patryk, I'm still investigating to find the root cause of the issue. I'll let you know when I find it. Regards, Vicentiu On Tue Feb 10 2015 at 5:34:31 PM Patryk Pomykalski pom...@gmail.com wrote: Now it fails if you increment the varchar length (and I increased amount of data in t2 to

Re: [Maria-developers] Fwd: MDEV-6838 Using too big key for internal temp tables

2015-02-10 Thread Patryk Pomykalski
Now it fails if you increment the varchar length (and I increased amount of data in t2 to trigger this on 32bit too): CREATE TABLE t1 (i INT, state VARCHAR(996)) ENGINE=MyISAM; INSERT INTO t1 VALUES (2,'Louisiana'),(9,'Maine'); CREATE TABLE t2 (state VARCHAR(996), j INT) ENGINE=MyISAM; INSERT

[Maria-developers] Fwd: MDEV-6838 Using too big key for internal temp tables

2015-02-10 Thread Vicențiu Ciorbaru
+ CC maria-developers Hi Sergei! I have attached the diff for MDEV-6838. Let me know your thoughts on it. The test case now fails without the patch and passes with the patch on both 5.5 and 10.0. Sergey Petrunia is alright with the patch. Regards, Vicențiu === added file