[
https://issues.apache.org/jira/browse/CALCITE-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16724795#comment-16724795
]
Dawid Wysakowicz commented on CALCITE-2747:
-------------------------------------------
Oracle gives: {{ORA-00918: column ambiguously defined}}
> No exception when ambiguous column reference defined in PARTITION BY and
> MEASURES clause
> -----------------------------------------------------------------------------------------
>
> Key: CALCITE-2747
> URL: https://issues.apache.org/jira/browse/CALCITE-2747
> Project: Calcite
> Issue Type: Bug
> Reporter: Dawid Wysakowicz
> Assignee: Julian Hyde
> Priority: Major
> Labels: match
>
> Query:
> {code}
> SELECT *
> FROM MyTable
> MATCH_RECOGNIZE (
> PARTITION BY id
> ORDER BY proctime
> MEASURES
> A.id AS id
> PATTERN (A)
> DEFINE
> A AS name = 'a'
> ) AS T
> {code}
> should fail because of ambiguous {{id}} column.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
