{"action":"created","issue":{"url":"https://api.github.com/repos/goodybag/mongo-sql/issues/147","repository_url":"https://api.github.com/repos/goodybag/mongo-sql","labels_url":"https://api.github.com/repos/goodybag/mongo-sql/issues/147/labels{/name}","comments_url":"https://api.github.com/repos/goodybag/mongo-sql/issues/147/comments","events_url":"https://api.github.com/repos/goodybag/mongo-sql/issues/147/events","html_url":"https://github.com/goodybag/mongo-sql/pull/147","id":219181367,"number":147,"title":"Fix null handling in condition builder so we get the right equality/inequality descriptors","user":{"login":"johansteffner","id":623271,"avatar_url":"https://avatars3.githubusercontent.com/u/623271?v=3","gravatar_id":"","url":"https://api.github.com/users/johansteffner","html_url":"https://github.com/johansteffner","followers_url":"https://api.github.com/users/johansteffner/followers","following_url":"https://api.github.com/users/johansteffner/following{/other_user}","gists_url":"https://api.github.com/users/johansteffner/gists{/gist_id}","starred_url":"https://api.github.com/users/johansteffner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johansteffner/subscriptions","organizations_url":"https://api.github.com/users/johansteffner/orgs","repos_url":"https://api.github.com/users/johansteffner/repos","events_url":"https://api.github.com/users/johansteffner/events{/privacy}","received_events_url":"https://api.github.com/users/johansteffner/received_events","type":"User","site_admin":false},"labels":[{"id":32995744,"url":"https://api.github.com/repos/goodybag/mongo-sql/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-04-04T08:53:40Z","updated_at":"2017-04-08T15:58:57Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/goodybag/mongo-sql/pulls/147","html_url":"https://github.com/goodybag/mongo-sql/pull/147","diff_url":"https://github.com/goodybag/mongo-sql/pull/147.diff","patch_url":"https://github.com/goodybag/mongo-sql/pull/147.patch"},"body":"Entering the following mongo-sql query results in an unexpected query:\r\n```json\r\n{\r\n  \"type\": \"select\",\r\n  \"table\": \"users\",\r\n  \"where\": {\r\n    \"email\": { \"$ne\": null }\r\n  }\r\n}\r\n```\r\n\r\nExpected result:\r\n```sql\r\nselect \"users\".* from \"users\" where \"users\".\"email\" is not null\r\n```\r\n\r\nActual result:\r\n```sql\r\nselect \"users\".* from \"users\" where \"users\".\"email\" is null\r\n```"},"comment":{"url":"https://api.github.com/repos/goodybag/mongo-sql/issues/comments/292726959","html_url":"https://github.com/goodybag/mongo-sql/pull/147#issuecomment-292726959","issue_url":"https://api.github.com/repos/goodybag/mongo-sql/issues/147","id":292726959,"user":{"login":"jrf0110","id":767070,"avatar_url":"https://avatars2.githubusercontent.com/u/767070?v=3","gravatar_id":"","url":"https://api.github.com/users/jrf0110","html_url":"https://github.com/jrf0110","followers_url":"https://api.github.com/users/jrf0110/followers","following_url":"https://api.github.com/users/jrf0110/following{/other_user}","gists_url":"https://api.github.com/users/jrf0110/gists{/gist_id}","starred_url":"https://api.github.com/users/jrf0110/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jrf0110/subscriptions","organizations_url":"https://api.github.com/users/jrf0110/orgs","repos_url":"https://api.github.com/users/jrf0110/repos","events_url":"https://api.github.com/users/jrf0110/events{/privacy}","received_events_url":"https://api.github.com/users/jrf0110/received_events","type":"User","site_admin":false},"created_at":"2017-04-08T15:58:57Z","updated_at":"2017-04-08T15:58:57Z","body":"Sorry for the late reply @johansteffner\r\n\r\nI've converted this issue into a Pull Request that fixes the bug. This will be in npm at `mongo-sql@3.0.1`"}}
{"actor":{"display_login":"jrf0110"}}