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)
