MSCEWI2046

Temporary Table might have duplicated rows.

Severity

Low

Description

Temporary Table might have duplicated rows.

Example Code

Input Code:

CREATE VOLATILE TABLE SOMETABLE, LOG AS 
(SELECT BUS_PLAN_MEAS_DTL_ROW_ID
, BUS_PLAN_TYP_CD
, MEAS_PLAN_TYP_CD
, MEAS_SUB_PLAN_TYP_CD
, WSLR_PARTY_ID FROM T1);


CREATE SET VOLATILE TABLE SOMETABLE, LOG AS 
(SELECT BUS_PLAN_MEAS_DTL_ROW_ID
, BUS_PLAN_TYP_CD
, MEAS_PLAN_TYP_CD
, MEAS_SUB_PLAN_TYP_CD
, WSLR_PARTY_ID FROM T2);

Output Code:

/*** MSC-WARNING - MSCEWI2046 - Temporary Table might have duplicated rows ***/
CREATE TEMPORARY TABLE DATAWAREHOUSE.PUBLIC.SOMETABLE AS
(SELECT
BUS_PLAN_MEAS_DTL_ROW_ID,
BUS_PLAN_TYP_CD,
MEAS_PLAN_TYP_CD,
MEAS_SUB_PLAN_TYP_CD,
WSLR_PARTY_ID
FROM DATAWAREHOUSE.PUBLIC.T1) ;

/*** MSC-WARNING - MSCEWI2015 - SET TABLE FUNCTIONALITY NOT SUPPORTED ***/
/*** MSC-WARNING - MSCEWI2046 - Temporary Table might have duplicated rows ***/
CREATE TEMPORARY TABLE DATAWAREHOUSE.PUBLIC.SOMETABLE AS
(SELECT
BUS_PLAN_MEAS_DTL_ROW_ID,
BUS_PLAN_TYP_CD,
MEAS_PLAN_TYP_CD,
MEAS_SUB_PLAN_TYP_CD,
WSLR_PARTY_ID
FROM DATAWAREHOUSE.PUBLIC.T2) ;

Recommendations

Last updated