[DRILL-4970] Wrong results when casting double to bigint or int

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.11.0
• Component/s: Execution - Data Types
• Labels: ready-to-commit
• Assignee: Vova Vysotskyi
• Reporter: Robert Hou
• Reviewer: Chun Chang
• Created: 27/Oct/16 00:50
• Updated: 31/Aug/17 20:47
• Resolved: 04/Jul/17 10:36

Description

This query returns the wrong result

0: jdbc:drill:zk=10.10.100.186:5181/drill/rho> select count(\*) from test_table where (int_id > -3025 and bigint_id <= -256) or (cast(double_id as bigint) >= -255 and double_id <= -5);
+---------+
| EXPR$0  |
+---------+
| 2769    |
+---------+

Without the cast, it returns the correct result:

0: jdbc:drill:zk=10.10.100.186:5181/drill/rho> select count(\*) from test_table where (int_id > -3025 and bigint_id <= -256) or (double_id >= -255 and double_id <= -5);
+---------+
| EXPR$0  |
+---------+
| 3020    |
+---------+

By itself, the result is also correct:

0: jdbc:drill:zk=10.10.100.186:5181/drill/rho> select count(\*) from test_table where (cast(double_id as bigint) >= -255 and double_id <= -5);
+---------+
| EXPR$0  |
+---------+
| 251     |
+---------+

Issue Links

• links to: GitHub Pull Request #863