[IMPALA-8054] Implicit cast fails with {const INT} BETWEEN FLOAT and INT

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Done
• Affects Version/s: Impala 3.2.0
• Fix Version/s: Impala 4.3.0
• Component/s: Frontend
• Assignee: Peter Rozsa
• Reporter: Greg Rahn
• Created: 08/Jan/19 00:35
• Updated: 28/May/23 13:55
• Resolved: 22/Mar/23 07:26

Description

In the following query the literal number 10 needs to be compared to two different types: INT and FLOAT, but Impala fails to make the implicit cast for the FLOAT.

The predicates should be

predicates: (cast(10 as float) >= col4) AND (10 <= col3)

Test cases:

sql> describe tab4
+------+--------+---------+
| name | type   | comment |
+------+--------+---------+
| pk   | int    |         |
| col0 | int    |         |
| col1 | float  |         |
| col2 | string |         |
| col3 | int    |         |
| col4 | float  |         |
| col5 | string |         |
+------+--------+---------+

sql> SELECT col0 FROM tab4 WHERE 10 BETWEEN col4 AND col3;
ERROR: IllegalStateException: child 0 type: FLOAT child 1 type: DOUBLE

sql> SELECT * FROM tab4 WHERE NULL NOT BETWEEN col3 AND col1;
ERROR: IllegalStateException: child 0 type: INT child 1 type: DOUBLE

sql> SELECT * FROM tab4 WHERE NULL BETWEEN CAST ( NULL AS INTEGER ) AND col4
ERROR: IllegalStateException: child 0 type: DOUBLE child 1 type: INT

Issue Links

• is related to: IMPALA-11530 SELECT statement fails with IllegalStateException when WHERE clause contains equals predicates with float columns and scientific numeric expressions