{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4752","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4752/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4752/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4752/events","html_url":"https://github.com/orientechnologies/orientdb/issues/4752","id":99603419,"number":4752,"title":"query \"select @rid as @rid, name from ouser\" returns error","user":{"login":"Ivanov-Yuriy","id":7984378,"avatar_url":"https://avatars.githubusercontent.com/u/7984378?v=3","gravatar_id":"","url":"https://api.github.com/users/Ivanov-Yuriy","html_url":"https://github.com/Ivanov-Yuriy","followers_url":"https://api.github.com/users/Ivanov-Yuriy/followers","following_url":"https://api.github.com/users/Ivanov-Yuriy/following{/other_user}","gists_url":"https://api.github.com/users/Ivanov-Yuriy/gists{/gist_id}","starred_url":"https://api.github.com/users/Ivanov-Yuriy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ivanov-Yuriy/subscriptions","organizations_url":"https://api.github.com/users/Ivanov-Yuriy/orgs","repos_url":"https://api.github.com/users/Ivanov-Yuriy/repos","events_url":"https://api.github.com/users/Ivanov-Yuriy/events{/privacy}","received_events_url":"https://api.github.com/users/Ivanov-Yuriy/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/bug","name":"bug","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"luigidellaquila","id":459289,"avatar_url":"https://avatars.githubusercontent.com/u/459289?v=3","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},"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/64","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.1.x%20(next%20hotfix)","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/64/labels","id":1282180,"number":64,"title":"2.1.x (next hotfix)","description":"","creator":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"open_issues":131,"closed_issues":10,"state":"open","created_at":"2015-08-31T15:18:49Z","updated_at":"2015-10-20T14:21:28Z","due_on":null,"closed_at":null},"comments":19,"created_at":"2015-08-07T08:16:45Z","updated_at":"2015-10-20T14:25:40Z","closed_at":null,"body":"#### I use an override of field because i want receive the same result for different queries.\r\n\r\n##### when i use query \"select from ouser\", I receive RIDs in field \"**@RID**\"\r\n\r\norientdb {db=test}> select from ouser\r\n----+----+------+------+-------------------------------------------------------------------------+------+-----\r\n\\#   | @RID| @ CLASS|name  |password                                                                 |status|roles\r\n----+----+------+------+-------------------------------------------------------------------------+------+-----\r\n0   |#5:0|OUser |admin |{SHA-256}8C6976E5B5410.....415BDE90|ACTIVE|[1]\r\n1   |#5:1|OUser |reader|{SHA-256}3D0941964AA3EBDCB00CCE....D5AEC7F31090A0FB30|ACTIVE|[1]\r\n2   |#5:2|OUser |writer|{SHA-256}B93006774CBDD4B299389A03...11A909FBA5|ACTIVE|[1]\r\n----+----+------+------+-------------------------------------------------------------------------+------+-----\r\n3 item(s) found. Query executed in 0.008 sec(s).\r\n\r\n##### but if I use query with projections, I receive RIDs in field \"**RID**\"\r\n\r\norientdb {db=test}> select @rid, name from ouser\r\n----+------+----+------\r\n\\#   | @ CLASS| **rid** |name\r\n----+------+----+------\r\n0   |null  |#5:0|admin\r\n1   |null  |#5:1|reader\r\n2   |null  |#5:2|writer\r\n----+------+----+------\r\n3 item(s) found. Query executed in 0.006 sec(s).\r\n\r\n##### so I use override of the field to get a similar result\r\n\r\norientdb {db=test}> select @rid as @rid, name from ouser\r\n----+----+------+------\r\n\\#   | @RID| @ CLASS|name\r\n----+----+------+------\r\n0   |#5:0|OUser |admin\r\n1   |#5:1|OUser |reader\r\n2   |#5:2|OUser |writer\r\n----+----+------+------\r\n3 item(s) found. Query executed in 0.005 sec(s).\r\n\r\n##### the top code worked in version 2.0.13 but in version 2.1.0 the query \"select @rid as @rid, name from ouser\" returns error\r\n\r\norientdb {db=test}> select @rid as @rid, name from ouser\r\n\r\nError: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #0: Encountered \" <RECORD_ATTRIBUTE> \"@\r\nrid \"\" at line 1, column 16.\r\nWas expecting one of:\r\n    \\<TO\\> ...\r\n    \\<VALUES\\> ...\r\n    \\<SET\\> ...\r\n    \\<ADD\\> ...\r\n    \\<PUT\\> ...\r\n    \\<MERGE\\> ...\r\n    \\<CONTENT\\> ...\r\n    \\<REMOVE\\> ...\r\n    \\<ORDER\\> ...\r\n    \\<GROUP\\> ...\r\n    \\<OFFSET\\> ...\r\n    \\<RECORD\\> ...\r\n    \\<LUCENE\\> ...\r\n    \\<NEAR\\> ...\r\n    \\<WITHIN\\> ...   \r\n    \\<IN\\> ...\r\n    \\<KEY\\> ...\r\n    \\<IDENTIFIER\\> ...\r\n    \\<IDENTIFIER\\> ...\r\n    \\<IN\\> ...\r\n    \\<SET\\> ...\r\n    \\<PUT\\> ...\r\n    \\<ADD\\> ...\r\n    \\<REMOVE\\> ...\r\n    \\<MERGE\\> ...\r\n    \\<CONTENT\\> ...\r\n    \\<ORDER\\> ...\r\n    \\<KEY\\> ...\r\n    \\<OFFSET\\> ...\r\n    \\<GROUP\\> ...\r\n    \\<VALUES\\> ...\r\n    \\<RECORD\\> ...\r\n    \\<TO\\> ...\r\n    \\<LUCENE\\> ...\r\n    \\<NEAR\\> ...\r\n    \\<WITHIN\\> ...\r\n    \"`\" ...\r\n    \"`\" ...\r\n    \"`\" ...\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/149583398","html_url":"https://github.com/orientechnologies/orientdb/issues/4752#issuecomment-149583398","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4752","id":149583398,"user":{"login":"a-unite","id":2130349,"avatar_url":"https://avatars.githubusercontent.com/u/2130349?v=3","gravatar_id":"","url":"https://api.github.com/users/a-unite","html_url":"https://github.com/a-unite","followers_url":"https://api.github.com/users/a-unite/followers","following_url":"https://api.github.com/users/a-unite/following{/other_user}","gists_url":"https://api.github.com/users/a-unite/gists{/gist_id}","starred_url":"https://api.github.com/users/a-unite/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/a-unite/subscriptions","organizations_url":"https://api.github.com/users/a-unite/orgs","repos_url":"https://api.github.com/users/a-unite/repos","events_url":"https://api.github.com/users/a-unite/events{/privacy}","received_events_url":"https://api.github.com/users/a-unite/received_events","type":"User","site_admin":false},"created_at":"2015-10-20T14:25:40Z","updated_at":"2015-10-20T14:25:40Z","body":"@giastfader, yes we did and this is how our production version works for now.\r\nBut I still hope we could switch to current (proper) query parser soon.\r\n\r\n"}}