View Incident Report

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

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

Resolution

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

More Support Options