Please see my responses on DERBY-7113 and continue the discussion there
if necessary. Thanks.
On 4/16/21 1:22 AM, Geraldine McCormack wrote:
Hi Folks - I have opened this new issue and am wondering if others have
seen it, and if there are any mitigations to prevent this from happening :
https://issues.apache.org/jira/browse/DERBY-7113
>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.
Any advice appreciated,
Kind Regards,
Geraldine
---
Geraldine McCormack
L3 Team Lead - TBSM & Netcool/Impact
IBM Ireland
Visit the IBM Support Portal to open a case, download fixes, access product
documentation, education and training materials.
Visit our devcenters (applications and operations) for blogs, docs and
resources brought to you by the technical people who create our offerings.
--
