[ 
https://issues.apache.org/jira/browse/CALCITE-2708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16700171#comment-16700171
 ] 

Julian Hyde commented on CALCITE-2708:
--------------------------------------

{{match.iq}} is in [Quidem|https://github.com/julianhyde/quidem] format. You 
can run {{CoreQuidemTest}} in a debugger with arguments {{sql/match.iq}}.

> In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined 
> aggregate function come from a single pattern variable
> ---------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: CALCITE-2708
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2708
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Dawid Wysakowicz
>            Assignee: Julian Hyde
>            Priority: Major
>              Labels: match
>
> In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined 
> aggregate function (UDAF) come from a single pattern variable.
> Query:
> {code:java}
> SELECT *
> FROM Ticker
> MATCH_RECOGNIZE (
>   ORDER BY proctime
>   MEASURES
>     udagg(A.price + B.tax) AS taxedPrice
>   PATTERN (A B)
>   DEFINE
>     A AS A.symbol = 'a'
> ) AS T
> {code}
> should fail with ValidationException, because udagg is applied to different 
> pattern variables.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to