Wrong Results From Index Organized Table (IOT) Using Secondary Index
(Doc ID 2589388.1)
Last updated on NOVEMBER 21, 2019
Applies to:Oracle Database - Standard Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Wrong results from Index Organized Tables (IOT) under following scenario:
1. Index-Organized Table (IOT) with multi-column primary key populated with rows.
2. The table has a secondary index on the sub leading column of multi-column primary key.
3. Another column is added to the existing IOT.
4. Wrong result report for the newly added column when the secondary index is accessed.
When secondary index is created to the IOT.
There is a similar <Bug 14472647> reported but fixed in 22.214.171.124.
<Document 14472647.8> Bug 14472647 - Wrong results on IOT secondary index after DML.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document