|
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2141
|
|
[SA 6 Beta] - Refactoring - Qualifying object names |
|
There is something fishy going on when refactoring to qualify object names. I tried it with a quite complex query with multiple joins including subqueries. Refactoring only suggested to add schemas names to the subqueries and even those suggestions were incorrect.
|
|
Wed Jul 13, 2011 4:15 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
|
To be honest with you, in all versions the Qualify Object Names function is not fool proof. It isn't always able to figure out full object names and accurately qualify them. In essence, the Qualify Object Names function attempts to parses the code in off-line mode, not relying much on current connection trying to figure out without database context what is what in the code. Since SQL isn't a strongly typed language, object names can be ambiguous and db context dependent, isn't always possible to figure full object path and name. Multi-database type support adds another dimension to an already complex processing. So the he function touches only the names it recognizes.
Having said that, we are trying to improve the accuracy of that function in every SQL Assistant version. For example, in version 6 it should be able to recognize CTE names, and also recognize sequences. If come across a piece of SQL code that the function is unable to process accurately, please provide us with an example, that will help us to improve the function working in future builds.
|
|
Wed Jul 13, 2011 8:54 am |
|
|
gemisigo
Joined: 11 Mar 2010 Posts: 2141
|
|
|
|
I tried to do something similar in the past and I must admit, it isn't a simple task to do. May I ask what language are you doing the code parsing in?
|
|
Fri Jul 15, 2011 3:19 am |
|
|
|
|
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
|
|
|