{"action":"created","issue":{"url":"https://api.github.com/repos/apache/phoenix/issues/81","labels_url":"https://api.github.com/repos/apache/phoenix/issues/81/labels{/name}","comments_url":"https://api.github.com/repos/apache/phoenix/issues/81/comments","events_url":"https://api.github.com/repos/apache/phoenix/issues/81/events","html_url":"https://github.com/apache/phoenix/pull/81","id":72065836,"number":81,"title":"PHOENIX-1938 Like operator should throw proper exception when it is used with data type other then Varcahr and Char","user":{"login":"AakashPradeep","id":6225845,"avatar_url":"https://avatars.githubusercontent.com/u/6225845?v=3","gravatar_id":"","url":"https://api.github.com/users/AakashPradeep","html_url":"https://github.com/AakashPradeep","followers_url":"https://api.github.com/users/AakashPradeep/followers","following_url":"https://api.github.com/users/AakashPradeep/following{/other_user}","gists_url":"https://api.github.com/users/AakashPradeep/gists{/gist_id}","starred_url":"https://api.github.com/users/AakashPradeep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AakashPradeep/subscriptions","organizations_url":"https://api.github.com/users/AakashPradeep/orgs","repos_url":"https://api.github.com/users/AakashPradeep/repos","events_url":"https://api.github.com/users/AakashPradeep/events{/privacy}","received_events_url":"https://api.github.com/users/AakashPradeep/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-04-30T05:19:20Z","updated_at":"2015-05-21T00:22:50Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/phoenix/pulls/81","html_url":"https://github.com/apache/phoenix/pull/81","diff_url":"https://github.com/apache/phoenix/pull/81.diff","patch_url":"https://github.com/apache/phoenix/pull/81.patch"},"body":"LIKE operator should be supported only for Varchar and Char and it should throw SQLException with SQLExceptionCode.TYPE_NOT_SUPPORTED_FOR_OPERATOR for any other data type. \r\n\r\n\r\nPostgres specification : http://www.postgresql.org/docs/8.3/static/functions-matching.html\r\nOracle specification: http://docs.oracle.com/cd/B12037_01/server.101/b10759/conditions016.htm\r\n\r\n@JamesRTaylor  @twdsilva  Can you please review this.\r\n"},"comment":{"url":"https://api.github.com/repos/apache/phoenix/issues/comments/104078110","html_url":"https://github.com/apache/phoenix/pull/81#issuecomment-104078110","issue_url":"https://api.github.com/repos/apache/phoenix/issues/81","id":104078110,"user":{"login":"JamesRTaylor","id":6176299,"avatar_url":"https://avatars.githubusercontent.com/u/6176299?v=3","gravatar_id":"","url":"https://api.github.com/users/JamesRTaylor","html_url":"https://github.com/JamesRTaylor","followers_url":"https://api.github.com/users/JamesRTaylor/followers","following_url":"https://api.github.com/users/JamesRTaylor/following{/other_user}","gists_url":"https://api.github.com/users/JamesRTaylor/gists{/gist_id}","starred_url":"https://api.github.com/users/JamesRTaylor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JamesRTaylor/subscriptions","organizations_url":"https://api.github.com/users/JamesRTaylor/orgs","repos_url":"https://api.github.com/users/JamesRTaylor/repos","events_url":"https://api.github.com/users/JamesRTaylor/events{/privacy}","received_events_url":"https://api.github.com/users/JamesRTaylor/received_events","type":"User","site_admin":false},"created_at":"2015-05-21T00:22:50Z","updated_at":"2015-05-21T00:22:50Z","body":"I'd make JSON castable to VARCHAR instead of coercible. That way you can do an explicit CAST, but it would not be auto-coerced."}}