Icon View Incident Report

Serious Serious
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’

Resolution Resolution
Fixed Problem on 2/27/2005 in version 4.18 build 1