[Koha-bugs] [Bug 33584] Fix failures for Database/Commenter.t on MySQL 8

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Apr 24 14:36:35 CEST 2023


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33584

--- Comment #6 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
Created attachment 150154
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=150154&action=edit
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 at rijksmuseum.nl>
Did test it now under MySQL 8.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list