{"action":"created","issue":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/102","labels_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/102/labels{/name}","comments_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/102/comments","events_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/102/events","html_url":"https://github.com/NLPchina/elasticsearch-sql/pull/102","id":111705443,"number":102,"title":"Fixed a bug where not's would not evaluate properly.","user":{"login":"ottboy4","id":1182387,"avatar_url":"https://avatars.githubusercontent.com/u/1182387?v=3","gravatar_id":"","url":"https://api.github.com/users/ottboy4","html_url":"https://github.com/ottboy4","followers_url":"https://api.github.com/users/ottboy4/followers","following_url":"https://api.github.com/users/ottboy4/following{/other_user}","gists_url":"https://api.github.com/users/ottboy4/gists{/gist_id}","starred_url":"https://api.github.com/users/ottboy4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ottboy4/subscriptions","organizations_url":"https://api.github.com/users/ottboy4/orgs","repos_url":"https://api.github.com/users/ottboy4/repos","events_url":"https://api.github.com/users/ottboy4/events{/privacy}","received_events_url":"https://api.github.com/users/ottboy4/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-15T20:52:29Z","updated_at":"2015-10-16T15:45:10Z","closed_at":"2015-10-16T15:36:00Z","pull_request":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/pulls/102","html_url":"https://github.com/NLPchina/elasticsearch-sql/pull/102","diff_url":"https://github.com/NLPchina/elasticsearch-sql/pull/102.diff","patch_url":"https://github.com/NLPchina/elasticsearch-sql/pull/102.patch"},"body":"Removed the loop to go to the last where if the where's only had a single sub where. This breaks the NOT where because its operator is important. The test shows that if the where's are skipped to the last where the AND (must) changes to a OR (should), which changes the result.\r\nAdded a test for the use case and updated the other test the change affected."},"comment":{"url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/comments/148750923","html_url":"https://github.com/NLPchina/elasticsearch-sql/pull/102#issuecomment-148750923","issue_url":"https://api.github.com/repos/NLPchina/elasticsearch-sql/issues/102","id":148750923,"user":{"login":"ottboy4","id":1182387,"avatar_url":"https://avatars.githubusercontent.com/u/1182387?v=3","gravatar_id":"","url":"https://api.github.com/users/ottboy4","html_url":"https://github.com/ottboy4","followers_url":"https://api.github.com/users/ottboy4/followers","following_url":"https://api.github.com/users/ottboy4/following{/other_user}","gists_url":"https://api.github.com/users/ottboy4/gists{/gist_id}","starred_url":"https://api.github.com/users/ottboy4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ottboy4/subscriptions","organizations_url":"https://api.github.com/users/ottboy4/orgs","repos_url":"https://api.github.com/users/ottboy4/repos","events_url":"https://api.github.com/users/ottboy4/events{/privacy}","received_events_url":"https://api.github.com/users/ottboy4/received_events","type":"User","site_admin":false},"created_at":"2015-10-16T15:45:10Z","updated_at":"2015-10-16T15:45:10Z","body":"Great! Appreciate it!"}}