{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/9036","labels_url":"https://api.github.com/repos/apache/spark/issues/9036/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/9036/comments","events_url":"https://api.github.com/repos/apache/spark/issues/9036/events","html_url":"https://github.com/apache/spark/pull/9036","id":110545265,"number":9036,"title":"[SPARK-8654] [SQL] Analysis exception when using NULL IN (...) : invalid cast","user":{"login":"dilipbiswal","id":14225158,"avatar_url":"https://avatars.githubusercontent.com/u/14225158?v=3","gravatar_id":"","url":"https://api.github.com/users/dilipbiswal","html_url":"https://github.com/dilipbiswal","followers_url":"https://api.github.com/users/dilipbiswal/followers","following_url":"https://api.github.com/users/dilipbiswal/following{/other_user}","gists_url":"https://api.github.com/users/dilipbiswal/gists{/gist_id}","starred_url":"https://api.github.com/users/dilipbiswal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dilipbiswal/subscriptions","organizations_url":"https://api.github.com/users/dilipbiswal/orgs","repos_url":"https://api.github.com/users/dilipbiswal/repos","events_url":"https://api.github.com/users/dilipbiswal/events{/privacy}","received_events_url":"https://api.github.com/users/dilipbiswal/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-10-08T21:30:56Z","updated_at":"2015-10-08T22:12:37Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/9036","html_url":"https://github.com/apache/spark/pull/9036","diff_url":"https://github.com/apache/spark/pull/9036.diff","patch_url":"https://github.com/apache/spark/pull/9036.patch"},"body":"In the analysis phase , while processing the rules for IN predicate, we\r\ncompare the in-list types to the lhs expression type and generate\r\ncast operation if necessary. In the case of NULL [NOT] IN expr1 , we end up\r\ngenerating cast between in list types to NULL like cast (1 as NULL) which\r\nis not a valid cast.\r\n\r\nThe fix is to find a common type between LHS and RHS expressions and cast\r\nall the expression to the common type. "},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/146701214","html_url":"https://github.com/apache/spark/pull/9036#issuecomment-146701214","issue_url":"https://api.github.com/repos/apache/spark/issues/9036","id":146701214,"user":{"login":"AmplabJenkins","id":4031291,"avatar_url":"https://avatars.githubusercontent.com/u/4031291?v=3","gravatar_id":"","url":"https://api.github.com/users/AmplabJenkins","html_url":"https://github.com/AmplabJenkins","followers_url":"https://api.github.com/users/AmplabJenkins/followers","following_url":"https://api.github.com/users/AmplabJenkins/following{/other_user}","gists_url":"https://api.github.com/users/AmplabJenkins/gists{/gist_id}","starred_url":"https://api.github.com/users/AmplabJenkins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AmplabJenkins/subscriptions","organizations_url":"https://api.github.com/users/AmplabJenkins/orgs","repos_url":"https://api.github.com/users/AmplabJenkins/repos","events_url":"https://api.github.com/users/AmplabJenkins/events{/privacy}","received_events_url":"https://api.github.com/users/AmplabJenkins/received_events","type":"User","site_admin":false},"created_at":"2015-10-08T22:12:37Z","updated_at":"2015-10-08T22:12:37Z","body":"Merged build finished. Test FAILed."}}