{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/22038","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/22038/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/22038/comments","events_url":"https://api.github.com/repos/apache/spark/issues/22038/events","html_url":"https://github.com/apache/spark/pull/22038","id":348781827,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA3MDUxMzQ5","number":22038,"title":"[SPARK-25056][SQL] Unify the InConversion and BinaryComparison behaviour when InConversion's list only contains one datatype","user":{"login":"wangyum","id":5399861,"node_id":"MDQ6VXNlcjUzOTk4NjE=","avatar_url":"https://avatars0.githubusercontent.com/u/5399861?v=4","gravatar_id":"","url":"https://api.github.com/users/wangyum","html_url":"https://github.com/wangyum","followers_url":"https://api.github.com/users/wangyum/followers","following_url":"https://api.github.com/users/wangyum/following{/other_user}","gists_url":"https://api.github.com/users/wangyum/gists{/gist_id}","starred_url":"https://api.github.com/users/wangyum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wangyum/subscriptions","organizations_url":"https://api.github.com/users/wangyum/orgs","repos_url":"https://api.github.com/users/wangyum/repos","events_url":"https://api.github.com/users/wangyum/events{/privacy}","received_events_url":"https://api.github.com/users/wangyum/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2018-08-08T15:39:32Z","updated_at":"2018-08-12T03:58:30Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/22038","html_url":"https://github.com/apache/spark/pull/22038","diff_url":"https://github.com/apache/spark/pull/22038.diff","patch_url":"https://github.com/apache/spark/pull/22038.patch"},"body":"## What changes were proposed in this pull request?\r\nbefore this PR:\r\n```scala\r\nscala> val df = spark.range(4).toDF().selectExpr(\"cast(id as decimal(9, 2)) as id\")\r\ndf: org.apache.spark.sql.DataFrame = [id: decimal(9,2)]\r\n\r\nscala> df.filter(\"id in('1', '3')\").show\r\n+---+\r\n| id|\r\n+---+\r\n+---+\r\n\r\nscala> df.filter(\"id = '1' or id ='3'\").show\r\n+----+\r\n|  id|\r\n+----+\r\n|1.00|\r\n|3.00|\r\n+----+\r\n```\r\nafter this PR:\r\n```scala\r\nscala> val df = spark.range(4).toDF().selectExpr(\"cast(id as decimal(9, 2)) as id\")\r\ndf: org.apache.spark.sql.DataFrame = [id: decimal(9,2)]\r\n\r\nscala> df.filter(\"id in('1', '3')\").show\r\n+----+\r\n|  id|\r\n+----+\r\n|1.00|\r\n|3.00|\r\n+----+\r\n\r\nscala> df.filter(\"id = '1' or id ='3'\").show\r\n+----+\r\n|  id|\r\n+----+\r\n|1.00|\r\n|3.00|\r\n+----+\r\n```\r\n\r\n## How was this patch tested?\r\n\r\nunit tests\r\n"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/412316954","html_url":"https://github.com/apache/spark/pull/22038#issuecomment-412316954","issue_url":"https://api.github.com/repos/apache/spark/issues/22038","id":412316954,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMjMxNjk1NA==","user":{"login":"SparkQA","id":8108735,"node_id":"MDQ6VXNlcjgxMDg3MzU=","avatar_url":"https://avatars1.githubusercontent.com/u/8108735?v=4","gravatar_id":"","url":"https://api.github.com/users/SparkQA","html_url":"https://github.com/SparkQA","followers_url":"https://api.github.com/users/SparkQA/followers","following_url":"https://api.github.com/users/SparkQA/following{/other_user}","gists_url":"https://api.github.com/users/SparkQA/gists{/gist_id}","starred_url":"https://api.github.com/users/SparkQA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SparkQA/subscriptions","organizations_url":"https://api.github.com/users/SparkQA/orgs","repos_url":"https://api.github.com/users/SparkQA/repos","events_url":"https://api.github.com/users/SparkQA/events{/privacy}","received_events_url":"https://api.github.com/users/SparkQA/received_events","type":"User","site_admin":false},"created_at":"2018-08-12T03:58:30Z","updated_at":"2018-08-12T03:58:30Z","author_association":"NONE","body":"**[Test build #94638 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/94638/testReport)** for PR 22038 at commit [`4fd2143`](https://github.com/apache/spark/commit/4fd21436f50130fb493d155aa3566268e67c5963)."}}
{"actor":{"display_login":"SparkQA"}}