sp_describe_undeclared_parameters Case Sensitive Despite Collation - by Chris_Downing

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 795002 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 7/25/2013 9:28:12 AM
Access Restriction Public


We recently upgraded one of our databases to 2012 Compatibility Mode, and are now getting an error from sp_describe_undeclared_parameters when running an SSIS package that one of the parameters for a stored procedure in the upgraded database isn't valid.  We found that system sproc from a trace, and it looks like the OLEDB Command task we're using to execute the stored procedure hits that to validate the command (treating it as dynamic SQL).
We've tracked it down to the parameter in the command in the package not having the same case as the parameter in the stored procedure.  This obviously wasn't an issue prior to 2012, and we've been able to reproduce it with other stored procedures and parameters.

This is easily reproduced for us with the following queries:
create proc test @test1 varchar(128) as
select * from sys.objects where [name] = @test1
exec sp_describe_undeclared_parameters N'exec test @test1 = @P1' --runs successfully
exec sp_describe_undeclared_parameters N'exec test @Test1 = @P1' --invalid parameter
exec test @test1 = 'test' --Runs successfully
exec test @Test1 = 'test' --Runs successfully

Both the server and database have collations of SQL_Latin1_General_CP1_CI_AS.
Sign in to post a comment.
Posted by Microsoft on 11/5/2013 at 1:31 PM
Hello Chris,
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing this bug and we will revisit in the future. Thanks again for reporting the product issue and continued support in improving our product.

Ajay Jagannathan
Senior Program Manager
Posted by Chris_Downing on 7/29/2013 at 12:09 PM
Since this was marked as "Won't Fix", just curious if it's because this is working as intended, or if it's for another reason... Thanks!