Found a bug in SQL Prompt 6.2.0.366

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Found a bug in SQL Prompt 6.2.0.366

Postby PaulShearing » Wed Apr 02, 2014 12:58 pm

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
PaulShearing
 
Posts: 1
Joined: Wed Apr 02, 2014 12:46 pm
Location: Caterham, Surrey UK

Postby David Priddle » Wed Apr 02, 2014 3:47 pm

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
David Priddle
 
Posts: 36
Joined: Tue Jan 28, 2014 10:22 am
Location: Red Gate Software, Cambridge


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests