MSCEWI4018

Object_Id replace with select statement

This EWI is deprecated. If you get it from a migration, we recommend updating SnowConvert and re-run the migration.
Severity
Low
Description
This EWI is added when SnowConvert replaces an ObjectID function with a Select Statement in order to preserve functional equivalence.
Code Example
Input Code:
IF OBJECT_ID(@ObjectName) IS NULL
    SELECT * FROM TABLE1;
Output Code:
--** MSC-WARNING - MSCEWI4018 - OBJECT_ID FUNCTION IS NOT SUPPORTED IN SNOWFLAKE. A SELECT IS INSERTED TO EMULATE BEHAVIOR**
(SELECT OBJECT_SCHEMA || '.' || OBJECT_NAME AS object_id FROM INFORMATION_SCHEMA.OBJECT_PRIVILEGES WHERE object_id = 'PUBLIC.TABLE1')
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.

MSCEWI4017

MSCEWI4019

Last modified 1yr ago