Explain plan shows unusable index as selected for matching

Description

Query with the following WHERE clause: "nestedField.id < 20 OR nestedField.id > 80" was invoked on a indexed field that was declared as SpaceIndexType.EQUAL and not SpaceIndexType.EQUAL_AND_ORDERED

Although the index was ignored during matching, the explain plan description considered it as selected.

Workaround

None

Acceptance Test

test.database.sql.* added test cases

Assignee

Meron Avigdor

Reporter

Meron Avigdor

Labels

None

Priority

Minor

SalesForce Case ID

None

Fix versions

Commitment Version/s

None

Due date

None

Product

XAP

Edition

Open Source

Platform

All
Configure