zettadb / kunlun-storage-8.0.26

Other
0 stars 0 forks source link

partial index support #26

Open jd-zhang opened 3 years ago

jd-zhang commented 3 years ago

Issue migrated from trac ticket # 77 www.kunlunbase.com

component: kunlun-storage | priority: major

2021-04-29 15:31:01: zhangjindong@zettadb.com created the issue


currently, we do not support partial index, but it may be useful to add support for this.

create table insertconflicttest(key1 int4, fruit text); create unique index partial_key_index on insertconflicttest(key1) where fruit like '%berry'; -- psql:insert_conflict.sql:166: ERROR: partial index isn't supported for remote relations

jd-zhang commented 3 years ago

2021-04-29 15:35:19: zhangjindong@zettadb.com

jd-zhang commented 3 years ago

2021-04-29 15:35:19: zhangjindong@zettadb.com changed type from task to feature