Reported By: Ole Willy Tuv Reported On: 4/12/2007 For: Version 1.02 Build 1
# 2322Subtracting TIMESTAMP Values from DATE Values Allowed When it Shouldn't Be Allowed The expression (current_date-timestamp'2000-01-01 00:00:00') is invalid, since the the two operands are not comparable (they have different datetime fields). EDB executes the expression without a complaint, but returns the null value. The engine should raise a proper exception here.
select cast((current_date-timestamp'2000-01-01 00:00:00') year as integer) issue2
from dummy
ResolutionFixed Problem on 4/13/2007 in version 1.03 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial