terran2010 created CALCITE-7512:
-----------------------------------
Summary: Support array operators for PostgreSql
Key: CALCITE-7512
URL: https://issues.apache.org/jira/browse/CALCITE-7512
Project: Calcite
Issue Type: New Feature
Components: babel
Affects Versions: 1.41.0
Reporter: terran2010
When execute sql with babel：
{code:java}
SELECT ARRAY[1,2,3] @> ARRAY[1,2] {code}
now will run error：
{code:java}
Caused by: org.apache.calcite.sql.parser.babel.TokenMgrError: Lexical error at
line 1, column 21. Encountered: "@" (64), after : "" at
org.apache.calcite.sql.parser.babel.SqlBabelParserImplTokenManager.getNextToken(SqlBabelParserImplTokenManager.java:26853)
at
org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.jj_scan_token(SqlBabelParserImpl.java:41652)
at
org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.jj_3_414(SqlBabelParserImpl.java:31680)
at
org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.jj_2_414(SqlBabelParserImpl.java:14651)
at
org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.AddExpression2b(SqlBabelParserImpl.java:4917)
at
org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.Expression2(SqlBabelParserImpl.java:4956)
at
org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.Expression(SqlBabelParserImpl.java:4805)
at
org.apache.calcite.sql.parser.babel.SqlBabelParserImpl.SelectExpression(SqlBabelParserImpl.java:2816)
{code}
we can refer postgresql document about Position:
https://www.postgresql.org/docs/current/functions-array.html
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
