{"action":"created","issue":{"url":"https://api.github.com/repos/cakephp/cakephp/issues/8857","repository_url":"https://api.github.com/repos/cakephp/cakephp","labels_url":"https://api.github.com/repos/cakephp/cakephp/issues/8857/labels{/name}","comments_url":"https://api.github.com/repos/cakephp/cakephp/issues/8857/comments","events_url":"https://api.github.com/repos/cakephp/cakephp/issues/8857/events","html_url":"https://github.com/cakephp/cakephp/issues/8857","id":155728378,"number":8857,"title":"PDOException: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: id","user":{"login":"elboletaire","id":153305,"avatar_url":"https://avatars.githubusercontent.com/u/153305?v=3","gravatar_id":"","url":"https://api.github.com/users/elboletaire","html_url":"https://github.com/elboletaire","followers_url":"https://api.github.com/users/elboletaire/followers","following_url":"https://api.github.com/users/elboletaire/following{/other_user}","gists_url":"https://api.github.com/users/elboletaire/gists{/gist_id}","starred_url":"https://api.github.com/users/elboletaire/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elboletaire/subscriptions","organizations_url":"https://api.github.com/users/elboletaire/orgs","repos_url":"https://api.github.com/users/elboletaire/repos","events_url":"https://api.github.com/users/elboletaire/events{/privacy}","received_events_url":"https://api.github.com/users/elboletaire/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/cakephp/cakephp/milestones/90","html_url":"https://github.com/cakephp/cakephp/milestones/3.2.10","labels_url":"https://api.github.com/repos/cakephp/cakephp/milestones/90/labels","id":1770281,"number":90,"title":"3.2.10","description":"Bugfixes and minor optimizations for 3.2.x","creator":{"login":"markstory","id":24086,"avatar_url":"https://avatars.githubusercontent.com/u/24086?v=3","gravatar_id":"","url":"https://api.github.com/users/markstory","html_url":"https://github.com/markstory","followers_url":"https://api.github.com/users/markstory/followers","following_url":"https://api.github.com/users/markstory/following{/other_user}","gists_url":"https://api.github.com/users/markstory/gists{/gist_id}","starred_url":"https://api.github.com/users/markstory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markstory/subscriptions","organizations_url":"https://api.github.com/users/markstory/orgs","repos_url":"https://api.github.com/users/markstory/repos","events_url":"https://api.github.com/users/markstory/events{/privacy}","received_events_url":"https://api.github.com/users/markstory/received_events","type":"User","site_admin":false},"open_issues":37,"closed_issues":6,"state":"open","created_at":"2016-05-17T02:34:52Z","updated_at":"2016-05-19T19:20:26Z","due_on":"2016-06-12T04:00:00Z","closed_at":null},"comments":1,"created_at":"2016-05-19T12:48:02Z","updated_at":"2016-05-19T19:21:00Z","closed_at":null,"body":"This is a (multiple allowed):\r\n* [x] bug\r\n* [ ] enhancement\r\n* [ ] feature-discussion (RFC)\r\n\r\n* CakePHP Version: 3.2.9\r\n* Platform and Target: Linux (but probably all of them)\r\n\r\n### What you did\r\n\r\nCreated a fixture for a table that has an id with `BIGINT` instead of `INT`; using SQLite for tests.\r\n\r\n### Expected Behavior\r\n\r\nProperly run the tests.\r\n\r\n### Actual Behavior\r\n\r\nUsing `BIGINT` (in the fixture, that's `'type' => 'biginteger`') with `'null' => false` on the ID crashes with an `Integrity constraint violation`:\r\n\r\n    1) Stats\\Test\\TestCase\\Model\\Table\\StatsTableTest::testIncrease\r\n    PDOException: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: stats.id\r\n\r\nChanging the `type` to just `integer` or setting `null` to `true` does the trick (obviously I can't change either of them)."},"comment":{"url":"https://api.github.com/repos/cakephp/cakephp/issues/comments/220425703","html_url":"https://github.com/cakephp/cakephp/issues/8857#issuecomment-220425703","issue_url":"https://api.github.com/repos/cakephp/cakephp/issues/8857","id":220425703,"user":{"login":"markstory","id":24086,"avatar_url":"https://avatars.githubusercontent.com/u/24086?v=3","gravatar_id":"","url":"https://api.github.com/users/markstory","html_url":"https://github.com/markstory","followers_url":"https://api.github.com/users/markstory/followers","following_url":"https://api.github.com/users/markstory/following{/other_user}","gists_url":"https://api.github.com/users/markstory/gists{/gist_id}","starred_url":"https://api.github.com/users/markstory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markstory/subscriptions","organizations_url":"https://api.github.com/users/markstory/orgs","repos_url":"https://api.github.com/users/markstory/repos","events_url":"https://api.github.com/users/markstory/events{/privacy}","received_events_url":"https://api.github.com/users/markstory/received_events","type":"User","site_admin":false},"created_at":"2016-05-19T19:21:00Z","updated_at":"2016-05-19T19:21:00Z","body":"How can someone reproduce this issue? Could you paste the fixture that is giving you trouble?"}}