You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2022/04/01 03:31:00 UTC
[jira] [Resolved] (IMPALA-3921) the "where in" statement miss data when containing unicode characters
[ https://issues.apache.org/jira/browse/IMPALA-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Quanlong Huang resolved IMPALA-3921.
------------------------------------
Resolution: Cannot Reproduce
Closing this since I can't reproduce it now.
> the "where in" statement miss data when containing unicode characters
> ---------------------------------------------------------------------
>
> Key: IMPALA-3921
> URL: https://issues.apache.org/jira/browse/IMPALA-3921
> Project: IMPALA
> Issue Type: Bug
> Components: Backend
> Affects Versions: Impala 2.3.0, Kudu_Impala
> Reporter: rube.q
> Assignee: Quanlong Huang
> Priority: Minor
> Labels: correctness, downgraded
> Attachments: a.txt
>
>
> The same sql with different order of value in the "in statement" ,get different result.
> sql1:
> {code:sql}
> 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
> {code}
> the sql2:
> {code:sql}
> 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
> {code}
> The sql2 got the right result.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org