keywords as alias issues

ggeier · January 11, 2017 9:25AM

When using the "Format SQL" feature, it's failing/removing brackets when the alias is a SQL keyword.

select top 1  &#91;start&#93; = 'wwww', &#91;end&#93; = 'xxxx'
from sys.objects o

select top 1  'wwww' as 'start','xxxx' as 'end'
from sys.objects o

formats to:

select top 1  start = 'wwww', &#91;end&#93; = 'xxxx'
from sys.objects o;

select top 1  start = 'wwww',end = 'xxxx'
from sys.objects o;

Harry Frankish · January 13, 2017 7:20AM

Hi ggeier

Thanks for reporting this. We've reproduced the issue and are working on a fix.

Cheers
Harry

Harry Frankish · January 13, 2017 8:51AM

Hi ggeier

I think this is fixed in this build (http://download.red-gate.com/EAP/SQLPro ... .0.224.exe)

Please let us know if this fixes the issue for you

Cheers
Harry

Comments