[jira] [Commented] (CALCITE-7470) Unparse of DEFINE in MATCH_RECOGNIZE leads to incorrect SQL

[Sergey Nuyanzin (Jira)]

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

Sergey Nuyanzin commented on CALCITE-7470:
------------------------------------------

Thanks for the review [~caicancai]

> Unparse of DEFINE in MATCH_RECOGNIZE leads to incorrect SQL
> -----------------------------------------------------------
>
>                 Key: CALCITE-7470
>                 URL: https://issues.apache.org/jira/browse/CALCITE-7470
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Sergey Nuyanzin
>            Assignee: Sergey Nuyanzin
>            Priority: Major
>              Labels: pull-request-available
>
> Example of query
> {code:sql}
> SELECT *
> FROM emp
> MATCH_RECOGNIZE (
>   MEASURES
>      FINAL COUNT(A.deptno) AS deptno
>   PATTERN (A B)
>   DEFINE
>     A AS A.empno = 123
> ) AS T
> {code}
> rewrites to 
> {code:sql}
> SELECT *
> FROM `EMP` MATCH_RECOGNIZE(
> MEASURES FINAL COUNT(`A`.`DEPTNO`) AS `DEPTNO`
> PATTERN (`A` `B`)
> DEFINE `A` AS (PREV(`A`.`EMPNO`, 0) = 123 AS `A`)) AS `T`
> {code}
> where {{DEFINE `A` AS (PREV(`A`.`EMPNO`, 0) = 123 AS `A`)}} contains 2 {{AS}} 
> operators and fails after parsing again



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