Minor capitalisation detection bug
mattbenham
Posts: 13 Bronze 1
There appears to be a minor bug in Source Control 7.2.35.13078 . It is not detecting changes in capitalisation - in particular in string literals in stored procedures.
For example if you have a stored procedure that simply executes "SELECT 'TEST' " and then change "TEST" to lower case, SQL Source Control does not detect the change.
I had an example where an external partner needed a subtle case change in an XML string generated by a stored procedure. I had to make a superfluous minor change to the SP to get Source Control to detect and commit the intended change.
For example if you have a stored procedure that simply executes "SELECT 'TEST' " and then change "TEST" to lower case, SQL Source Control does not detect the change.
I had an example where an external partner needed a subtle case change in an XML string generated by a stored procedure. I had to make a superfluous minor change to the SP to get Source Control to detect and commit the intended change.
Tagged:
Best Answer
-
DanC Posts: 628 Gold 5Hi @mattbenham
The team have mentioned using the following option "Use case-sensitive object definition"
I have tested this and it works for me!Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Answers
Sorry, you're experiencing this issue!
I can confirm I've been able to reproduce this in the latest version also, I'm going to verify this behavior with the development team and I'll let you know any updates!
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
I've passed that information along to the team, hopefully, everything will run smoothly for you now!
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?