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:15:00 UTC

[jira] [Created] (DERBY-7112) Corrupt Index

Geraldine created DERBY-7112:
--------------------------------

             Summary: Corrupt Index
                 Key: DERBY-7112
                 URL: https://issues.apache.org/jira/browse/DERBY-7112
             Project: Derby
          Issue Type: Bug
          Components: Network Server
    Affects Versions: 10.8.1.2
         Environment: Linux with Java 8 - 8.0.6.15
            Reporter: Geraldine


Index is keeping a value which no longer exists in the underlying table. The Index is on one VARCHAR column. This results in the following error when selecting from the table using this column: select * from <table> where <indexed column> = 'obsolete value'

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

The Query plan show that the Index is being used. If only the Indexes column is being selected then the select query does not give an error, as it is taking the value from Index.

I can recreate this in one environment.

 

 



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