Reported By: Ralf Mimoun Reported On: 3/4/2002 For: Version 3.07 Build 1
# 1053Comparing 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 and WorkaroundsUsing the CAST function is the appropriate workaround.
ResolutionFixed Problem on 3/10/2002 in version 3.08 build 1