maria-developers team mailing list archive

[Vicențiu Ciorbaru <vicentiu@xxxxxxxxxxx>]

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 <pomyks@xxxxxxxxx> 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 <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
>>
>>
>