[IMPALA-3921] the "where in" statement miss data when containing unicode characters

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: Impala 2.3.0, Kudu_Impala
• Component/s: Backend
• Labels: correctness downgraded
• Target Version: Product Backlog
• Assignee: Quanlong Huang
• Reporter: rube.q
• Created: 27/Jul/16 09:06
• Updated: 01/Apr/22 03:30
• Resolved: 01/Apr/22 03:30

Description

The same sql with different order of value in the "in statement" ,get different result.
sql1:

select count(1) from
(
select 
id, type 
from temp
where s_id=588 AND j_id=224 AND 
id in ('axiaoyuyuan05210816','chengjing08gk','lijhibj','dilys0706','gaobin13897925284','tb252434778','zexin5311520','刘修培201102','小小兔子1','曹刚剑芹','相濡以沫19890111','我爱大屎粑粑','邓存春1161577805','lichun踏天','zqy新人王者','小扎西呀','怪带劲滴','王冲山','笑影子越','孙立伟0','尹靖心2007','昌红映5078','胡丁幻丶','15838132962唯一','lily雨栀','zhubiao8889','心中丶无爱','最强地球人','梅子潇湘43087','陈嘉颖1984','中国我爱你赵亮','公元1989年','博博kissbobo','塑造de灵魂','欧春春11','灰鑫亚泉化工','谢勇123444','郎个里个郎嘿')
) a;

35
Fetched 1 row(s) in 0.98s

the sql2:

select count(1) from
(
select 
id, type
from temp 
where s_id=588 AND j_id=224 AND 
id in ('zhubiao8889','axiaoyuyuan05210816','chengjing08gk','lijhibj','dilys0706','gaobin13897925284','tb252434778','zexin5311520','刘修培201102','小小兔子1','曹刚剑芹','相濡以沫19890111','我爱大屎粑粑','邓存春1161577805','lichun踏天','zqy新人王者','小扎西呀','怪带劲滴','王冲山','笑影子越','孙立伟0','尹靖心2007','昌红映5078','胡丁幻丶','15838132962唯一','lily雨栀','心中丶无爱','最强地球人','梅子潇湘43087','陈嘉颖1984','中国我爱你赵亮','公元1989年','博博kissbobo','塑造de灵魂','欧春春11','灰鑫亚泉化工','谢勇123444','郎个里个郎嘿')
) a;

38
Fetched 1 row(s) in 0.98s

The sql2 got the right result.