{"action":"opened","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5426","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5426/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5426/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5426/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5426","id":120534522,"number":5426,"title":"Class aliases in SELECTS","user":{"login":"mdekrey","id":144461,"avatar_url":"https://avatars.githubusercontent.com/u/144461?v=3","gravatar_id":"","url":"https://api.github.com/users/mdekrey","html_url":"https://github.com/mdekrey","followers_url":"https://api.github.com/users/mdekrey/followers","following_url":"https://api.github.com/users/mdekrey/following{/other_user}","gists_url":"https://api.github.com/users/mdekrey/gists{/gist_id}","starred_url":"https://api.github.com/users/mdekrey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdekrey/subscriptions","organizations_url":"https://api.github.com/users/mdekrey/orgs","repos_url":"https://api.github.com/users/mdekrey/repos","events_url":"https://api.github.com/users/mdekrey/events{/privacy}","received_events_url":"https://api.github.com/users/mdekrey/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-12-05T06:23:23Z","updated_at":"2015-12-05T06:23:23Z","closed_at":null,"body":"In the demo \"GratefulDeadConcerts\" database, I am unable to find a way to use class aliases, even in simple queries. I am running community 2.1.6.\r\n\r\nI have tried:\r\n```select other.name as pseudonym from V other\r\nselect other.name as pseudonym from V AS other\r\nselect from V as other```\r\n\r\n(Note that the `as pseudonym` does work when I am not attempting the `as other`.)\r\n\r\nIt gives me an error like the following:\r\n```com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #0: Error parsing query: \\u000aselect other.name as pseudonym from V as other\\u000aEncountered \\\" <AS> \\\"as \\\"\\\" at line 1, column 39.\\u000d\\u000aWas expecting one of:\\u000d\\u000a    <EOF> \\u000d\\u000a    <WHERE> ...\\u000d\\u000a    <ORDER> ...\\u000d\\u000a    <GROUP> ...\\u000d\\u000a    <LIMIT> ...\\u000d\\u000a    <SKIP2> ...\\u000d\\u000a    <OFFSET> ...\\u000d\\u000a    <TIMEOUT> ...\\u000d\\u000a    <FETCHPLAN> ...\\u000d\\u000a    <LOCK> ...\\u000d\\u000a    <LET> ...\\u000d\\u000a    <NOCACHE> ...\\u000d\\u000a    <PARALLEL> ...\\u000d\\u000a    <UNWIND> ...\\u000d\\u000a    \\\";\\\" ...\\u000d\\u000a    <LET> ...\\u000d\\u000a    <WHERE> ...\\u000d\\u000a    <GROUP> ...\\u000d\\u000a    <ORDER> ...\\u000d\\u000a    <UNWIND> ...\\u000d\\u000a    <SKIP2> ...\\u000d\\u000a    <OFFSET> ...\\u000d\\u000a    <LIMIT> ...\\u000d\\u000a    <FETCHPLAN> ...\\u000d\\u000a    <TIMEOUT> ...\\u000d\\u000a    <LOCK> ...\\u000d\\u000a    <PARALLEL> ...\\u000d\\u000a    <NOCACHE> ...\\u000d\\u000a    <NOCACHE> ...\\u000d\\u000a    ```\r\n\r\nI see that #1920 appears to be asking for the same thing, but was resolved over a year ago. What am I missing?\r\n\r\nThanks!"}}