Home Dashboard Directory Help
Search

sp_describe_first_result_set and system_type_name NULL by Andrea_Benedetti


Status: 

Closed
 as Fixed Help for as Fixed


4
0
Sign in
to vote
Type: Bug
ID: 765998
Opened: 10/3/2012 3:58:44 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

If you exec this script:

EXEC sp_describe_first_result_set @tsql = N'exec [AdventureWorks2012].[dbo].[uspGetEmployeeManagers] 1';

You can find NULL on [system_type_name] when system_type_id is not unique in sys.types.

Maybe, internally, the join must be:
sys.columns.system_type_id = sys.types.user_type_id
Details
Sign in to post a comment.
Posted by Microsoft on 1/4/2013 at 12:58 PM
Hello Andrea,
We have now fixed the issue for the next major version of SQL Server. We may port it to a future SQL Server 2012 cumulative update if there are many occurrences of this issue.

--
Umachandar, SQL Programmability Team
Posted by Microsoft on 10/9/2012 at 12:38 PM
Hello Andrea,
Thanks for reporting this issue. We will take a look at it & get back to you.

--
Umachandar, SQL Programmability Team
Sign in to post a workaround.