[SQL] Error "Conversion error from string " . . : : "." (335544334) when trying to add another...

Given is a Firebird 5.0 table with this DDL:

CREATE TABLE KASSE_DETAILEDSTATISTICS
(ORDERDATE KASSE_ORDERTIMESTAMP NOT NULL,
PRODUCTID KASSE_PRODUCTID NOT NULL,
CONSUMPTIONPLACE KASSE_INHAUS NOT NULL,
ORDERTYPE KASSE_ORDERTYPE NOT NULL,
QUANTITY KASSE_QUANTITY NOT NULL,
PRICESUM KASSE_PRICE,
TRAININGPURCHASE KASSE_BOOLEAN NOT NULL,
KASSE_ID KASSE_Z_KASSE_ID);

ALTER TABLE KASSE_DETAILEDSTATISTICS ADD PRIMARY KEY (ORDERDATE,PRODUCTID,CONSUMPTIONPLACE);

CREATE UNIQUE INDEX IDX_KASSE_DETAILEDSTATISTICS ON KASSE_DETAILEDSTATISTICS(ORDERDATE,PRODUCTID,CONSUMPTIONPLACE);


Now I try to add another column like this:

ALTER TABLE KASSE_DETAILEDSTATISTICS ADD TEST INTEGER;


But this always results in this failure message when trying to commit it:

Conversion error from string " . . : : ".

SQL Code: -413
IB Error Number: 335544334


Ok, it looks like date related, but why does Firebird want to convert some empty string into a timestamp? Firebird shall just add a column!

The table contains data and the ORDERDATE column only contains valid timestamp values!

Continue reading...