Qualify Object Names

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

Qualify Object Names

Postby robvon » Thu Jun 04, 2009 2:34 am

Generates: SELECT TableName.[*].... out of SELECT *....

The [*] is a syntax error. Should be just '*'
robvon
 
Posts: 4
Joined: Tue Dec 30, 2008 8:10 pm

Postby Anu Deshpande » Thu Jun 04, 2009 9:39 am

Thanks for your post.

Could you kindly let us know the steps to replicate this issue and also using which functionality of SQL Refactor generates this error?

Please make a note that above details will help us to investigate further.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby MartinB » Thu Sep 10, 2009 8:02 am

I too have this problem
It only happens when you do a join to another table

e.g.
Code: Select all
Select * from member

is Ok but
Code: Select all
SELECT
    m.*
FROM
    Member m
inner JOIN Party p
ON  m.PartyID = p.PartyID

becomes (when you qualify it)
Code: Select all
SELECT
    m.[*]
FROM
    dbo.Member m
inner JOIN dbo.Party p
ON  m.PartyID = p.PartyID
MartinB
 
Posts: 5
Joined: Fri Sep 04, 2009 10:42 am

Postby Anu Deshpande » Thu Sep 10, 2009 10:44 am

Thanks for your post and apologies for the inconvenience caused by this issue.

We have logged this issue in our internal tracking system [SR- 846] and will be addressed in our future release.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests