[ASTERIXDB-1109] Index entries are not deleted on an open-type secondary index

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Component/s: *DB - AsterixDB, RT - Runtime
• Assignee: Ildar Absalyamov
• Reporter: Taewoo Kim
• Created: 22/Sep/15 22:52
• Updated: 19/Mar/16 00:29
• Resolved: 19/Nov/15 18:39

Description

Currently, index entries (SK, PK) are not deleted on an open-type secondary index. This issue was not surfaced due to the fact that every search after a secondary index search needs to go through the primary index lookup. Therefore, un-deleted entries were removed during this Pidx lookup.

Now, we have an index-only plan that can skip the Pidx lookup after a Sidx search. Therefore, the query result is not correct anymore.

Issue Links

• breaks: ASTERIXDB-1110 Cannot drop a dataverse when there was an exception regarding an index operation