Re: [HACKERS] path toward faster partition pruning

Thanks Rajkumar for the test.

On 2018/02/20 16:56, Rajkumar Raghuwanshi wrote:
> 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*

An oversight in the v28 patch seems to have caused this. Fixed in the
attached.

Thanks,
Amit