| 
	
		| 
		
			|  | SoftTree Technologies Technical Support Forums
 |  |  
	
		| 
	
	
	
		| Author | Message |  
		| gemisigo 
 
 
 
 
			
				| Joined: 11 Mar 2010 Posts: 2175
 
 |  
 | 
			
				|  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: 7990
 
 |  
 | 
			
				|   |   |  
				| 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
 
 |  |  |