DDL accepts default '' for a date type [CORE1075]

[firebird-automations]

Submitted by: Chris Laurie (chrislaurie)

Is duplicated by CORE1404
Is duplicated by CORE4128

I have a tool that creates and runs the scripts to maintain my table structure. The following DDL was accepted and created by Firebird but then later throws a type conversion error. If I remove the default '' from the DATE columns then the app works fine. Should the DDL not be rejected for an invalid default type?

Create Table QUESTIONAIREEDITION (ID char(20) Default '' NOT NULL CONSTRAINT PKQUESTIONAIREEDITION PRIMARY KEY, ENTITYID char(20) Default '', QUESTIONAIREID char(20) Default '', DESCRIPTION varchar(50) Default '', FROMDATE date Default '', TODATE date Default '', SEQUENCE integer Default 0)

[firebird-automations]

Commented by: Claudio Valderrama C. (robocop)

isql is only a client tool. It's the engine that doesn't validate defaults.
Defaults aren't checked when you declare them.
They are applied at run-time to replace a missing value and if they can't be converted to the data type of the target column, a run-time conversion error message is produced. This has been always the same with all versions of IB, too.

[firebird-automations]

Modified by: Claudio Valderrama C. (robocop)

Version: 1.5.3 [ 10028 ]

Version: 1.5.2 [ 10027 ]

Version: 1.5.1 [ 10026 ]

Version: 1.5.0 [ 10025 ]

Version: 1.0.3 [ 10006 ]

Version: 1.0.2 [ 10005 ]

Version: 1.0.1 [ 10004 ]

Version: 1.0.0 [ 10003 ]

Version: 1.5.4 [ 10100 ]

Version: 2.0.1 [ 10090 ]

Version: 2.1 [ 10041 ]

Component: Engine [ 10000 ]

Component: ISQL [ 10003 ] =>

[firebird-automations]

Modified by: @pcisar

Version: 2.1 Initial [ 10160 ]

Version: 1.5.3 [ 10028 ] =>

Version: 2.0.0 [ 10091 ] =>

Version: 1.5.2 [ 10027 ] =>

Version: 1.5.1 [ 10026 ] =>

Version: 1.5.0 [ 10025 ] =>

Version: 1.0.3 [ 10006 ] =>

Version: 1.5.4 [ 10100 ] =>

Version: 2.0.1 [ 10090 ] =>

Version: 2.1.0 [ 10041 ] =>

[firebird-automations]

Modified by: @dyemanov

Link: This issue is duplicated by CORE1404 [ CORE1404 ]

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 11451 ] => Firebird [ 14573 ]

[firebird-automations]

Modified by: @dyemanov

Link: This issue is duplicated by CORE4128 [ CORE4128 ]