Re: [HACKERS] path toward faster partition pruning
| От | Rajkumar Raghuwanshi |
|---|---|
| Тема | Re: [HACKERS] path toward faster partition pruning |
| Дата | |
| Msg-id | CAKcux6=NWijcz6G6n7BoCJt-JnZi1XO4Sqy7E6tykY=0XTs3Ow@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [HACKERS] path toward faster partition pruning (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>) |
| Ответы |
Re: [HACKERS] path toward faster partition pruning
|
| Список | pgsql-hackers |
On Tue, Feb 20, 2018 at 12:34 PM, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> wrote:
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
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
В списке pgsql-hackers по дате отправления: