Comment on page
MSCEWI4029
Information for the column was not found. STRING used to match CAST operation
Medium
This EWI is added in Table-Valued User Defined Functions where the return type of a column can not be determined during the conversion.
STRING
is used as a default to match the CAST
operation in the SELECT
statementCREATE FUNCTION GetDepartmentInfo()
RETURNS TABLE
AS
RETURN
(
SELECT DepartmentID, Name, GroupName
FROM HumanResources.Department
);
CREATE OR REPLACE FUNCTION GetDepartmentInfo ()
RETURNS TABLE(
DepartmentID STRING /*** MSC-ERROR - MSCEWI4029 - INFORMATION FOR THE COLUMN DepartmentID WAS NOT FOUND. STRING DATATYPE USED TO MATCH CAST AS STRING OPERATION ***/,
Name STRING /*** MSC-ERROR - MSCEWI4029 - INFORMATION FOR THE COLUMN Name WAS NOT FOUND. STRING DATATYPE USED TO MATCH CAST AS STRING OPERATION ***/,
GroupName STRING /*** MSC-ERROR - MSCEWI4029 - INFORMATION FOR THE COLUMN GroupName WAS NOT FOUND. STRING DATATYPE USED TO MATCH CAST AS STRING OPERATION ***/
)
AS
$$
SELECT
CAST(DepartmentID AS STRING) /*** MSC-ERROR - MSCEWI4031 - INFORMATION FOR THIS EXPRESSION WAS NOT FOUND. CAST TO STRING USED TO MATCH THE DEFAULT STRING RETURN TYPE. ***/,
CAST(Name AS STRING) /*** MSC-ERROR - MSCEWI4031 - INFORMATION FOR THIS EXPRESSION WAS NOT FOUND. CAST TO STRING USED TO MATCH THE DEFAULT STRING RETURN TYPE. ***/,
CAST(GroupName AS STRING) /*** MSC-ERROR - MSCEWI4031 - INFORMATION FOR THIS EXPRESSION WAS NOT FOUND. CAST TO STRING USED TO MATCH THE DEFAULT STRING RETURN TYPE. ***/
FROM
HumanResources.Department
$$;
- The user should check which is the correct data type that could not be found and change it in the
RETURNS TABLE
statement definition.