MSCEWI3028

MULTISET operator is not supported.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

Multiset operator is not currently supported for cast functions.

Example Code

Input Code:

SELECT CAST( MULTISET(SELECT * from a_b_t) as a_b_table) FROM DUAL;

Output Code:

SELECT
/*** MSC-ERROR - MSCEWI3028 - MULTISET OPERATOR NOT SUPPORTED ***/
/*** MSC-ERROR - MSCEWI3001 - TYPE NOT SUPPORTED ***/
CAST_UDF('CAST( MULTISET(SELECT * from PUBLIC.a_b_t) as a_b_table)')
FROM DUAL;

Recommendations

• The cast is converted to a user-defined function (UDF), so you can modify it to emulate the behavior of the cast function.

• If you need more support, you can email us at [email protected]