Reported By: Michael Fullerton Reported On: 11/23/2001 For: Version 3.03 Build 1
# 960Using Function Call Around Column Name Causes SQL Engine to Not Determine Columns vs. Literals Running the following SQL brings up no recs.
SELECT *
FROM Bookings
WHERE UPPER(Person) = 'CC' <--
Doesn't work
WHERE UPPER(Person) = 'AA' <-- Works
WHERE Person = 'CC' <-- Works
Comments and WorkaroundsCC was also a column name and the inclusion of the UPPER function call around the Person column was preventing the engine from properly determining that 'CC' is a string literal and not a column name. The engine can now handle this situation properly and determine that CC is indeed a string literal, regardless of how complex the expression involving the Person column.
ResolutionFixed Problem on 11/28/2001 in version 3.04 build 1