Dawid Wysakowicz created CALCITE-2708:
-----------------------------------------

             Summary: UDAGs are not verified for single pattern variable in 
MATCH_RECOGNIZE
                 Key: CALCITE-2708
                 URL: https://issues.apache.org/jira/browse/CALCITE-2708
             Project: Calcite
          Issue Type: Bug
            Reporter: Dawid Wysakowicz
            Assignee: Julian Hyde


Query:

{code}
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