Behavior changes of value() in SQL Server 2012 - by carlop

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 776560 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/14/2013 11:00:08 PM
Access Restriction Public


The following query returns different results in SQL2008 and SQL2012:
   declare @hexstring varchar(max) = NULL
   select cast('' as xml).value('xs:hexBinary( substring(sql:variable("@hexstring"), 0) )', 'varbinary(max)')

in SQL2008 returns NULL
in SQL2012 returns 0x

In the changelog documentation there's no word about this
Sign in to post a comment.