Bug in formatting CLR User-defined aggregate on distinct value ?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
sov
Posts: 16
Joined: Tue 26 Mar 2013 07:05

Bug in formatting CLR User-defined aggregate on distinct value ?

Post by sov » Mon 15 Apr 2013 13:18

Hello, I have a CLR User-defined aggregate.
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 Q
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
Last edited by sov on Thu 18 Apr 2013 07:56, edited 1 time in total.

alexa

Re: Bug in formatting CLR User-defined aggregate on distinct value ?

Post by alexa » Wed 17 Apr 2013 08:04

Could you please clarify what product you were referring to?

sov
Posts: 16
Joined: Tue 26 Mar 2013 07:05

Re: Bug in formatting CLR User-defined aggregate on distinct value ?

Post by sov » Thu 18 Apr 2013 07:55

Sorry, SQL Complete 4.0.72

alexa

Re: Bug in formatting CLR User-defined aggregate on distinct value ?

Post by alexa » Fri 19 Apr 2013 12:33

This issue will be fixed in the next build of the product. We will notify you once it's available for downloading.

Post Reply