Reported By: Jan Huebner Reported On: 2/27/2005 For: Version 4.17 Build 1
# 1987<> String Field Comparisons on Tables Not Using ANSI Standard Locale Return Incorrect Results If you try the following SQL-Statements on the Table DEBUG you get incorrect results. The problem only occurs if an index on the field test is set.
Content of the Table: B01, B02, B03
1. select * from DEBUG WHERE TEST<>'B00'
Result DBISAM V4.17: B02
Correct Result: B01, B02
2. select * from DEBUG WHERE TEST<>'B01'
Result DBISAM V4.17: NULL
Correct Result: B00, B02
3. select * from DEBUG WHERE TEST<>'B02'
Result DBISAM V4.17: B00
Correct Result: B00, B02
ResolutionFixed Problem on 2/27/2005 in version 4.18 build 1