You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "terran2010 (Jira)" <ji...@apache.org> on 2026/05/09 06:56:00 UTC
[jira] [Created] (CALCITE-7512) Support array operators for PostgreSql
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)