[jira] [Created] (CALCITE-7486) Operators in MATCH_RECOGNIZE don't support SqlLiterals

[Sergey Nuyanzin (Jira)]

Sergey Nuyanzin created CALCITE-7486:
----------------------------------------

             Summary: Operators in MATCH_RECOGNIZE don't support SqlLiterals
                 Key: CALCITE-7486
                 URL: https://issues.apache.org/jira/browse/CALCITE-7486
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Sergey Nuyanzin
            Assignee: Sergey Nuyanzin


Issue is same for {{LAST}}, {{FIRST}}, {{PREV}}, {{NEXT}}

example of query
{code:sql}
SELECT *
FROM emp
MATCH_RECOGNIZE (
  MEASURES
    FIRST(DOWN.empno + DOWN.deptno + 1) AS bottom_total
  PATTERN (DOWN{2,})
  DEFINE
    DOWN AS EMP.EMPNO < 1
)
{code}

while unparsing it wil lbe unparsed as 
{code:sql}
SELECT `EXPR$0`.`BOTTOM_TOTAL`
FROM `CATALOG`.`SALES`.`EMP` AS `EMP` MATCH_RECOGNIZE(
MEASURES FINAL (FIRST(`DOWN`.`EMPNO` + `DOWN`.`DEPTNO`, 0) + FIRST(1, 0)) AS 
`BOTTOM_TOTAL`
PATTERN (`DOWN` { 2, })
DEFINE `DOWN` AS `EMP`.`EMPNO` < 1) AS `EXPR$0
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)