Links

MSCEWI1062

Custom type usage changed to variant

Severity

Low

Description

This message appears when a Custom Type is referenced, and then its usage is changed to variant.
This message is heavily related to MSCEWI1056 and MSCEWI1063.

Example code

Input Code (Oracle):

CREATE TYPE type1 AS OBJECT(type1_column1 INT);
CREATE TABLE table1
(
column1 type1
);

Output Code:

-- ** MSC-WARNING - MSCEWI1056 - CUSTOM TYPES ARE NOT SUPPORTED IN SNOWFLAKE BUT REFERENCES TO THIS CUSTOM TYPE WERE CHANGED TO A VARIANT **
--CREATE TYPE type1 AS OBJECT(type1_column1 INT);
CREATE TABLE table1
(
column1 VARIANT /*** MSC-WARNING - MSCEWI1062 - CUSTOM TYPE 'type1' USAGE CHANGED TO VARIANT ***/,
);
--** MSC-WARNING - MSCEWI1063 - ADDED STATEMENTS BECAUSE 'table2' USED A CUSTOM TYPE **
CREATE OR REPLACE VIEW PUBLIC.table2_view AS
SELECT
column1:type1_column1 :: INTEGER AS column1
FROM table1;

Recommendations

  • Remember to transform all of its input data into a Variant-compliant datatype as well.
  • 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.