Red Gate forums :: View topic - Found a bug in SQL Prompt 6.2.0.366
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

Found a bug in SQL Prompt 6.2.0.366

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PaulShearing



Joined: 02 Apr 2014
Posts: 1
Location: Caterham, Surrey UK

PostPosted: Wed Apr 02, 2014 12:58 pm    Post subject: Found a bug in SQL Prompt 6.2.0.366 Reply with quote

Not sure if this is fixed in 6.3 but. If you rename a database field that is mentioned in an UPDATE() statement in a trigger, the field is not renamed correctly. Note this is the UPDATE([Fieldname]) syntax that returns true if a field has been updated, not the UPDATE [Table] SET [Fieldname] = xyz syntax for performing a database update.

For example, rename a field [Alpha] to [Alpha123]. In an Update trigger for the table containing this field is the statement:

IF UPDATE([Alpha])
do some SQL stuff
;

This is checking to see if [Alpha] has been modified by the table update and of course it should be changed to IF UPDATE([Alpha123]) ... but it isn't and thus it causes the smart rename transaction to fail. Other references to [Alpha] within the trigger procedure are renamed correctly, looks like Prompt needs to check within an UPDATE() statement.

Hope this helps
Back to top
View user's profile Send private message
David Priddle



Joined: 28 Jan 2014
Posts: 36
Location: Red Gate Software, Cambridge

PostPosted: Wed Apr 02, 2014 3:47 pm    Post subject: Reply with quote

Hi Paul,

Thanks for the bug report!

We've managed to reproduce this here (it looks like it's not being recognised as a dependency).

We've logged this issue internally with an ID of SP-5076.

Best regards,

David
Back to top
View user's profile Send private message Send e-mail
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