Submitted by: @luronumen

Attachments:
DEFAULT_TIMESTAMP.PNG

ACTUAL RESULT:
- Metadata script extracted using ISQL add a extra space on a not null Timestamp table field with CURRENT_TIMESTAMP as default value (See picture attached)

EXPECTED RESULT:
- Metadata script extracted using ISQL shoud not add a extra space on a not null Timestamp table field with CURRENT_TIMESTAMP as default value

STEPS TO REPRODUCE THE ISSUE

1- Create a Firebird SQL 2.5.9 database

2- Execute the following SQL Statements to generate the USERS table (without extra espace):
CREATE TABLE ACCESSORIES (ID BIGINT NOT NULL,
ACCESSORY_TYPE_ID BIGINT NOT NULL,
ACCESSORY_MODEL_ID BIGINT NOT NULL,
ACCESSORY_STATUS_ID BIGINT NOT NULL,
TEAM_ID BIGINT NOT NULL,
USER_ID BIGINT NOT NULL,
DATE_ASSIGNED TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
AVAILABILITY_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
SPEC1 VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
SPEC2 VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
SPEC3 VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
EXTERNAL_ID VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
OTHER_INFO VARCHAR(128) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
LOCATION VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
INVOICE VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
REGISTRATION_DATE DATE DEFAULT CURRENT_DATE NOT NULL,
INVENTORYING_DATE DATE DEFAULT CURRENT_DATE NOT NULL,
MISSING_DATE DATE,
SCRAPPING_DATE DATE,
VISIBLE VISIBLE DEFAULT '1' NOT NULL,
AID COMPUTED BY (('A' || ID) COLLATE WIN_PTBR),
CONSTRAINT PK_ACCESSORIES_1 PRIMARY KEY (ID));

3- Execute the isql.exe to extract the database structure (Extra space is added):
CREATE TABLE ACCESSORIES (ID BIGINT NOT NULL,
ACCESSORY_TYPE_ID BIGINT NOT NULL,
ACCESSORY_MODEL_ID BIGINT NOT NULL,
ACCESSORY_STATUS_ID BIGINT NOT NULL,
TEAM_ID BIGINT NOT NULL,
USER_ID BIGINT NOT NULL,
DATE_ASSIGNED TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
AVAILABILITY_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
SPEC1 VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
SPEC2 VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
SPEC3 VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
EXTERNAL_ID VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
OTHER_INFO VARCHAR(128) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
LOCATION VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
INVOICE VARCHAR(32) CHARACTER SET WIN1252 COLLATE WIN_PTBR,
REGISTRATION_DATE DATE DEFAULT CURRENT_DATE NOT NULL,
INVENTORYING_DATE DATE DEFAULT CURRENT_DATE NOT NULL,
MISSING_DATE DATE,
SCRAPPING_DATE DATE,
VISIBLE VISIBLE DEFAULT '1' NOT NULL,
AID COMPUTED BY (('A' || ID) COLLATE WIN_PTBR),
CONSTRAINT PK_ACCESSORIES_1 PRIMARY KEY (ID));

4- Repeat the steps above using the Metadata script extracted and note that one more espace is added