[
https://issues.apache.org/jira/browse/CALCITE-5093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17523113#comment-17523113
]
Stamatis Zampetakis commented on CALCITE-5093:
----------------------------------------------
Hey [~omidbb], first of all when you create a bug report it helps to include
the error/stacktrace that you get by running the query.
Calcite follows closely the SQL standard and afterwards with various extensions
tries to cover particularities of other DBMS. Before talking about
contributions it should be clear what the SQL standard says with respect to
this query and what other DMBS do (not only Postgres).
Is this a valid query from the SQL standard perspective?
Which other DBMS can handle this query?
> Cannot validate Array type
> --------------------------
>
> Key: CALCITE-5093
> URL: https://issues.apache.org/jira/browse/CALCITE-5093
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.30.0
> Reporter: Omid B
> Priority: Major
>
> I'm trying to validate a simple query against a schema:
>
> {code:java}
> // SQL Query
> select id from product
> where 'item0' = any(attributes) {code}
> Running the validator and digging deep in the place that throws an exception
> I get to here:
> [https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/type/SameOperandTypeChecker.java#L100]
>
> The inputs are two types:
> {code:java}
> RecordType(CHAR(5) ROW_VALUE)
> RecordType(VARCHAR ARRAY ROW_VALUE){code}
> As you can see, these types must be compatible but Calcite don't match them
> right.
>
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
