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

BUG when using scalar functions called getdate

Hey Redgate,

To enable deterministic testing using tSQLt, we replace any system calls to non-determinstic native functions like GETDATE() or GETUTCDATE() with [dbo].[getdate] user defined scalar functions (which we can then which to [test].[getdate] as part of tSQLt testing). Unfortunately it seems RG Source Control trips up on this and fails to recognise these as valid functions in the [Get Latest] tab. This means that we can't deploy using RedGate Source Control as it's usage is pretty ubiquious and with this being ignored many of our other functions fail to deploy. For user defined scalar functions named something like [dbo].[getdate2] it works fine, so I can only assume you're specifically ignoring svn files named like this. Can this bug please be registered and fixed?

Cheers
rodske
0

Comments

2 comments

Sort by
  • Rob C
    Hi,

    Thanks for the feedback. I've replicated the problem and filed a bug report. The bug has reference SC-7923. I'll let you know when I hear anything about a possible bugfix.

    Thanks.
    Rob C
    0
  • Rob C
    The latest frequent update release of SQL Source Control contains a bugfix for this problem. Here's a download link if you need it.
    Rob C
    0

Add comment

Please sign in to leave a comment.