Open
Description
code to reproduce the issue:
EXEC tSQLt.NewTestClass xxxxx
GO
CREATE PROCEDURE xxxxx.testRShSV
AS
BEGIN
CREATE TABLE xxxxx.xtwv(Id INT,sv SQL_VARIANT)
INSERT xxxxx.xtwv(id,sv)VALUES(1,CAST(13 AS INT))
INSERT xxxxx.xtwv(id,sv)VALUES(2,CAST('xx' AS VARCHAR(13)))
INSERT xxxxx.xtwv(id,sv)VALUES(3,CAST('45' AS CHAR(2)))
INSERT xxxxx.xtwv(id,sv)VALUES(4,CAST(NULL AS DECIMAL))
SELECT *,SQL_VARIANT_PROPERTY(sv,'BaseType ') FROM xxxxx.xtwv;
INSERT INTO xxxxx.xtwv
EXEC tSQLt.ResultsetFilter 1, 'SELECT * FROM xxxxx.xtwv;';
SELECT *,SQL_VARIANT_PROPERTY(sv,'BaseType ') FROM xxxxx.xtwv;
END
GO
EXEC tSQLt.Run xxxxx;