View Incident Report

Serious

Reported By: Charles Bainbridge
Reported On: 8/30/2001
For: Version 2.11 Build 1

# 900 SQL Returns Incorrect Results for Query on Non-ANSI Table with Index Containing Single String Column

I have a largeish Paradox table (approx 66K records) which I have 'datapumped' to a number of database systems, including DBISAM. I have a problem with the result set from a simple select statement. It's one record short. The following statement does not return the highest row in the 'C' range, which a code of 'CZURI01'. I get 7695 rows back, rather than the 7696 rows I get from the other systems I have been testing. It's the row with 'CZURI01' in column 'code' that's missing.

SELECT * FROM CUSTOMER WHERE CODE < 'D'

Comments

The table contained a primary index on the column being queried, and DBISAM was not handling the range-selection properly for a non-ANSI Standard table with a single column index available to optimize the query.

Resolution

Fixed Problem on 9/1/2001 in version 2.12 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap