{"action":"created","issue":{"url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/182","labels_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/182/labels{/name}","comments_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/182/comments","events_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/182/events","html_url":"https://github.com/JSQLParser/JSqlParser/issues/182","id":111147306,"number":182,"title":"Can ExpressionDeParser used within visit(CreateView createView)?","user":{"login":"sisao","id":514609,"avatar_url":"https://avatars.githubusercontent.com/u/514609?v=3","gravatar_id":"","url":"https://api.github.com/users/sisao","html_url":"https://github.com/sisao","followers_url":"https://api.github.com/users/sisao/followers","following_url":"https://api.github.com/users/sisao/following{/other_user}","gists_url":"https://api.github.com/users/sisao/gists{/gist_id}","starred_url":"https://api.github.com/users/sisao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sisao/subscriptions","organizations_url":"https://api.github.com/users/sisao/orgs","repos_url":"https://api.github.com/users/sisao/repos","events_url":"https://api.github.com/users/sisao/events{/privacy}","received_events_url":"https://api.github.com/users/sisao/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-10-13T10:00:20Z","updated_at":"2015-10-21T06:03:17Z","closed_at":"2015-10-21T06:03:17Z","body":"Hi is it possible to use the ExpressionDeParser not just with SelectDeParser?\r\nOr did't I just find the docs?\r\n\r\nRegards,\r\nStefan\r\n\r\n```java\r\n...\r\nstatement.accept(new StatementVisitor() {\r\n\r\n    @Override\r\n    public void visit(Select select) {\r\n    \tSelectDeParser deparser = new SelectDeParser(expressionDeParser, buffer);\r\n    \texpressionDeParser.setSelectVisitor(deparser);\r\n    \texpressionDeParser.setBuffer(buffer);\r\n    \tselect.getSelectBody().accept(deparser);\r\n    \tSystem.out.println(\"select\");\r\n    }\r\n                            \r\n    @Override\r\n    public void visit(CreateView createView) {\r\n      //is it possible to use a ExpressionDeParser in here?\r\n    }\r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/comments/149791847","html_url":"https://github.com/JSQLParser/JSqlParser/issues/182#issuecomment-149791847","issue_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/182","id":149791847,"user":{"login":"wumpz","id":1569337,"avatar_url":"https://avatars.githubusercontent.com/u/1569337?v=3","gravatar_id":"","url":"https://api.github.com/users/wumpz","html_url":"https://github.com/wumpz","followers_url":"https://api.github.com/users/wumpz/followers","following_url":"https://api.github.com/users/wumpz/following{/other_user}","gists_url":"https://api.github.com/users/wumpz/gists{/gist_id}","starred_url":"https://api.github.com/users/wumpz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wumpz/subscriptions","organizations_url":"https://api.github.com/users/wumpz/orgs","repos_url":"https://api.github.com/users/wumpz/repos","events_url":"https://api.github.com/users/wumpz/events{/privacy}","received_events_url":"https://api.github.com/users/wumpz/received_events","type":"User","site_admin":false},"created_at":"2015-10-21T06:03:17Z","updated_at":"2015-10-21T06:03:17Z","body":"I modified the CreateViewDeparser to handle such problems. I included a test **CreateViewDeParserTest** where you could look how to do it. Actually there are two possibilities. The first to tackle the problem is the way you took. The second is a very new approach to JSqlParser. For some parts of the parsed sql there are AST tree nodes generated with string positions. Fortunatly column is one of these. One could roll through all columns and correct the original sql string.\r\n\r\nHope that helps and thx for using JSqlParser."}}