[CALCITE-1386] ITEM operator ignores the value type of the collection, assigns to Object variable

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.10.0
• Component/s: core
• Assignee: Jungtaek Lim
• Reporter: Jungtaek Lim
• Created: 27/Sep/16 05:08
• Updated: 27/Feb/24 22:23
• Resolved: 29/Sep/16 21:08

Description

Suppose we're defining the following table:

.field("ID", SqlTypeName.INTEGER)
.field("MAPFIELD",
        typeFactory.createMapType(
                typeFactory.createSqlType(SqlTypeName.VARCHAR),
                typeFactory.createTypeWithNullability(
                        typeFactory.createSqlType(SqlTypeName.INTEGER), true)))
.field("NESTEDMAPFIELD",
        typeFactory.createMapType(
                typeFactory.createSqlType(SqlTypeName.VARCHAR),
                typeFactory.createTypeWithNullability(
                        typeFactory.createMapType(
                                typeFactory.createSqlType(SqlTypeName.VARCHAR),
                                typeFactory.createTypeWithNullability(
                                        typeFactory.createSqlType(SqlTypeName.INTEGER), true))
                        , true)))
.field("ARRAYFIELD", typeFactory.createArrayType(
        typeFactory.createTypeWithNullability(
                typeFactory.createSqlType(SqlTypeName.INTEGER), true), -1L))

and query like this:

SELECT * FROM <TBL> WHERE MAPFIELD['a'] = 1

When we evaluate that query, JaninoRexCompiler throws an Exception saying there's no SqlFunctions.eq(Object, int).

I took a breakpoint on BinaryImplementor.implement() to see variables just before compiler finds SqlFunctions.eq().
The type of expression is Object which is not generic, but seems like matching RexCall operand have value type information.
(I mean type mismatch occurs.)

Issue Links

• contains: CALCITE-1387 CAST(ITEM() as INTEGER) throws RuntimeException in Runtime when return value of ITEM() is null