Red Gate forums :: View topic - Qualify Object Names
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

Qualify Object Names

Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
robvon



Joined: 30 Dec 2008
Posts: 4

PostPosted: Thu Jun 04, 2009 2:34 am    Post subject: Qualify Object Names Reply with quote

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

The [*] is a syntax error. Should be just '*'
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Thu Jun 04, 2009 9:39 am    Post subject: Reply with quote

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



Joined: 04 Sep 2009
Posts: 5

PostPosted: Thu Sep 10, 2009 8:02 am    Post subject: Reply with quote

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

e.g.
Code:

Select * from member

is Ok but
Code:

SELECT
    m.*
FROM
    Member m
inner JOIN Party p
ON  m.PartyID = p.PartyID

becomes (when you qualify it)
Code:

SELECT
    m.[*]
FROM
    dbo.Member m
inner JOIN dbo.Party p
ON  m.PartyID = p.PartyID
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Thu Sep 10, 2009 10:44 am    Post subject: Reply with quote

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
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