[FLINK-19659] Array type supports equals and not_equals operator when element types are different but castable

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.11.0
• Fix Version/s: 1.20.0
• Component/s: Table SQL / API
• Labels: auto-deprioritized-major auto-unassigned pull-request-available
• Assignee: Unassigned
• Reporter: hailong wang
• Created: 15/Oct/20 14:17
• Updated: 11/Mar/24 12:44

Description

Currently, Array type supports `equals` and `not_equals` when element types are the same or can not be cased. For example,

Array[1] <> Array[1] -> false

Array[1] <> Array[cast(1 as bigint)] -> false

But for the element types which are castable, it will throw error,

org.apache.flink.table.planner.codegen.CodeGenException: Unsupported cast from 'ARRAY<INT NOT NULL> NOT NULL' to 'ARRAY<BIGINT NOT NULL> NOT NULL'.org.apache.flink.table.planner.codegen.CodeGenException: Unsupported cast from 'ARRAY<INT NOT NULL> NOT NULL' to 'ARRAY<BIGINT NOT NULL> NOT NULL'. at org.apache.flink.table.planner.codegen.calls.ScalarOperatorGens$.generateCast(ScalarOperatorGens.scala:1295) at org.apache.flink.table.planner.codegen.ExprCodeGenerator.generateCallExpression(ExprCodeGenerator.scala:703) at org.apache.flink.table.planner.codegen.ExprCodeGenerator.visitCall(ExprCodeGenerator.scala:498) at org.apache.flink.table.planner.codegen.ExprCodeGenerator.visitCall(ExprCodeGenerator.scala:55) at org.apache.calcite.rex.RexCall.accept(RexCall.java:288)

But the result should be false or true,  for example,

/Array[1] <> Array[cast(1 as bigint)] -> false

 

BTW, Map and MultiSet type are same as this, If it did, I am pleasure to open other issues to track those.

Issue Links

• relates to: FLINK-17321 Support for casting collection types.
• links to: GitHub Pull Request #14328