Qualify Object Names

robvon

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

The [*] is a syntax error. Should be just '*'

Anu D

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.

MartinB

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

e.g.

Select * from member 

is Ok but

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

becomes (when you qualify it)

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

Anu D

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.