{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3345","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3345/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3345/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3345/events","html_url":"https://github.com/orientechnologies/orientdb/issues/3345","id":53656324,"number":3345,"title":"UTF8 character breaking query","user":{"login":"devourment77","id":1877193,"avatar_url":"https://avatars.githubusercontent.com/u/1877193?v=3","gravatar_id":"","url":"https://api.github.com/users/devourment77","html_url":"https://github.com/devourment77","followers_url":"https://api.github.com/users/devourment77/followers","following_url":"https://api.github.com/users/devourment77/following{/other_user}","gists_url":"https://api.github.com/users/devourment77/gists{/gist_id}","starred_url":"https://api.github.com/users/devourment77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devourment77/subscriptions","organizations_url":"https://api.github.com/users/devourment77/orgs","repos_url":"https://api.github.com/users/devourment77/repos","events_url":"https://api.github.com/users/devourment77/events{/privacy}","received_events_url":"https://api.github.com/users/devourment77/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"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},"milestone":null,"comments":3,"created_at":"2015-01-07T17:13:08Z","updated_at":"2015-01-07T18:10:11Z","closed_at":null,"body":"Hello,\r\n\r\nWhen running this query with 2.0-rc1, we get an odd error that says \"AND\" is an invalid keyword.  Taking out the \"ß\" character fixes the query.  We have not run into this with other utf8 chars yet.\r\n\r\nQUERY\r\nselect * from Attraction where name = 'Schloßberg Hotel' and archive = false\r\n\r\nERROR FROM ORIENTDB\r\n-----------------------------------------------------------------^\r\ncom.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #57: Invalid keyword 'AND'\r\nCommand: select * from Attraction where name = 'Schloßberg Hotel' and archive = false\r\n-----------------------------------------------------------------^\r\n    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLAbstract.throwParsingException(OCommandExecutorSQLAbstract.java:93)\r\n    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parse(OCommandExecutorSQLSelect.java:266)\r\n    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parse(OCommandExecutorSQLSelect.java:96)\r\n    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.parse(OCommandExecutorSQLDelegate.java:56)\r\n    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.parse(OCommandExecutorSQLDelegate.java:37)\r\n    at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.command(OAbstractPaginatedStorage.java:1150)\r\n    at com.orientechnologies.orient.core.sql.query.OSQLQuery.run(OSQLQuery.java:71)\r\n    at com.orientechnologies.orient.core.sql.query.OSQLSynchQuery.run(OSQLSynchQuery.java:85)\r\n    at com.orientechnologies.orient.core.query.OQueryAbstract.execute(OQueryAbstract.java:33)\r\n    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.command(ONetworkProtocolBinary.java:1179)\r\n    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:385)\r\n    at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:216)\r\n    at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:65)"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/69064260","html_url":"https://github.com/orientechnologies/orientdb/issues/3345#issuecomment-69064260","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3345","id":69064260,"user":{"login":"devourment77","id":1877193,"avatar_url":"https://avatars.githubusercontent.com/u/1877193?v=3","gravatar_id":"","url":"https://api.github.com/users/devourment77","html_url":"https://github.com/devourment77","followers_url":"https://api.github.com/users/devourment77/followers","following_url":"https://api.github.com/users/devourment77/following{/other_user}","gists_url":"https://api.github.com/users/devourment77/gists{/gist_id}","starred_url":"https://api.github.com/users/devourment77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devourment77/subscriptions","organizations_url":"https://api.github.com/users/devourment77/orgs","repos_url":"https://api.github.com/users/devourment77/repos","events_url":"https://api.github.com/users/devourment77/events{/privacy}","received_events_url":"https://api.github.com/users/devourment77/received_events","type":"User","site_admin":false},"created_at":"2015-01-07T18:10:11Z","updated_at":"2015-01-07T18:10:11Z","body":"We tried with the \"develop\" branch and still see the issue.  I didn't not see a 2-0-SNAPSHOT branch to try out (apologies if I overlooked it).\r\n\r\nThanks\r\nBrandon"}}