 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
Alias alignment anomaly |
|
Alias alignment fails to handle some cases properly. The raw code:
 |
 |
SELECT
a AS a
,aa AS b
,aaa AS c
|
is aligned properly and the result is:
 |
 |
SELECT
a AS a
,aa AS b
,aaa AS c
|
The following are both formatted:
 |
 |
SELECT
a AS a
,aa AS 'b'
,aaa AS [c]
SELECT
@a AS a
,@aa AS b
,@aaa AS c
|
with their respective results seen as below, though there are some disturbing differences. The first one is aligned on keyword 'AS' while the second one is aligned on the alias itself.
 |
 |
SELECT
a AS a
,aa AS 'b'
,aaa AS [c]
SELECT
@a AS a
,@aa AS b
,@aaa AS c
|
But when there are variables aliased with qualified alias names, they aren't aligned at all:
 |
 |
SELECT
@a AS a
,@aa AS 'b'
,@aaa AS [c]
|
This one is unaffected after formatting..
|
|
Fri Sep 14, 2012 5:34 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Many thanks. I will submit this issue for further investigation.
|
|
Fri Sep 14, 2012 8:06 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
|
|
|