maria-developers team mailing list archive

[Patryk Pomykalski <pomyks@xxxxxxxxx>]

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 <vicentiu@xxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>
>