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
