snowflake-sqlalchemy icon indicating copy to clipboard operation
snowflake-sqlalchemy copied to clipboard

SNOW-922868: Preserve the sequence order of foreign keys when dealing with composite keys.

Open skp33 opened this issue 1 year ago • 0 comments

Hi Team,

I am encountering issues while working with composite foreign keys. For every version, I am receiving fixed create_foreign_key and drop_constraint operations. Upon debugging, I discovered that we are not preserving the sequence order of foreign keys when comparing with metadata.

For more detail, I am pointing out the specific code snippet that requires modification. - https://github.com/snowflakedb/snowflake-sqlalchemy/blob/main/src/snowflake/sqlalchemy/snowdialect.py#L414-L434C18

skp33 avatar Sep 25 '23 11:09 skp33