[CALCITE-2708] In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined aggregate function come from a single pattern variable

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: match
• Assignee: Unassigned
• Reporter: Dawid Wysakowicz
• Created: 26/Nov/18 15:24
• Updated: 01/Oct/19 15:38

Description

In MATCH_RECOGNIZE, validator must ensure that arguments to a user-defined aggregate function (UDAF) come from a single pattern variable.

Query:

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

should fail with ValidationException, because udagg is applied to different pattern variables.