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

Active

Type:	Bug
ID:	776560
Opened:	1/14/2013 11:00:08 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

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

Details (expand)

English

SQL Server 2012 - Developer Edition

XML Programmability

Windows 7 Ultimate

English

Just run the query using management studio:
declare @hexstring varchar(max) = NULL
select cast('' as xml).value('xs:hexBinary( substring(sql:variable("@hexstring"), 0) )', 'varbinary(max)')

Tested with SQL2012 with/without SP1 and SQL 2008 R2

in SQL2008 returns NULL
in SQL2012 returns 0x

NULL in both cases

X64

0 attachments

Microsoft