Bug 33584: (follow-up) Remove DEFAULT_GENERATED from column info
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Mon, 24 Apr 2023 12:28:46 +0000 (12:28 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Mon, 24 Apr 2023 15:08:01 +0000 (12:08 -0300)
commitedbc81199798aa084365a1845188aa24e6ad010b
treebbd589368db14d9cab9cc0e9a7c49fc227aaf855
parent726004a8c14e7e511201eb871e718d21b3a4c35e
Bug 33584: (follow-up) Remove DEFAULT_GENERATED from column info

MySQL 8 returns this additional information for a timestamp such
as the timestamp2 in the Commenter test.
Which results in the following alter:
    ALTER TABLE koha_myclone.database_commenter_1 MODIFY COLUMN `timestamp2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP DEFAULT_GENERATED COMMENT 'Column_5'
And that statement fails again on that keyword.
For now, it seems sufficient to ignore this keyword when building the alter statement.

Test plan:
Run t/db_dependent/Koha/Database/Commenter.t

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Did test it now under MySQL 8.
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Koha/Database/Commenter.pm