USE-INDEX indexName does not throw error if index is deleted, but there are other indexes beginning with indexName


Article Number000090363
EnvironmentProduct: OpenEdge
Version: 11.7.x
OS: Windows
Question/Problem Description
Even if an index i1 is deleted from database, procedure having a USE-INDEX i1 does not throw error if there are other indexes whose names begin with i1.
USE-INDEX idx works like USE-INDEX begins_with_idx
Steps to Reproduce
Clarifying Information
 There are no errors compiling when the index is removed as long as another index begins with the same name - such as idx1, idx11, and idx1 is the deleted index.
Error Message
Defect/Enhancement NumberDefect OCTA-7168
Index names are subject to automatic expansion.
Enable "Require Full Names" strict compiler option (requires 11.7+).
Use index names such as idx1, idx2 etc, instead of idx1, idx11.
If using idx1, idx2, ensure there is no index with the name idx.
Last Modified Date12/18/2018 7:02 AM

Did this article resolve your question/issue?


Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025