{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5939","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5939/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5939/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5939/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5939","id":146037449,"number":5939,"title":"Where condition with nested parenthesis fails","user":{"login":"janjilek","id":5908091,"avatar_url":"https://avatars.githubusercontent.com/u/5908091?v=3","gravatar_id":"","url":"https://api.github.com/users/janjilek","html_url":"https://github.com/janjilek","followers_url":"https://api.github.com/users/janjilek/followers","following_url":"https://api.github.com/users/janjilek/following{/other_user}","gists_url":"https://api.github.com/users/janjilek/gists{/gist_id}","starred_url":"https://api.github.com/users/janjilek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/janjilek/subscriptions","organizations_url":"https://api.github.com/users/janjilek/orgs","repos_url":"https://api.github.com/users/janjilek/repos","events_url":"https://api.github.com/users/janjilek/events{/privacy}","received_events_url":"https://api.github.com/users/janjilek/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":null,"comments":4,"created_at":"2016-04-05T16:14:41Z","updated_at":"2016-04-06T10:09:13Z","closed_at":null,"body":"Hi,\r\ni have following select \r\n\r\nSELECT FROM Gift WHERE status = 300 AND ((date >= date(\"1970-01-01 00:00:00.000\", \"yyyy-MM-dd HH:mm:ss.SSS\", \"UTC\") AND date < date(\"2016-04-05 16:09:40.901\", \"yyyy-MM-dd HH:mm:ss.SSS\", \"UTC\")) OR date IS NULL)\r\n\r\nWhen a try to execute it, I receive this exeption:\r\ncom.orientechnologies.orient.core.exception.OQueryParsingException: Error on parsing query at position #195: Error on parsing command at position #0: Error on parsing query Query: status = 300 AND ((date >= date(\"1970-01-01 00:00:00.000\", \"yyyy-MM-dd HH:mm:ss.SSS\", \"UTC\") AND date < date(\"2016-04-05 16:09:40.901\", \"yyyy-MM-dd HH:mm:ss.SSS\", \"UTC\")) OR date IS NULL) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^\r\n --> com.orientechnologies.orient.core.exception.OSerializationException: Found invalid ) character at position 65 of text date(\"2016-04-05 16:09:40.901\", \"yyyy-MM-dd HH:mm:ss.SSS\", \"UTC\")). Ensure it is opened and closed correctly.\r\n\r\nWhen i remove all parenthesis, everything works just fine.\r\n\r\nIts not possible to create more complicated where conditions?\r\n\r\nOrientDB: 2.1.11, 2.1.13\r\n\r\nRegards\r\nJan"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/206284128","html_url":"https://github.com/orientechnologies/orientdb/issues/5939#issuecomment-206284128","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5939","id":206284128,"user":{"login":"janjilek","id":5908091,"avatar_url":"https://avatars.githubusercontent.com/u/5908091?v=3","gravatar_id":"","url":"https://api.github.com/users/janjilek","html_url":"https://github.com/janjilek","followers_url":"https://api.github.com/users/janjilek/followers","following_url":"https://api.github.com/users/janjilek/following{/other_user}","gists_url":"https://api.github.com/users/janjilek/gists{/gist_id}","starred_url":"https://api.github.com/users/janjilek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/janjilek/subscriptions","organizations_url":"https://api.github.com/users/janjilek/orgs","repos_url":"https://api.github.com/users/janjilek/repos","events_url":"https://api.github.com/users/janjilek/events{/privacy}","received_events_url":"https://api.github.com/users/janjilek/received_events","type":"User","site_admin":false},"created_at":"2016-04-06T10:09:13Z","updated_at":"2016-04-06T10:09:13Z","body":"Hi,\r\nyes,  I am using old one. I cannot migrate it, because I have a lot of parsing errors on the new one, so it will take some time to migrate it. I will try it with the space and let you know in few minutes. \r\n\r\nThanks \r\nJan"}}