sys.syscacheobjects CacheObjType column too short - by Sean Gallardy

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 781682 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 3/19/2013 8:41:31 AM
Access Restriction Public


In the compatibility view sys.syscacheobjects the data type is NVARCHAR(17) though there are items such as 'Compiled Plan Stub' that are 18 characters in length. This causes them to show up truncated, as such using these (which I would argue not to use, though many books and reference articles still do) could cause results to not come back when searching for truncated items. If the data type was switched to NVARCHAR(50) the items would not be truncated. 

This would bring it in line with sys.dm_exec_cached_plans which is a NVARCHAR(50).

Example: Compiled Plan Stub shows up as "Compiled Plan Stu"
Sign in to post a comment.
Posted by Microsoft on 7/17/2013 at 9:39 AM
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. Thanks again for reporting the product issue and continued support in improving our product.

Posted by Sean Gallardy on 3/22/2013 at 12:27 PM
Wow - closed as won't fix and no comment or explanation from MS?