How can we help you today? How can we help you today?

Minor capitalisation detection bug

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.
mattbenham
0

Comments

5 comments

Sort by
  • DanC
    Hi @mattbenham

    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!
    DanC
    0
  • mattbenham
    Perfect, thanks.
    mattbenham
    0
  • DanC
    Hi @mattbenham

    The team have mentioned using the following option "Use case-sensitive object definition"

    I have tested this and it works for me!
    DanC
    0
  • mattbenham
    Thanks, that should do the trick.  You may want to look at rewording the description next to that option as it is a little misleading as it only refers to object names, where in my case it was about a string literal.
    mattbenham
    0
  • DanC
    Hi @mattbenham

    I've passed that information along to the team, hopefully, everything will run smoothly for you now!
    DanC
    0

Add comment

Please sign in to leave a comment.