Submitted by: Sergey Mereutsa (green_dq)

Is related to QA400

When you execute this script:

CREATE TABLE T1 (
F1 BIGINT NOT NULL,
F2 BIGINT NOT NULL,
F3 TIMESTAMP DEFAULT current_timestamp NOT NULL
);

ALTER TABLE T1 ADD CONSTRAINT PK_T1 PRIMARY KEY (F1, F2);

and show table t1 (in isql), you can see, that "NOT" word was added to the default timestamp value:

Database: localhost/3055:universe, User: dqdev
SQL> CREATE TABLE T1 (
CON> F1 BIGINT NOT NULL,
CON> F2 BIGINT NOT NULL,
CON> F3 TIMESTAMP DEFAULT current_timestamp NOT NULL
CON> );
SQL>
SQL> ALTER TABLE T1 ADD CONSTRAINT PK_T1 PRIMARY KEY (F1, F2);
SQL> GRANT ALL ON T1 TO DQDEV WITH GRANT OPTION;
SQL> commit;
SQL> exit;

Database: localhost/3055:universe, User: dqdev
SQL> show table t1;
F1 BIGINT Not Null
F2 BIGINT Not Null
F3 TIMESTAMP Not Null DEFAULT current_timestamp NOT
CONSTRAINT PK_T1:
Primary key (F1, F2)

P.S.

Vlad indicated, that this bug was added by Dmitry Emanov, when fixed this: CORE1512

Commits: d04031e