Re: [HACKERS] path toward faster partition pruning

[Rajkumar Raghuwanshi]

On Tue, Feb 20, 2018 at 12:34 PM, Amit Langote <
langote_amit...@lab.ntt.co.jp> wrote:

> Attached updated version.
>

Hi Amit,

I have applied v29 patch-set on head and  got "ERROR:  operator 1209 is not
a member of opfamily 1994" with below test case. Please take a look.

CREATE TABLE part (c1 INT4, c2 TEXT, c3 INT4) PARTITION BY LIST (c2);
CREATE TABLE part_p1 PARTITION OF part FOR VALUES IN('ABC');
CREATE TABLE part_p2 PARTITION OF part FOR VALUES IN('DEF');
CREATE TABLE part_p3 PARTITION OF part FOR VALUES IN('GHI');
CREATE TABLE part_p4 PARTITION OF part FOR VALUES IN('JKL');

INSERT INTO part VALUES (100,'ABC',10);
INSERT INTO part VALUES (110,'DEF',20);
INSERT INTO part VALUES (120,'GHI',10);
INSERT INTO part VALUES (130,'JKL',100);

explain (costs off) SELECT * FROM part WHERE c2 LIKE '%ABC%';
*ERROR:  operator 1209 is not a member of opfamily 1994*

Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation