{"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":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-08-07T08:16:45Z","updated_at":"2015-08-12T22:52:43Z","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/130471198","html_url":"https://github.com/orientechnologies/orientdb/issues/4752#issuecomment-130471198","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4752","id":130471198,"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-08-12T22:52:43Z","updated_at":"2015-08-12T22:52:43Z","body":"As I understand presence of system field in server answer should tell us, that we have original object (with `@rid`, `@type` and other system fields in place) as result.\r\nAbsence of such special fields somehow indicates, that we have synthetic answer from the server (projection, in general, is synthetic set of fields).\r\nAs for me it should be clear from particular fields, though. E.g. conjunction of `@type`, `@rid` and `@version` fields, as it is formed now. While I, personally, will be glad to have special indicator\\answer property, something like `@answerType`.\r\n\r\nAnyway, we are going off track here.\r\nSupport of old behavior is essential for us. Improvements are very much welcomed."}}