OpenMLDB icon indicating copy to clipboard operation
OpenMLDB copied to clipboard

Index deletion and re-creation failed

Open uttinie opened this issue 3 years ago • 0 comments

Bug Description

image

image

CREATE INDEX index1 ON t1 (pickup_datetime) OPTIONS (ts=pickup_datetime, ttl_type=absolute, ttl=20d); -- success CREATE INDEX index2 ON t1 (id) OPTIONS (ts=pickup_datetime, ttl_type=absolute, ttl=20d); -- success

drop index t1.index2; -- success

CREATE INDEX index2 ON t1 (id) OPTIONS (ts=pickup_datetime, ttl_type=absolute, ttl=20d); -- 是否符合预期 Error: duplicated index CREATE INDEX index3 ON t1 (id) OPTIONS (ts=pickup_datetime, ttl_type=absolute, ttl=20d); -- 是否符合预期 Error: index has already exist! Expected Behavior

Steps to Reproduce

uttinie avatar Sep 06 '22 03:09 uttinie