Icon View Incident Report

Serious Serious
Reported By: Fernando Dias
Reported On: 11/24/2003
For: Version 3.27 Build 1
# 1710 Cannot Use TRUE or FALSE with SQL CREATE TABLE or ALTER TABLE DEFAULT Clause Without Quotes

For boolean columns, the DEFAULT clause is incorrectly reporting an error when the values True and False are not quoted. However, reverse engineering is correctly generating the values without quotes).

drop table if exists x;
create table x ( f1 boolean default false );

Resolution Resolution
Fixed Problem on 11/28/2003 in version 3.28 build 1