Red Gate forums :: View topic - Change seen by source control on unchanged item
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Change seen by source control on unchanged item

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mika



Joined: 16 May 2014
Posts: 5

PostPosted: Fri May 16, 2014 10:13 am    Post subject: Change seen by source control on unchanged item Reply with quote

I just upgraded to 3.6.5.123 and when I go to the commit changes tab there are 2 changes which weren't there before.

They are both for SQL functions where dbo was changed to DBO and there was an extra dot added:

ie:
Code:
CREATE FUNCTION [dbo].[fn_GameDay_Get]
was changed to
Code:
CREATE FUNCTION .[DBO].[fn_GameDay_Get]


(notice the extra dot before the second [DBO])

When I try to undo, it says it's successful, but the changes are then still there...
Back to top
View user's profile Send private message
mika



Joined: 16 May 2014
Posts: 5

PostPosted: Mon May 19, 2014 3:31 pm    Post subject: Reply with quote

Anybody?
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 94

PostPosted: Mon May 19, 2014 7:39 pm    Post subject: Reply with quote

Hello,

Thanks for your post.

I just tried reproducing the issue with the same function name but wasn't able to get the same behavior.

We have a ticket open for you (19871) -- would you mind responding there with the full script in your repository?

Thanks,
Evan
_________________
Evan Moss
Product Support
(866) 627-8107
Back to top
View user's profile Send private message Send e-mail
mika



Joined: 16 May 2014
Posts: 5

PostPosted: Tue May 20, 2014 11:54 am    Post subject: Reply with quote

I can't - the user mika is not a registered redgate user and my boss, denise, does not have access to that ticket. I've sent a reply to the ticket to add the proper user but when logged in, she still can't see it.
Back to top
View user's profile Send private message
mika



Joined: 16 May 2014
Posts: 5

PostPosted: Tue May 20, 2014 12:09 pm    Post subject: Reply with quote

Code:
-- User Defined Function

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE FUNCTION [dbo].[fn_GameDay_Date_Get] (@GameDay int) 
RETURNS datetime  AS 

BEGIN
   DECLARE @date datetime

   SET @date = (SELECT TOP 1 GameDay_Date FROM Gaming_Day (NOLOCK) WHERE GameDay_ID = @GameDay)

   RETURN @date
END



GO
-- Permissions

GRANT EXECUTE ON  [dbo].[fn_GameDay_Date_Get] TO [Sxuser]
GO


Keeps gettings changed to

Code:
-- User Defined Function

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE FUNCTION .[DBO].[fn_GameDay_Date_Get] (@GameDay int) 
RETURNS datetime  AS 

BEGIN
   DECLARE @date datetime

   SET @date = (SELECT TOP 1 GameDay_Date FROM Gaming_Day (NOLOCK) WHERE GameDay_ID = @GameDay)

   RETURN @date
END



GO
-- Permissions

GRANT EXECUTE ON  [DBO].[fn_GameDay_Date_Get] TO [Sxuser]
GO


This is copies from the commit changes compare window in sql source control. There was no actual change.
Back to top
View user's profile Send private message
mika



Joined: 16 May 2014
Posts: 5

PostPosted: Tue May 20, 2014 12:15 pm    Post subject: Reply with quote

Ah interesting. I tracked it down to the fact that that actual function has always had the full stop before the .[dbo]. So the thing that has actually changed is that with the latest release you are "seeing" it and "fixing" it automatically.

Worth noting: It seems that SQL has allowed it all these years (this funciton has been there forever as is)

Nothing to do for me though - I will fix it my side.

Thanks.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group