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

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 wrote:

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 INTO t2 VALUES ('Louisiana',9),('Alaska',5); INSERT INTO t2 SELECT t2.* FROM t2 JOIN t2 AS t3 JOIN t2 AS t4 JOIN t2 AS t5 JOIN t2 AS t6;

SET @@max_heap_table_size= 16384; set @@optimizer_switch='derived_merge=OFF'; set @@optimizer_switch='extended_keys=ON';

SELECT * FROM t1 AS t1_1 LEFT JOIN ( t1 AS t1_2 INNER JOIN (SELECT * FROM t2) v2 ON t1_2.i = j ) ON t1_1.state = v2.state LIMIT 1;

DROP TABLE t1, t2;

On Tue, Feb 10, 2015 at 1:41 PM, Vicențiu Ciorbaru wrote:

...

+ 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

_______________________________________________ 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