Bugzilla – Attachment 150933 Details for
Bug 33686
Update plugin unimarc_field_100.pl 'Script of title' with 2022 values
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 33584: (follow-up) Remove DEFAULT_GENERATED from column info
Bug-33584-follow-up-Remove-DEFAULTGENERATED-from-c.patch (text/plain), 1.44 KB, created by
Thibaud Guillot (thibaud_g)
on 2023-05-10 08:08:47 UTC
(
hide
)
Description:
Bug 33584: (follow-up) Remove DEFAULT_GENERATED from column info
Filename:
MIME Type:
Creator:
Thibaud Guillot (thibaud_g)
Created:
2023-05-10 08:08:47 UTC
Size:
1.44 KB
patch
obsolete
>From bacb6291801f795bca3e0c68e2556f2b2d51486d Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Mon, 24 Apr 2023 12:28:46 +0000 >Subject: [PATCH] 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> > >https://bugs.koha-community.org/show_bug.cgi?id=33686 >--- > Koha/Database/Commenter.pm | 1 + > 1 file changed, 1 insertion(+) > >diff --git a/Koha/Database/Commenter.pm b/Koha/Database/Commenter.pm >index c349deffa9..7987b668b9 100644 >--- a/Koha/Database/Commenter.pm >+++ b/Koha/Database/Commenter.pm >@@ -245,6 +245,7 @@ sub _change_column { > } > > # Extra (like autoincrement) >+ $info->{Extra} =~ s/DEFAULT_GENERATED//; # need to remove it for mysql8 timestamps > $rv .= $info->{Extra}. ' ' if $info->{Extra}; > > # Comment if passed; not passing means clearing actually. >-- >2.25.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 33686
:
150714
|
150790
|
150933
|
150934
|
150935
|
150936
|
150937
|
150938
|
151178
|
151179
|
151340
|
151341