XML Element case-sensitive, change not recognized by SSC

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

XML Element case-sensitive, change not recognized by SSC

Postby PDinCA » Thu Sep 13, 2012 5:48 pm

Changing an XML element name in a xml.query() from PriorTierCanAccept to priorTierCanAccept in multiple SPs is not recognized as a change by SSC.

Perhaps SSC should IGNORE the DATABASE case-sensitivity and treat text as text: find any change to be significant enough to update the repository.
PDinCA
 
Posts: 517
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby Brian Donahue » Mon Sep 17, 2012 4:13 pm

Hello,

This sounds fair. You'll want database collation to be considered normally, but XML is usually case-sensitive, so any queries would be broken if the case was incorrect. I've logged a bug SC-6039 about this. I can't promise anything though. It doesn't sound like it would be trivial to implement.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby freecell1 » Wed May 08, 2013 3:49 pm

Any update on this? I posted in another thread about this (for varchar, not XML). Ideally even on case insensitive collated databases, changed-case string could be committed and transferred to other devs via SSC. I've even tried tricking it by updating a second field (like a datestamp). The behavior is that the other dev gets the new date value but the string value is left unchanged.

But the INSERT statements stored in the static data script in svn are picking up the correct case.
freecell1
 
Posts: 21
Joined: Tue Mar 13, 2012 8:21 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests