{"push_id":791435609,"size":1,"distinct_size":1,"ref":"refs/heads/master","head":"859a905cd07d81bfe426d36b6176b803b1ccf9ac","before":"cdfd83fed410fab2c92a2ce51eefe793f87460bd","commits":[{"sha":"859a905cd07d81bfe426d36b6176b803b1ccf9ac","author":{"email":"306effa1188b7cf542c1ddc06bb053427b63996a@mojocode.de","name":"Morton Jonuschat"},"message":"[BUGFIX] InstallTool: Optimize ALTER TABLE for auto_increment columns\n\nTo successfully add a new column with auto_increment enabled to a table\nthe column needs to be included in a (primary) key. The install tool\nhandled this in a two step process by ignoring the auto_increment\nattribute and separating adding the field and the key into two\nstatements. This fails on existing tables with data as the column will\ninclude non-uniqued/non-incrementing values after the first statement\nleading to failures adding the key.\n\nThe proper way to add a columns with the auto_increment attribute is to\ncombine the ALTER TABLE statement to perform both alterations at the\nsame time, this patch changes the behavior of the Install Tool to\ngenerate statements accordingly on MySQL.\n\nWhen running with DBAL enabled the statement will not be altered in any\nway to allow the SqlParser to take into account database specific\nhandling of this case, an example test case is included for PostgreSQL\nwhich handles this case transparently using the SERIAL column type.\n\nResolves: #69304\nReleases: master, 6.2\nChange-Id: I211b25b22e122e47d289b9d7f927b5c713cdd138\nReviewed-on: http://review.typo3.org/42902\nReviewed-by: Morton Jonuschat <m.jonuschat@mojocode.de>\nTested-by: Morton Jonuschat <m.jonuschat@mojocode.de>\nReviewed-by: Nicole Cordes <typo3@cordes.co>\nTested-by: Nicole Cordes <typo3@cordes.co>","distinct":true,"url":"https://api.github.com/repos/TYPO3/TYPO3.CMS/commits/859a905cd07d81bfe426d36b6176b803b1ccf9ac"}]}