You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by "snuyanzin (via GitHub)" <gi...@apache.org> on 2026/04/23 14:31:36 UTC
[PR] [CALCITE-7486] Operators in MATCH_RECOGNIZE don't support `SqlLiterals` [calcite]
snuyanzin opened a new pull request, #4907:
URL: https://github.com/apache/calcite/pull/4907
## Jira Link
[CALCITE-7486](https://issues.apache.org/jira/browse/CALCITE-7486)
This PR is based on https://github.com/apache/calcite/pull/4899
## Changes Proposed
In case of literals there might be unparsed SQL produced
like for the case
```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
)
```
there will unparsed version
```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
```
`FIRST(1, 0)` is failing right now, the PR makes it tolerant to such calls, same for other `MATCH_RECOGNIZE` operators like `PREV`, `NEXT`, `LAST`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@calcite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] [CALCITE-7486] Operators in MATCH_RECOGNIZE don't support `SqlLiterals` [calcite]
Posted by "sonarqubecloud[bot] (via GitHub)" <gi...@apache.org>.
sonarqubecloud[bot] commented on PR #4907:
URL: https://github.com/apache/calcite/pull/4907#issuecomment-4305817910
## [](https://sonarcloud.io/dashboard?id=apache_calcite&pullRequest=4907) **Quality Gate passed**
Issues
 [0 New issues](https://sonarcloud.io/project/issues?id=apache_calcite&pullRequest=4907&issueStatuses=OPEN,CONFIRMED&sinceLeakPeriod=true)
 [0 Accepted issues](https://sonarcloud.io/project/issues?id=apache_calcite&pullRequest=4907&issueStatuses=ACCEPTED)
Measures
 [0 Security Hotspots](https://sonarcloud.io/project/security_hotspots?id=apache_calcite&pullRequest=4907&issueStatuses=OPEN,CONFIRMED&sinceLeakPeriod=true)
 [95.5% Coverage on New Code](https://sonarcloud.io/component_measures?id=apache_calcite&pullRequest=4907&metric=new_coverage&view=list)
 [0.0% Duplication on New Code](https://sonarcloud.io/component_measures?id=apache_calcite&pullRequest=4907&metric=new_duplicated_lines_density&view=list)
[See analysis details on SonarQube Cloud](https://sonarcloud.io/dashboard?id=apache_calcite&pullRequest=4907)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@calcite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] [CALCITE-7486] Operators in MATCH_RECOGNIZE don't support `SqlLiterals` [calcite]
Posted by "sonarqubecloud[bot] (via GitHub)" <gi...@apache.org>.
sonarqubecloud[bot] commented on PR #4907:
URL: https://github.com/apache/calcite/pull/4907#issuecomment-4305438919
## [](https://sonarcloud.io/dashboard?id=apache_calcite&pullRequest=4907) **Quality Gate passed**
Issues
 [0 New issues](https://sonarcloud.io/project/issues?id=apache_calcite&pullRequest=4907&issueStatuses=OPEN,CONFIRMED&sinceLeakPeriod=true)
 [0 Accepted issues](https://sonarcloud.io/project/issues?id=apache_calcite&pullRequest=4907&issueStatuses=ACCEPTED)
Measures
 [0 Security Hotspots](https://sonarcloud.io/project/security_hotspots?id=apache_calcite&pullRequest=4907&issueStatuses=OPEN,CONFIRMED&sinceLeakPeriod=true)
 [95.5% Coverage on New Code](https://sonarcloud.io/component_measures?id=apache_calcite&pullRequest=4907&metric=new_coverage&view=list)
 [0.0% Duplication on New Code](https://sonarcloud.io/component_measures?id=apache_calcite&pullRequest=4907&metric=new_duplicated_lines_density&view=list)
[See analysis details on SonarQube Cloud](https://sonarcloud.io/dashboard?id=apache_calcite&pullRequest=4907)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@calcite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] [CALCITE-7486] Operators in MATCH_RECOGNIZE don't support `SqlLiterals` [calcite]
Posted by "snuyanzin (via GitHub)" <gi...@apache.org>.
snuyanzin merged PR #4907:
URL: https://github.com/apache/calcite/pull/4907
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@calcite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org