{"action":"opened","issue":{"url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/173","labels_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/173/labels{/name}","comments_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/173/comments","events_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/173/events","html_url":"https://github.com/JSQLParser/JSqlParser/issues/173","id":107539803,"number":173,"title":"Parse error on functions using the IN keyword","user":{"login":"Inphi","id":3516807,"avatar_url":"https://avatars.githubusercontent.com/u/3516807?v=3","gravatar_id":"","url":"https://api.github.com/users/Inphi","html_url":"https://github.com/Inphi","followers_url":"https://api.github.com/users/Inphi/followers","following_url":"https://api.github.com/users/Inphi/following{/other_user}","gists_url":"https://api.github.com/users/Inphi/gists{/gist_id}","starred_url":"https://api.github.com/users/Inphi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Inphi/subscriptions","organizations_url":"https://api.github.com/users/Inphi/orgs","repos_url":"https://api.github.com/users/Inphi/repos","events_url":"https://api.github.com/users/Inphi/events{/privacy}","received_events_url":"https://api.github.com/users/Inphi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-09-21T15:40:29Z","updated_at":"2015-09-21T15:40:29Z","closed_at":null,"body":"I'm getting a ParseException when parsing:\r\n\"SELECT position(\"-\" IN row_key) FROM hbase\".\r\n\r\nAfter trying out some more queries, i've deduced that JSqlParser isn't handling expressions (SimpleExpressions) containing the \"IN\" token. The grammar, JSqlParserCC.jjt, doesn't accept IN as a lookahead, but only accepts '&' and '|'. This may explain why the query doesn't work."}}