{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5014","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5014/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5014/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5014/events","html_url":"https://github.com/orientechnologies/orientdb/issues/5014","id":108164239,"number":5014,"title":"Including a NOT in a query blows up","user":{"login":"optimuspaul","id":1088506,"avatar_url":"https://avatars.githubusercontent.com/u/1088506?v=3","gravatar_id":"","url":"https://api.github.com/users/optimuspaul","html_url":"https://github.com/optimuspaul","followers_url":"https://api.github.com/users/optimuspaul/followers","following_url":"https://api.github.com/users/optimuspaul/following{/other_user}","gists_url":"https://api.github.com/users/optimuspaul/gists{/gist_id}","starred_url":"https://api.github.com/users/optimuspaul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/optimuspaul/subscriptions","organizations_url":"https://api.github.com/users/optimuspaul/orgs","repos_url":"https://api.github.com/users/optimuspaul/repos","events_url":"https://api.github.com/users/optimuspaul/events{/privacy}","received_events_url":"https://api.github.com/users/optimuspaul/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/question","name":"question","color":"cc317c"}],"state":"closed","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":4,"created_at":"2015-09-24T16:18:55Z","updated_at":"2015-09-24T18:46:00Z","closed_at":"2015-09-24T18:46:00Z","body":"Is Not not supported any longer?  I was on 2.0.10 and found that Not didn't work with filtering based on edge properties. So I bumped up to 2.1.2 and now I get this error...\r\n\r\n```\r\ncom.orientechnologies.orient.core.sql.OCommandSQLParsingException - Error on parsing command at position #0: Encountered \" <NOT> \"NOT \"\" at line 1, column 62.\r\nWas expecting one of:\r\n    <EOF> \r\n    <AND> ...\r\n    <OR> ...\r\n    <ORDER> ...\r\n    <GROUP> ...\r\n    <LIMIT> ...\r\n    <SKIP2> ...\r\n    <OFFSET> ...\r\n    <TIMEOUT> ...\r\n    <FETCHPLAN> ...\r\n    <LOCK> ...\r\n    <NOCACHE> ...\r\n    <PARALLEL> ...\r\n    <UNWIND> ...\r\n    \";\" ...\r\n    <AND> ...\r\n    <OR> ...\r\n    <GROUP> ...\r\n    <ORDER> ...\r\n    <UNWIND> ...\r\n    <SKIP2> ...\r\n    <OFFSET> ...\r\n    <LIMIT> ...\r\n    <FETCHPLAN> ...\r\n    <TIMEOUT> ...\r\n    <LOCK> ...\r\n    <PARALLEL> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n    <NOCACHE> ...\r\n```\r\n\r\nWhat has happened?"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/143016490","html_url":"https://github.com/orientechnologies/orientdb/issues/5014#issuecomment-143016490","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/5014","id":143016490,"user":{"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},"created_at":"2015-09-24T18:46:00Z","updated_at":"2015-09-24T18:46:00Z","body":"That query seems invalid. You should put an AND or OR after the first condition. Example:\r\n\r\n    SELECT * FROM cg_sps_application\r\n    WHERE status = 'Production'\r\n    AND NOT ( inE('cg_sps_application_subscription')[organization] in 'sps:org:test-00000000-0000-0000-0000-000000000001' )\r\n"}}