Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Bug: commit changes showing no changes

I've just had a stored procedure that I haven't modified come up as having changes to commit. The Previous and Next buttons are disabled as though there are no differences and I can't see any differences. Yet it repeatedly comes up as an object with changes. Huh?

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
lakeland shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • [Deleted User] commented  ·   ·  Report

    Thank you for reporting this bug to us. Its reference number is SOC-1047.

    The issue is that we don't fully handle whitespace changes within strings. The object is detected to be different (and hence it is shown in the commit list, and you can commit it, etc), but the display at the bottom of the commit tab doesn't show you how the whitespace has changed (the previous and next buttons are disabled, etc). I agree that this is very confusing, but hopefully you should be able to carry on using SQL Source Control.

  • lakeland commented  ·   ·  Report

    I just checked at the command line and there were changes - so the issue is with the prev/next buttons

    Index: Stored Procedures/dbo.sp_stg_autocorrect.sql
    ===================================================================
    --- Stored Procedures/dbo.sp_stg_autocorrect.sql (revision 1525)
    +++ Stored Procedures/dbo.sp_stg_autocorrect.sql (working copy)
    @@ -643,8 +643,8 @@
    SELECT @dynamic_SQL = @dynamic_SQL
    + ' where exists (select 1 from #records_to_abort a ' ;

    SELECT @dynamic_SQL = @dynamic_SQL
    - + ' where a.log_id = r.log_id and '
    - SELECT @dynamic_SQL = @dynamic_SQL + 'a.row_id = r.row_id)' ;

    + + ' where a.log_id = r.log_id and'
    + SELECT @dynamic_SQL = @dynamic_SQL + 'a.row_id = r.row_id)' ;

    IF (@dynamic_SQL IS NOT NULL)
    @@ -665,8 +665,8 @@
    SELECT @dynamic_SQL = @dynamic_SQL
    + ' where exists (select 1 from #records_to_abort a ' ;

    SELECT @dynamic_SQL = @dynamic_SQL + ' where a.log_id = '
    - + @stg_name + '.log_id and '
    - SELECT @dynamic_SQL = @dynamic_SQL + ' a.row_id = '
    + + @stg_name + '.log_id and'
    + SELECT @dynamic_SQL = @dynamic_SQL + 'a.row_id = '
    + @stg_name + '.row_id)' ;

    select @rowcount = @@ROWCOUNT