MSCEWI1065

Columns from expression not found

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

Severity

Medium

Description

This error happens when the columns of a Select Expression were unable to be resolved, usually when it either refers to a Type Access whose reference wasn't resolved or a column with a User Defined Type whose columns haven't been defined; such as a Type Without Body or Object Type with no columns.

Example Code

Input Code (Oracle):

--Type without columns
CREATE TYPE type1;

--Another valid type without columns
--CREATE TYPE type1 AS OBJECT();

CREATE TABLE table1
(
column1 type1
);

SELECT
column1
FROM table1;

Output Code:

-- ** MSC-ERROR - MSCEWI1057 - CREATE TYPE WITHOUT BODY VARIANT IS NOT SUPPORTED **
--Type without columns
--CREATE TYPE type1;

CREATE TABLE table1
(
column1 type1 /*** MSC-WARNING - MSCEWI1062 - CUSTOM TYPE 'type1' USAGE CHANGED TO VARIANT ***/
);

SELECT
column1 /*** MSC-ERROR - MSCEWI1065 - COLUMNS FROM EXPRESSION NOT FOUND ***/
FROM table1;

Recommendations

• Verify that the type definition that was referenced does have columns within it.

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