Bug in formatting CLR User-defined aggregate on distinct value ?
Posted: Mon 15 Apr 2013 13:18
Hello, I have a CLR User-defined aggregate.
Formatting T-SQL code that references this aggregate like below
results in errors:
Error (28,1): Unexpected symbol ')' (U+0029)
Error (13,33): Unexpected symbol '('
Error (13,34): Unexpected symbol 'distinct'
Error (28,1): Unexpected symbol ')' (U+0029)
After removing the keyword "distinct", the formatting is done without errors
Formatting T-SQL code that references this aggregate like below
Code: Select all
select Val = System.agg_CommaJoin(distinct Q.Col)
from
(
select Col = 'A'
union all select 'B'
) as QError (28,1): Unexpected symbol ')' (U+0029)
Error (13,33): Unexpected symbol '('
Error (13,34): Unexpected symbol 'distinct'
Error (28,1): Unexpected symbol ')' (U+0029)
After removing the keyword "distinct", the formatting is done without errors