Links
Comment on page

MSCEWI1093

On Commit not supported

Severity

Medium

Description

The clauses On Commit specified in a Create Table can only be used in temporal tables. If a non-temporal table has a commit, it will be commented. Also, Snowflake does not support the ON COMMIT DELETE, so it will be commented as well.

Example Code

Input Code

CREATE TABLE TABLE01 (COLNAME VARCHAR(20)) ON COMMIT PRESERVE ROWS
CREATE TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20)) ON COMMIT DELETE ROWS

Output Code

CREATE TABLE TABLE01 (COLNAME VARCHAR(20))
-- ** MSC-ERROR - MSCEWI1093 - ON COMMIT NOT SUPPORTED **
-- ON COMMIT PRESERVE ROWS
CREATE TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20))
-- ** MSC-ERROR - MSCEWI1093 - ON COMMIT NOT SUPPORTED **
-- ON COMMIT DELETE ROWS

Recommendations

  • No additional user actions are required.
  • If you need more support, you can email us at [email protected]