{"action":"closed","issue":{"url":"https://api.github.com/repos/Azure/msphpsql/issues/93","repository_url":"https://api.github.com/repos/Azure/msphpsql","labels_url":"https://api.github.com/repos/Azure/msphpsql/issues/93/labels{/name}","comments_url":"https://api.github.com/repos/Azure/msphpsql/issues/93/comments","events_url":"https://api.github.com/repos/Azure/msphpsql/issues/93/events","html_url":"https://github.com/Azure/msphpsql/issues/93","id":153808789,"number":93,"title":"PDO Driver handling of booleans","user":{"login":"meet-bhagdev","id":11928821,"avatar_url":"https://avatars.githubusercontent.com/u/11928821?v=3","gravatar_id":"","url":"https://api.github.com/users/meet-bhagdev","html_url":"https://github.com/meet-bhagdev","followers_url":"https://api.github.com/users/meet-bhagdev/followers","following_url":"https://api.github.com/users/meet-bhagdev/following{/other_user}","gists_url":"https://api.github.com/users/meet-bhagdev/gists{/gist_id}","starred_url":"https://api.github.com/users/meet-bhagdev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/meet-bhagdev/subscriptions","organizations_url":"https://api.github.com/users/meet-bhagdev/orgs","repos_url":"https://api.github.com/users/meet-bhagdev/repos","events_url":"https://api.github.com/users/meet-bhagdev/events{/privacy}","received_events_url":"https://api.github.com/users/meet-bhagdev/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Azure/msphpsql/labels/php7","name":"php7","color":"5319e7"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-05-09T15:53:16Z","updated_at":"2016-08-09T00:20:29Z","closed_at":"2016-08-09T00:20:29Z","body":"Selects are not working with booleans in filter.\r\n\r\nHere is pdo statement debug dump params:\r\n\r\nSQL: [133] SELECT * FROM [Scripts] WHERE ([Hidden]=:qp0) AND ([TaggedRemoved]=:qp1) ORDER BY (SELECT NULL) OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY\r\nParams: 2\r\nKey: Name: [4] :qp0\r\nparamno=0\r\nname=[4] \":qp0\"\r\nis_param=1\r\nparam_type=5\r\nKey: Name: [4] :qp1\r\nparamno=1\r\nname=[4] \":qp1\"\r\nis_param=1\r\nparam_type=5\r\nI also tried \\PDO::PARAM_INT, not working on \"bit\" datatype column.\r\n\r\nhttps://github.com/cakephp/cakephp/issues/8674"}}
{"actor":{"display_login":"meet-bhagdev"}}