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 <vicen...@mariadb.org> 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 > >
_______________________________________________ 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