{"action":"closed","issue":{"url":"https://api.github.com/repos/dalibo/powa/issues/50","labels_url":"https://api.github.com/repos/dalibo/powa/issues/50/labels{/name}","comments_url":"https://api.github.com/repos/dalibo/powa/issues/50/comments","events_url":"https://api.github.com/repos/dalibo/powa/issues/50/events","html_url":"https://github.com/dalibo/powa/issues/50","id":81915556,"number":50,"title":"where clause gets munged","user":{"login":"shribe","id":3246499,"avatar_url":"https://avatars.githubusercontent.com/u/3246499?v=3","gravatar_id":"","url":"https://api.github.com/users/shribe","html_url":"https://github.com/shribe","followers_url":"https://api.github.com/users/shribe/followers","following_url":"https://api.github.com/users/shribe/following{/other_user}","gists_url":"https://api.github.com/users/shribe/gists{/gist_id}","starred_url":"https://api.github.com/users/shribe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shribe/subscriptions","organizations_url":"https://api.github.com/users/shribe/orgs","repos_url":"https://api.github.com/users/shribe/repos","events_url":"https://api.github.com/users/shribe/events{/privacy}","received_events_url":"https://api.github.com/users/shribe/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-05-28T12:56:55Z","updated_at":"2015-08-14T16:29:21Z","closed_at":"2015-08-14T16:29:21Z","body":"I don't know if it's in the capture or the analysis, but it's displaying the following to me:\r\n\r\nSELECT COUNT(*) FROM \"Appointment\" WHERE (\"Person_Id\" = '2015-05-28 00:00:00'::timestamp without time zone and \"CanceledWhen\" is null and \"AptWhen\" >= 21524038::integer)\r\n\r\nI only find one place in my code with those criteria, and it does not have the person id & time criteria reversed. In fact, the query as reported would not even execute because of the type mismatches."}}