Article

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

Information

 
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
Cause
Index names are subject to automatic expansion.
Resolution
Enable "Require Full Names" strict compiler option (requires 11.7+).
Workaround
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.
Notes
Attachment 
Last Modified Date12/18/2018 7:02 AM


Feedback
 
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