Forum Stats

  • 3,826,050 Users
  • 2,260,591 Discussions
  • 7,896,781 Comments

Discussions

Incorrect result returned by BDBSQL 18.1.32

user11188564
user11188564 Member Posts: 124
edited Aug 24, 2020 3:29PM in Berkeley DB

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

Best Answer

Answers