[jira] [Commented] (CALCITE-2708) In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined aggregate function come from a single pattern variable
[ https://issues.apache.org/jira/browse/CALCITE-2708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16700063#comment-16700063 ] Dawid Wysakowicz commented on CALCITE-2708: --- Hi [~julianhyde] It sounds like a good idea to have some common tests set, I will try to contribute back some tests that we use. Any pointers to some explanation what is the format of the {{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)
[jira] [Commented] (CALCITE-2708) In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined aggregate function come from a single pattern variable
[ 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)