{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3231","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3231/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3231/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3231/events","html_url":"https://github.com/orientechnologies/orientdb/issues/3231","id":52395227,"number":3231,"title":"SQL NOT operator","user":{"login":"AaronSchulz","id":1020708,"avatar_url":"https://avatars.githubusercontent.com/u/1020708?v=3","gravatar_id":"","url":"https://api.github.com/users/AaronSchulz","html_url":"https://github.com/AaronSchulz","followers_url":"https://api.github.com/users/AaronSchulz/followers","following_url":"https://api.github.com/users/AaronSchulz/following{/other_user}","gists_url":"https://api.github.com/users/AaronSchulz/gists{/gist_id}","starred_url":"https://api.github.com/users/AaronSchulz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AaronSchulz/subscriptions","organizations_url":"https://api.github.com/users/AaronSchulz/orgs","repos_url":"https://api.github.com/users/AaronSchulz/repos","events_url":"https://api.github.com/users/AaronSchulz/events{/privacy}","received_events_url":"https://api.github.com/users/AaronSchulz/received_events","type":"User","site_admin":false},"labels":[],"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":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/17","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.2","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/17/labels","id":613160,"number":17,"title":"2.2","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":255,"closed_issues":66,"state":"open","created_at":"2014-03-28T13:17:36Z","updated_at":"2015-09-23T07:04:58Z","due_on":"2015-10-06T22:00:00Z","closed_at":null},"comments":3,"created_at":"2014-12-18T17:48:19Z","updated_at":"2015-09-23T10:49:40Z","closed_at":null,"body":"According to https://github.com/orientechnologies/orientdb/wiki/SQL-Where , NOT is not supported.\r\n\r\nSome queries seem to work with correct results anyway:\r\n\r\nselect id from Property where id NOT IN [279,16]\r\nselect id from Property where NOT (id IN [22,32,35,19])\r\n\r\nIs this just outdated documentation or are there edge cases that don't work?"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/142564084","html_url":"https://github.com/orientechnologies/orientdb/issues/3231#issuecomment-142564084","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3231","id":142564084,"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-23T10:49:40Z","updated_at":"2015-09-23T10:49:40Z","body":"NOT works if you use parenthesis on the right."}}