{"action":"created","issue":{"url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/4001","labels_url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/4001/labels{/name}","comments_url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/4001/comments","events_url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/4001/events","html_url":"https://github.com/bcit-ci/CodeIgniter/issues/4001","id":97353199,"number":4001,"title":"The query builder, escaping degradation in \"where\" clause detected","user":{"login":"ivantcholakov","id":1438104,"avatar_url":"https://avatars.githubusercontent.com/u/1438104?v=3","gravatar_id":"","url":"https://api.github.com/users/ivantcholakov","html_url":"https://github.com/ivantcholakov","followers_url":"https://api.github.com/users/ivantcholakov/followers","following_url":"https://api.github.com/users/ivantcholakov/following{/other_user}","gists_url":"https://api.github.com/users/ivantcholakov/gists{/gist_id}","starred_url":"https://api.github.com/users/ivantcholakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ivantcholakov/subscriptions","organizations_url":"https://api.github.com/users/ivantcholakov/orgs","repos_url":"https://api.github.com/users/ivantcholakov/repos","events_url":"https://api.github.com/users/ivantcholakov/events{/privacy}","received_events_url":"https://api.github.com/users/ivantcholakov/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-07-26T21:54:52Z","updated_at":"2015-07-27T19:01:03Z","closed_at":"2015-07-27T19:01:03Z","body":"```php\r\necho $this->db\r\n    ->select('id')\r\n    ->from('requests')\r\n    ->where('active', 1)\r\n    ->where('duration_date >=', 'CURDATE()', false)\r\n    ->get_compiled_select();\r\n```\r\n\r\nIn CodeIgniter 3.0.0 the result is as I expect it to be:\r\n\r\n```sql\r\nSELECT `id`\r\nFROM `requests`\r\nWHERE `active` = 1\r\nAND duration_date >=CURDATE()\r\n```\r\n\r\nThe current code CodeIgniter 3.0.1rc+ gives me wrong SQL:\r\n\r\n```sql\r\nSELECT `id`\r\nFROM `requests`\r\nWHERE `active` = 1\r\nAND duration_date >= 'CURDATE()'\r\n```"},"comment":{"url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/comments/125305951","html_url":"https://github.com/bcit-ci/CodeIgniter/issues/4001#issuecomment-125305951","issue_url":"https://api.github.com/repos/bcit-ci/CodeIgniter/issues/4001","id":125305951,"user":{"login":"narfbg","id":1058011,"avatar_url":"https://avatars.githubusercontent.com/u/1058011?v=3","gravatar_id":"","url":"https://api.github.com/users/narfbg","html_url":"https://github.com/narfbg","followers_url":"https://api.github.com/users/narfbg/followers","following_url":"https://api.github.com/users/narfbg/following{/other_user}","gists_url":"https://api.github.com/users/narfbg/gists{/gist_id}","starred_url":"https://api.github.com/users/narfbg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/narfbg/subscriptions","organizations_url":"https://api.github.com/users/narfbg/orgs","repos_url":"https://api.github.com/users/narfbg/repos","events_url":"https://api.github.com/users/narfbg/events{/privacy}","received_events_url":"https://api.github.com/users/narfbg/received_events","type":"User","site_admin":false},"created_at":"2015-07-27T19:01:03Z","updated_at":"2015-07-27T19:01:03Z","body":"2dfbe9997b28892342e826e9350a466e6bacfd2e\r\nf7631f18d65eaf7f2b3aa5ee603e84008a681ffc\r\nd4a50bd09ee38a25010ac58b17b8db37fc1ec0cb"}}