Reported By: Fernando Dias Reported On: 11/24/2003 For: Version 3.27 Build 1
# 1710Cannot 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 );
ResolutionFixed Problem on 11/28/2003 in version 3.28 build 1