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.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI1092

MSCEWI1094

Last modified 3mo ago