[jira] [Commented] (HIVE-12511) IN clause performs differently then = clause

["Jimmy Xiang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-12511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15025579#comment-15025579 ] 

Jimmy Xiang commented on HIVE-12511:
------------------------------------

I think we should fix GenericUDFIn to use common type for comparison instead of generic common type. In this case, for common type of int and string, we should use int instead of string.

> IN clause performs differently then = clause
> --------------------------------------------
>
>                 Key: HIVE-12511
>                 URL: https://issues.apache.org/jira/browse/HIVE-12511
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Jimmy Xiang
>            Assignee: Jimmy Xiang
>
> Similar to HIVE-11973, IN clause performs differently then = clause for "int" type with string values.
> For example,
> {noformat}
> SELECT * FROM inttest WHERE iValue IN ('01');
> {noformat}
> will not return any rows with int iValue = 1.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)