Information for the column was not found. STRING used to match CAST operation
This EWI is added in Table-Valued User Defined Functions where the return type of a column can not be determined during the conversion.
STRINGis used as a default to match the
CASToperation in the
CREATE FUNCTION GetDepartmentInfo()
SELECT DepartmentID, Name, GroupName
CREATE OR REPLACE FUNCTION GETDEPARTMENTINFO()
RETURNS TABLE(DEPARTMENTID STRING /*** MSC-WARNING - MSCEWI4029 - INFORMATION FOR THE COLUMN DEPARTMENTID WAS NOT FOUND. STRING DATATYPE USED TO MATCH CAST AS STRING OPERATION ***/, NAME VARCHAR(50), GROUPNAME VARCHAR(50))
SELECT CAST(DEPARTMENTID AS STRING) /*** MSC-WARNING - MSCEWI4031 - INFORMATION FOR THIS EXPRESSION WAS NOT FOUND. CAST TO STRING USED TO MATCH THE DEFAULT STRING RETURN TYPE ***/, NAME, GROUPNAME
- The user should check which is the correct datatype that could not be found and change it in the
RETURNS TABLEstatement definition.