Icon View Incident Report

Serious Serious
Reported By: Kees Lagendijk
Reported On: 10/24/2003
For: Version 3.26 Build 1
# 1431 SQL CREATE and ALTER TABLE Statements Not Allowing Double-Quotes for Default, Min, or Max Values

Alter table add char-field refuses default value.

alter table test
add testfield char(1) default "X"

Comments Comments and Workarounds
The workaround is to use single quotes instead.

Resolution Resolution
Fixed Problem on 10/30/2003 in version 3.27 build 1