0
Fixed

Column Sequence gets added to child FK Column (Snowflake)

Erick Hanftwurzel 12 months ago updated by Retinder Labana 10 months ago 2

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.

Image 2155

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 )
);
GOOD, I'M SATISFIED
Satisfaction mark by Erick Hanftwurzel 10 months ago
Started

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!

Fixed

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