{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/2094","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/2094/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/2094/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/2094/events","html_url":"https://github.com/orientechnologies/orientdb/issues/2094","id":28859037,"number":2094,"title":"SQL: Multi-column ORDER BY does not default to ASC and throws Exception","user":{"login":"dxxr","id":5471331,"avatar_url":"https://avatars.githubusercontent.com/u/5471331?v=3","gravatar_id":"","url":"https://api.github.com/users/dxxr","html_url":"https://github.com/dxxr","followers_url":"https://api.github.com/users/dxxr/followers","following_url":"https://api.github.com/users/dxxr/following{/other_user}","gists_url":"https://api.github.com/users/dxxr/gists{/gist_id}","starred_url":"https://api.github.com/users/dxxr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dxxr/subscriptions","organizations_url":"https://api.github.com/users/dxxr/orgs","repos_url":"https://api.github.com/users/dxxr/repos","events_url":"https://api.github.com/users/dxxr/events{/privacy}","received_events_url":"https://api.github.com/users/dxxr/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","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/4","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/4/labels","id":227432,"number":4,"title":"2.1","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":197,"closed_issues":20,"state":"open","created_at":"2012-12-10T23:58:21Z","updated_at":"2015-02-16T16:55:20Z","due_on":"2015-02-26T23:00:00Z","closed_at":null},"comments":1,"created_at":"2014-03-06T09:00:13Z","updated_at":"2015-02-16T16:55:20Z","closed_at":"2015-02-16T16:55:20Z","body":"OrientDB v.1.6.3\r\n\r\nIf an SQL command contains a multi-column ORDER BY, an exception will be thrown if the direction is omitted for any but the last entry.\r\n\r\n<pre>\r\norientdb> SELECT FROM OUser ORDER BY status, name\r\n\r\nError: com.orientechnologies.orient.enterprise.channel.binary.OResponseProcessingException: Exception during response processing.\r\nError: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #33: Ordering mode 'NAME' not supported\r\n. Valid is 'ASC', 'DESC' or nothing ('ASC' by default)\r\nCommand: select FROM OUser ORDER BY status, name\r\n-----------------------------------------^\r\n</pre>\r\n<pre>\r\norientdb> SELECT FROM OUser ORDER BY status ASC, name\r\n...\r\n3 item(s) found. Query executed in 0.007 sec(s).\r\n</pre>"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/74538748","html_url":"https://github.com/orientechnologies/orientdb/issues/2094#issuecomment-74538748","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/2094","id":74538748,"user":{"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},"created_at":"2015-02-16T16:55:20Z","updated_at":"2015-02-16T16:55:20Z","body":"fixed in 2.1 snapshot"}}