Icon View Incident Report

Serious Serious
Reported By: Ralf Mimoun
Reported On: 3/4/2002
For: Version 3.07 Build 1
# 1053 Comparing a LargeInt to a Constant Causes Incorrect Results in an SQL SELECT Statement

I don't know if I am wrong or if it's really a bug. Let's assume we have a very simple table named "new". This tabel has only one field, called "Hi", type is LARGEINT. Some records, one or more with Hi=1. The following illustrates the problem.

SELECT * FROM new returns all rows

SELECT * FROM new WHERE Hi=1 returns no rows at all.

SELECT * FROM new WHERE Hi=CAST(1 as LARGEINT) returns what I expected.



Comments Comments and Workarounds
Using the CAST function is the appropriate workaround.


Resolution Resolution
Fixed Problem on 3/10/2002 in version 3.08 build 1
Image