You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Geraldine (Jira)" <ji...@apache.org> on 2021/04/16 08:20:00 UTC

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

Geraldine created DERBY-7113:
--------------------------------

             Summary: Index has value of column which no longer exists in the table
                 Key: DERBY-7113
                 URL: https://issues.apache.org/jira/browse/DERBY-7113
             Project: Derby
          Issue Type: Bug
          Components: Network Server
    Affects Versions: 10.8.3.0
         Environment: Linux with Java 8 - 8.0.6.25
            Reporter: Geraldine


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.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)