[IGNITE-18805] Sql. TPC-H. ClassCastExceptions in predicate expressions

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Invalid
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Iurii Gerzhedovich
• Reporter: Maksim Zhuravkov
• Created: 14/Feb/23 17:05
• Updated: 04/Sep/24 16:10
• Resolved: 24/Feb/23 09:58

Description

TPC-H queries 4, 16, 19, 21 fail with similar errors caused by class cast exceptions in generaned predicate expressions:

// Error
// org.apache.ignite.internal.sql.engine.exec.exp.ExpressionFactoryImpl$PredicateImpl.test(ExpressionFactoryImpl.java:610)

    // q16: Caused by: java.lang.ClassCastException: class java.lang.String cannot be cast to class java.lang.Boolean (java.lang.String and java.lang.Boolean are in module java.base of loader 'bootstrap')

    // q21 q4 Caused by: java.lang.ClassCastException: class java.time.LocalDateTime cannot be cast to class java.lang.Long (java.time.LocalDateTime and java.lang.Long are in module java.base of loader 'bootstrap')

    // q19: Caused by: java.lang.ClassCastException: class java.math.BigDecimal cannot be cast to class java.lang.Long (java.math.BigDecimal and java.lang.Long are in module java.base of loader 'bootstrap')

Issue Links

• is fixed by: IGNITE-18479 Sort out and merge Calcite tickets to Ignite 3.0 (step 9)