[HIVE-23269] Unsafe comparing bigints and strings

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Zhihua Deng
• Reporter: Zhihua Deng
• Created: 22/Apr/20 12:09
• Updated: 17/Nov/22 08:51
• Resolved: 12/Jun/20 08:45

Description

Comparing bigints and varchars or chars may result to wrong result, for example:

CREATE TABLE test_a (appid1 varchar(256), appid2 char(20));
INSERT INTO test_a VALUES ('2882303761517473127', '2882303761517473127'), ('2882303761517473276','2882303761517473276');

SET hive.strict.checks.type.safety=false;
SELECT appid1 FROM test_a WHERE appid1 = 2882303761517473127;
SELECT appid2 FROM test_a WHERE appid2 = 2882303761517473127;​

Both queries will output the row: ('2882303761517473276','2882303761517473276')

Issue Links

• links to: GitHub Pull Request #992