{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/15977","repository_url":"https://api.github.com/repos/apache/spark","labels_url":"https://api.github.com/repos/apache/spark/issues/15977/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/15977/comments","events_url":"https://api.github.com/repos/apache/spark/issues/15977/events","html_url":"https://github.com/apache/spark/pull/15977","id":190961018,"number":15977,"title":"[SPARK-18436][SQL] isin causing SQL syntax error with JDBC","user":{"login":"jiangxb1987","id":4784782,"avatar_url":"https://avatars.githubusercontent.com/u/4784782?v=3","gravatar_id":"","url":"https://api.github.com/users/jiangxb1987","html_url":"https://github.com/jiangxb1987","followers_url":"https://api.github.com/users/jiangxb1987/followers","following_url":"https://api.github.com/users/jiangxb1987/following{/other_user}","gists_url":"https://api.github.com/users/jiangxb1987/gists{/gist_id}","starred_url":"https://api.github.com/users/jiangxb1987/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jiangxb1987/subscriptions","organizations_url":"https://api.github.com/users/jiangxb1987/orgs","repos_url":"https://api.github.com/users/jiangxb1987/repos","events_url":"https://api.github.com/users/jiangxb1987/events{/privacy}","received_events_url":"https://api.github.com/users/jiangxb1987/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-11-22T10:28:02Z","updated_at":"2016-11-24T07:27:33Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/15977","html_url":"https://github.com/apache/spark/pull/15977","diff_url":"https://github.com/apache/spark/pull/15977.diff","patch_url":"https://github.com/apache/spark/pull/15977.patch"},"body":"## What changes were proposed in this pull request?\r\n\r\nThe expression `in(empty seq)` is invalid in some data source. Since `in(empty seq)` is always false, we should generate `in(empty seq)` to false literal in optimizer.\r\nThe sql `SELECT * FROM t WHERE a IN ()` throws a `ParseException` which is consistent with Hive, don't need to change that behavior.\r\n\r\n## How was this patch tested?\r\nAdd new test case in `OptimizeInSuite`.\r\n"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/262707866","html_url":"https://github.com/apache/spark/pull/15977#issuecomment-262707866","issue_url":"https://api.github.com/repos/apache/spark/issues/15977","id":262707866,"user":{"login":"SparkQA","id":8108735,"avatar_url":"https://avatars.githubusercontent.com/u/8108735?v=3","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":"2016-11-24T07:27:33Z","updated_at":"2016-11-24T07:27:33Z","body":"**[Test build #69113 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/69113/consoleFull)** for PR 15977 at commit [`9bb1264`](https://github.com/apache/spark/commit/9bb1264f91af3bc855ae523a06526e830f6f85e0)."}}
{"actor":{"display_login":"SparkQA"}}