Metadata script extracted using ISQL add a extra space on a not null Timestamp table field with CURRENT_TIMESTAMP as default value ----------------------------------------------------------------------------------------------------------------------------------
Key: CORE-6053 URL: http://tracker.firebirdsql.org/browse/CORE-6053 Project: Firebird Core Issue Type: Bug Affects Versions: 2.5.8 Environment: Windows 10 x64 Firebird 2.5.8 (x64) Reporter: Luciano Mendes 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 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel