[ https://issues.apache.org/jira/browse/IMPALA-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong reassigned IMPALA-3921: ------------------------------------- Assignee: Quanlong Huang > 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.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org