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.


2
0
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

Description

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.