[DERBY-7113] Index has value of column which no longer exists in the table

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 10.8.3.0
• Component/s: Network Server
• Environment: Linux with Java 8 - 8.0.6.25
• Urgency: Normal
• Issue & fix info: Workaround attached
• Bug behavior facts: Data corruption
• Flags: Important
• Assignee: Unassigned
• Reporter: Geraldine
• Created: 16/Apr/21 08:19
• Updated: 19/Apr/21 15:05

Description

From time to time an Index keeps a value, which has been deleted from the underlying table.

This results in an error is the row with the value is selected.

SELECT ID from Some.TABLE WHERE IndexedColumn= 'Remembered Value';

ID

--------------------

1680880176

ERROR 0A000: The DRDA command parseSQLDIAGSTT is not currently implemented.  The connection has been terminated.

 If only the Indexed Column is selected, then the Query returns 0 rows and produces no error - because just the index is searched.

The Query Plan shows the index being used.

Dropping and Recreating the index fixes the issue. However, I can reproduce this by reloading a database backup.

 

Issue Links

• is duplicated by: DERBY-7112 Corrupt Index