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
