Icon View Incident Report

Serious Serious
Reported By: Suat Demirkiran
Reported On: 9/10/2002
For: Version 3.16 Build 1
# 1200 Invalid SQL CAST Function Arguments Being Allowed When Instead Should Issue Type Mismatch

"select cast(0.5 as time) from TEMP;"

is not working correctly.

Note that : 0.5 must be casted as "12:00:00"

select cast(0.5 as time) from TEMP;

Comments Comments
This SQL statement should not have been allowed - you cannot cast a float as a time in DBISAM's SQL implementation.

Resolution Resolution
Fixed Problem on 9/12/2002 in version 3.17 build 1