
0
Fixed
Column Sequence gets added to child FK Column (Snowflake)
If I define a sequence on a PK column and create an FK with it, the child table will add a default in it's DDL. In the example below, TABLE_2.COL_1 has a default value. It shouldn't inherit the default value.
CREATE OR REPLACE TABLE TABLE_1
(
COL_1 number NOT NULL DEFAULT SEQ_COL_1.nextval,
INSERT_TS timestamp NOT NULL, -- From template: "ETL_METADATA"
LAST_UPDATE_TS timestamp, -- From template: "ETL_METADATA"
CONSTRAINT PK_TABLE_1 PRIMARY KEY ( COL_1 )
);
CREATE OR REPLACE TABLE TABLE_2
(
COL_1 number NOT NULL DEFAULT SEQ_COL_1.nextval,
INSERT_TS timestamp NOT NULL, -- From template: "ETL_METADATA"
LAST_UPDATE_TS timestamp, -- From template: "ETL_METADATA"
CONSTRAINT FK_31 FOREIGN KEY ( COL_1 ) REFERENCES TABLE_1 ( COL_1 )
);
Customer support service by UserEcho
Hello Erick,
Thank you for contacting Support. Our team is still investigating this, but it does indeed look like you've found a bug. We will keep you updated on the progress of both the bug and the fix. Thank you again for your help in uncovering this!
Hi,
I would like to confirm that we have released the fix for this. I will be closing this ticket now.
If you have any questions or concerns please feel free to reach out.
Thanks,
Retinder Labana