Reported By: Fernando Dias Reported On: 6/6/2004 For: Version 4.07 Build 1
# 1731Reverse Engineering a Table in DBSYS with Default Values of '.' or ',' Result in Incorrect SQL Code String delimiters are missing when reverse engineering a table with default values of '.' or ','.
1.Create a table like this:
CREATE TABLE IF NOT EXISTS "TestDot"
(
"col1" VARCHAR(10) DEFAULT '.' ,
"col2" VARCHAR(10) DEFAULT ',' ,
)
2.Reverse engineer the table to obtain the
following code, with the missing delimiters:
/* SQL-92 Table Creation Script with DBISAM Extensions */
CREATE TABLE IF NOT EXISTS "TestDot"
(
"col1" VARCHAR(10) DEFAULT .,
"col2" VARCHAR(10) DEFAULT ,,
PRIMARY KEY ("RecordID") COMPRESS NONE
LOCALE CODE 0
USER MAJOR VERSION 1
);
ResolutionFixed Problem on 6/7/2004 in version 4.08 build 1