You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Sergey Nuyanzin (Jira)" <ji...@apache.org> on 2026/05/20 22:06:00 UTC

[jira] [Created] (CALCITE-7538) SqlValidatorImpl should reject MATCH_RECOGNIZE with duplicate MEASURE

Sergey Nuyanzin created CALCITE-7538:
----------------------------------------

             Summary: SqlValidatorImpl should reject MATCH_RECOGNIZE with duplicate MEASURE
                 Key: CALCITE-7538
                 URL: https://issues.apache.org/jira/browse/CALCITE-7538
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Sergey Nuyanzin
            Assignee: Sergey Nuyanzin


Right now a query like 
{code:sql}
SELECT *
FROM emp
MATCH_RECOGNIZE (
  MEASURES
    A.deptno AS deptno,
    A.deptno AS deptno
  PATTERN (A B)
  DEFINE
    A AS A.empno = 123
)
{code}
passes validation and fails while SqlToRel conversion.
Ideally it should fail while validation



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