Icon View Incident Report

Minor Minor
Reported By: Ole Willy Tuv
Reported On: 4/12/2007
For: Version 1.02 Build 1
# 2322 Subtracting 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



Resolution Resolution
Fixed Problem on 4/13/2007 in version 1.03 build 1


Products Affected Products Affected
ElevateDB 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

Image