{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8457","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8457/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8457/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8457/events","html_url":"https://github.com/orientechnologies/orientdb/issues/8457","id":348969070,"node_id":"MDU6SXNzdWUzNDg5NjkwNzA=","number":8457,"title":"Back quote behavior is different between 2.2.x and 3.0.x","user":{"login":"lightjiao","id":17800397,"node_id":"MDQ6VXNlcjE3ODAwMzk3","avatar_url":"https://avatars1.githubusercontent.com/u/17800397?v=4","gravatar_id":"","url":"https://api.github.com/users/lightjiao","html_url":"https://github.com/lightjiao","followers_url":"https://api.github.com/users/lightjiao/followers","following_url":"https://api.github.com/users/lightjiao/following{/other_user}","gists_url":"https://api.github.com/users/lightjiao/gists{/gist_id}","starred_url":"https://api.github.com/users/lightjiao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lightjiao/subscriptions","organizations_url":"https://api.github.com/users/lightjiao/orgs","repos_url":"https://api.github.com/users/lightjiao/repos","events_url":"https://api.github.com/users/lightjiao/events{/privacy}","received_events_url":"https://api.github.com/users/lightjiao/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-08-09T03:58:38Z","updated_at":"2018-09-25T06:45:57Z","closed_at":"2018-09-25T06:45:57Z","author_association":"NONE","body":"### OrientDB Version: 3.0.4\r\n### Java Version: 1.8\r\n### OS: centos 6.8\r\n\r\n## Expected behavior  \r\nback quote character don't return in the result schema\r\n\r\n## Actual behavior  \r\nresult schema have back quote character\r\n\r\n## Steps to reproduce  \r\nI have 3 sql need to execute\r\n```sql\r\nsqlA: select `name` from v_instance_app limit 1\r\n\r\nexecute result:\r\n{\r\n    \"result\": [\r\n        {\r\n            \"`name`\": \"emm-nginx\"\r\n        }\r\n    ]\r\n}\r\n```\r\n\r\n\r\n```\r\nsqlB: select `cluster` from v_instance_app limit 1\r\n\r\nexecute result:\r\n{\r\n    \"result\": [\r\n        {\r\n            \"`cluster`\": null\r\n        }\r\n    ]\r\n}\r\n```\r\n\r\n\r\n```\r\nsqlC: select cluster from v_instance_app limit 1\r\n\r\nget a exception\r\n{\r\n  \"errors\": [\r\n    {\r\n      \"reason\": 400,\r\n      \"code\": 400,\r\n      \"content\": \"Error parsing query:\\u000aselect cluster from v_instance_app limit 1\\u000a     ^\\u000aEncountered \\\" <SELECT> \\\"select \\\"\\\" at line 1, column 1.\\u000aWas expecting one of:\\u000a    <LET> ...\\u000a    <EXPLAIN> ...\\u000a    \\u000d\\u000a\\u0009DB name=\\\"cmdb_org_1028\\\"\\u000d\\u000a\\u0009Error Code=\\\"1\\\"\"\r\n    }\r\n  ]\r\n}\r\n```\r\n\r\nMy question is:\r\n- I use back quote in 2.2.x everywhere, should I trim the back quote?\r\n- how can I get `cluster` schema with sql?"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/424226054","html_url":"https://github.com/orientechnologies/orientdb/issues/8457#issuecomment-424226054","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8457","id":424226054,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNDIyNjA1NA==","user":{"login":"luigidellaquila","id":459289,"node_id":"MDQ6VXNlcjQ1OTI4OQ==","avatar_url":"https://avatars0.githubusercontent.com/u/459289?v=4","gravatar_id":"","url":"https://api.github.com/users/luigidellaquila","html_url":"https://github.com/luigidellaquila","followers_url":"https://api.github.com/users/luigidellaquila/followers","following_url":"https://api.github.com/users/luigidellaquila/following{/other_user}","gists_url":"https://api.github.com/users/luigidellaquila/gists{/gist_id}","starred_url":"https://api.github.com/users/luigidellaquila/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luigidellaquila/subscriptions","organizations_url":"https://api.github.com/users/luigidellaquila/orgs","repos_url":"https://api.github.com/users/luigidellaquila/repos","events_url":"https://api.github.com/users/luigidellaquila/events{/privacy}","received_events_url":"https://api.github.com/users/luigidellaquila/received_events","type":"User","site_admin":false},"created_at":"2018-09-25T06:45:57Z","updated_at":"2018-09-25T06:45:57Z","author_association":"MEMBER","body":"Hi @lightjiao \r\n\r\nI tested it on latest snapshot and it seems to be fixed already.\r\nAn upgrade should solve the problem\r\n\r\nThanks\r\n\r\nLuigi"}}
{"actor":{"display_login":"luigidellaquila"}}