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

« Go Back

Information

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

URL Name	use-index-indexname-does-not-throw-error-if-index-is-deleted-but-there-are-other-indexes-beginning-with-indexname

Article Number	000117924

Environment	Product: 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 Number	OCTA-7168

Enhancement Number

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

Keyword Phrase

Last Modified Date	2/15/2023 5:38 PM