{"action":"created","issue":{"url":"https://api.github.com/repos/greenlion/PHP-SQL-Parser/issues/177","labels_url":"https://api.github.com/repos/greenlion/PHP-SQL-Parser/issues/177/labels{/name}","comments_url":"https://api.github.com/repos/greenlion/PHP-SQL-Parser/issues/177/comments","events_url":"https://api.github.com/repos/greenlion/PHP-SQL-Parser/issues/177/events","html_url":"https://github.com/greenlion/PHP-SQL-Parser/issues/177","id":89120683,"number":177,"title":"Position for CLAUSES","user":{"login":"witchi","id":5766508,"avatar_url":"https://avatars.githubusercontent.com/u/5766508?v=3","gravatar_id":"","url":"https://api.github.com/users/witchi","html_url":"https://github.com/witchi","followers_url":"https://api.github.com/users/witchi/followers","following_url":"https://api.github.com/users/witchi/following{/other_user}","gists_url":"https://api.github.com/users/witchi/gists{/gist_id}","starred_url":"https://api.github.com/users/witchi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/witchi/subscriptions","organizations_url":"https://api.github.com/users/witchi/orgs","repos_url":"https://api.github.com/users/witchi/repos","events_url":"https://api.github.com/users/witchi/events{/privacy}","received_events_url":"https://api.github.com/users/witchi/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/greenlion/PHP-SQL-Parser/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/greenlion/PHP-SQL-Parser/labels/imported","name":"imported","color":"FFFFFF"},{"url":"https://api.github.com/repos/greenlion/PHP-SQL-Parser/labels/Priority-Medium","name":"Priority-Medium","color":"FFFFFF"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-06-17T20:40:55Z","updated_at":"2015-06-17T20:41:09Z","closed_at":null,"body":"_From [abi...@owasp.org](https://code.google.com/u/100796709490792794235/) on September 25, 2014 23:05:32_\n\nWhat steps will reproduce the problem? 1. Parse any SQL query\r\n2. Clauses that appear as KEYs in the array are not treated as NODES.\r\nThey neither have positions nor anything else. What is the expected output? What do you see instead? I'm trying to mark all tokens in another string that simplifies the query, but major CLAUSES like SELECT and WHERE don't support position or other information. They should be treated like other nodes. What version of the product are you using? On what operating system? OS X Yosemite php-sql-parser-20140108 Please provide any additional information below.\n\n_Original issue: http://code.google.com/p/php-sql-parser/issues/detail?id=151_"},"comment":{"url":"https://api.github.com/repos/greenlion/PHP-SQL-Parser/issues/comments/112943625","html_url":"https://github.com/greenlion/PHP-SQL-Parser/issues/177#issuecomment-112943625","issue_url":"https://api.github.com/repos/greenlion/PHP-SQL-Parser/issues/177","id":112943625,"user":{"login":"witchi","id":5766508,"avatar_url":"https://avatars.githubusercontent.com/u/5766508?v=3","gravatar_id":"","url":"https://api.github.com/users/witchi","html_url":"https://github.com/witchi","followers_url":"https://api.github.com/users/witchi/followers","following_url":"https://api.github.com/users/witchi/following{/other_user}","gists_url":"https://api.github.com/users/witchi/gists{/gist_id}","starred_url":"https://api.github.com/users/witchi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/witchi/subscriptions","organizations_url":"https://api.github.com/users/witchi/orgs","repos_url":"https://api.github.com/users/witchi/repos","events_url":"https://api.github.com/users/witchi/events{/privacy}","received_events_url":"https://api.github.com/users/witchi/received_events","type":"User","site_admin":false},"created_at":"2015-06-17T20:41:09Z","updated_at":"2015-06-17T20:41:09Z","body":"_From [pho...@gmx.de](https://code.google.com/u/109317404671582518013/) on September 26, 2014 10:58:00_\n\n2. must be strpos(strtoupper($statement), $index, $curPos)\r\n\r\nThe $index should always be in uppercases."}}