I am using BBDBSQL with ORACLE's Berkeley DB 18.1.32 library
I have a table with text columns and the column ctl_ctor_lt_ident is used in an index to the table.
The following query returns an incorrect result -
select ctl_ctor_lt_ident from from control_table where ctl_ctor_lt_ident='95893A489680'
95893A489697
There are no rows with ctl_ctor_lt_ident=95893A489680
Deleting the index returns the correct result. The Application has worked with problems with earlier BDB releases.
Is this a known bug ? Is a patch available