Reported By: Tiago Ameller Reported On: 11/3/2000 For: Version 2.04 Build 1
# 651Using a Numeric in SQL BETWEEN that is Greater Than the Range of a SmallInt Causes Incorrect Results In SQL or Filter, "MySmallIntField BETWEEN 1 AND 99999" always is false, despite of correct values in that range in MySmallIntField. The cause is 99999 is beyond the limits of smallint type.
ResolutionFixed Problem on 4/3/2005 in version 4.19 build 1