Icon View Incident Report

Minor Minor
Reported By: Fernando Dias
Reported On: 6/6/2004
For: Version 4.07 Build 1
# 1731 Reverse 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
	);



Resolution Resolution
Fixed Problem on 6/7/2004 in version 4.08 build 1
Image