{"action":"opened","issue":{"url":"https://api.github.com/repos/pmd/pmd/issues/1454","repository_url":"https://api.github.com/repos/pmd/pmd","labels_url":"https://api.github.com/repos/pmd/pmd/issues/1454/labels{/name}","comments_url":"https://api.github.com/repos/pmd/pmd/issues/1454/comments","events_url":"https://api.github.com/repos/pmd/pmd/issues/1454/events","html_url":"https://github.com/pmd/pmd/issues/1454","id":379578664,"node_id":"MDU6SXNzdWUzNzk1Nzg2NjQ=","number":1454,"title":"[plsql] ParseException for IF/CASE statement with >=, <=, !=","user":{"login":"ekkirala","id":44954455,"node_id":"MDQ6VXNlcjQ0OTU0NDU1","avatar_url":"https://avatars2.githubusercontent.com/u/44954455?v=4","gravatar_id":"","url":"https://api.github.com/users/ekkirala","html_url":"https://github.com/ekkirala","followers_url":"https://api.github.com/users/ekkirala/followers","following_url":"https://api.github.com/users/ekkirala/following{/other_user}","gists_url":"https://api.github.com/users/ekkirala/gists{/gist_id}","starred_url":"https://api.github.com/users/ekkirala/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ekkirala/subscriptions","organizations_url":"https://api.github.com/users/ekkirala/orgs","repos_url":"https://api.github.com/users/ekkirala/repos","events_url":"https://api.github.com/users/ekkirala/events{/privacy}","received_events_url":"https://api.github.com/users/ekkirala/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-11T23:58:16Z","updated_at":"2018-11-11T23:58:16Z","closed_at":null,"author_association":"NONE","body":"<!-- Please, prefix the report title with the language it applies to within brackets, such as [java] or [apex].\r\nIf not specific to a language, you can use [core]. -->\r\n[plsql]\r\n**Affects PMD Version:** \r\nPMD 6.1.9\r\n**Rule:**\r\nNA\r\n**Description:**\r\nThrows ParseException for Valid conditions for IF/CASE statements.\r\n**Code Sample demonstrating the issue:**\r\n\r\ncreate or replace procedure PMD_TEST_CASE( a IN NUMBER) AS\r\n  \r\n\r\nbegin\r\n\r\n\r\n    CASE WHEN a >= 100 then -- Test the same with <=,!=,<> all cases fail both with IF and CASe statements\r\n      dbms_output.put_line('Number is greater than equal to 100');\r\n    ELSE\r\n      dbms_output.put_line('Number is less than 100');  \r\n    END CASE;\r\n\r\nexception\r\n  when others then \r\n    dbms_output.put_line('ERROR: ' || sqlerrm);    \r\n\r\nend PMD_TEST_CASE;\r\n```\r\n\r\n```\r\n\r\n**Running PMD through:** *[CLI | Ant | Maven | Gradle | Designer | Other]*\r\nCLI\r\n<!-- If relevant, also include your JDK and OS information, e.g. for ClassNotFoundException, LinkageError, reflection failures, etc. -->\r\nJDK 10.0.1, MacIS."}}
{"actor":{"display_login":"ekkirala"}}