[
https://issues.apache.org/jira/browse/DERBY-7112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard N. Hillegas resolved DERBY-7112.
----------------------------------------
Resolution: Duplicate
> 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
> Priority: Major
>
> 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)
