Bugzilla – Attachment 152648 Details for
Bug 34029
Import breaks when data exceeds size of mapped database columns
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 34029: (QA follow-up) Change from longtext to text
Bug-34029-QA-follow-up-Change-from-longtext-to-tex.patch (text/plain), 8.19 KB, created by
Katrin Fischer
on 2023-06-23 16:07:55 UTC
(
hide
)
Description:
Bug 34029: (QA follow-up) Change from longtext to text
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2023-06-23 16:07:55 UTC
Size:
8.19 KB
patch
obsolete
>From 951e3b3d2966f965b576bc493c084157f63f47ad Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <katrin.fischer@bsz-bw.de> >Date: Fri, 23 Jun 2023 16:07:10 +0000 >Subject: [PATCH] Bug 34029: (QA follow-up) Change from longtext to text > >Can be squashed if needed. >--- > .../atomicupdate/bug_34029_biblioitems.pl | 40 +++++++++---------- > installer/data/mysql/kohastructure.sql | 20 +++++----- > 2 files changed, 30 insertions(+), 30 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_34029_biblioitems.pl b/installer/data/mysql/atomicupdate/bug_34029_biblioitems.pl >index 701b7170c2..e2d7d926ef 100755 >--- a/installer/data/mysql/atomicupdate/bug_34029_biblioitems.pl >+++ b/installer/data/mysql/atomicupdate/bug_34029_biblioitems.pl >@@ -8,58 +8,58 @@ return { > my ($dbh, $out) = @$args{qw(dbh out)}; > $dbh->do(q{ > ALTER TABLE `biblioitems` >- MODIFY COLUMN `place` longtext DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)' >+ MODIFY COLUMN `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)' > }); >- say $out "Updated biblioitems.place to longtext"; >+ say $out "Updated biblioitems.place to text"; > $dbh->do(q{ > ALTER TABLE `deletedbiblioitems` >- MODIFY COLUMN `place` longtext DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)' >+ MODIFY COLUMN `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)' > }); >- say $out "Updated deletedbiblioitems.place to longtext"; >+ say $out "Updated deletedbiblioitems.place to text"; > > $dbh->do(q{ > ALTER TABLE `biblioitems` >- MODIFY COLUMN `publishercode` longtext DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' >+ MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' > }); >- say $out "Updated biblioitems.publishercode to longtext"; >+ say $out "Updated biblioitems.publishercode to text"; > $dbh->do(q{ > ALTER TABLE `deletedbiblioitems` >- MODIFY COLUMN `publishercode` longtext DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' >+ MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' > }); >- say $out "Updated deletedbiblioitems.publishercode to longtext"; >+ say $out "Updated deletedbiblioitems.publishercode to text"; > > $dbh->do(q{ > ALTER TABLE `biblioitems` >- MODIFY COLUMN `size` longtext DEFAULT NULL COMMENT 'material size (MARC21 300$c)' >+ MODIFY COLUMN `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)' > }); >- say $out "Updated biblioitems.size to longtext"; >+ say $out "Updated biblioitems.size to text"; > $dbh->do(q{ > ALTER TABLE `deletedbiblioitems` >- MODIFY COLUMN `size` longtext DEFAULT NULL COMMENT 'material size (MARC21 300$c)' >+ MODIFY COLUMN `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)' > }); >- say $out "Updated deletedbiblioitems.size to longtext"; >+ say $out "Updated deletedbiblioitems.size to text"; > > $dbh->do(q{ > ALTER TABLE `biblioitems` >- MODIFY COLUMN `pages` longtext DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)' >+ MODIFY COLUMN `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)' > }); >- say $out "Updated biblioitems.pages to longtext"; >+ say $out "Updated biblioitems.pages to text"; > $dbh->do(q{ > ALTER TABLE `deletedbiblioitems` >- MODIFY COLUMN `pages` longtext DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)' >+ MODIFY COLUMN `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)' > }); >- say $out "Updated deletedbiblioitems.pages to longtext"; >+ say $out "Updated deletedbiblioitems.pages to text"; > > $dbh->do(q{ > ALTER TABLE `biblioitems` >- MODIFY COLUMN `illus` longtext DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)' >+ MODIFY COLUMN `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)' > }); >- say $out "Updated biblioitems.illus to longtext"; >+ say $out "Updated biblioitems.illus to text"; > $dbh->do(q{ > ALTER TABLE `deletedbiblioitems` >- MODIFY COLUMN `illus` longtext DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)' >+ MODIFY COLUMN `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)' > }); >- say $out "Updated deletedbiblioitems.illus to longtext"; >+ say $out "Updated deletedbiblioitems.illus to text"; > > }, > }; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index a5182e15c5..2807fcda36 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1123,7 +1123,7 @@ CREATE TABLE `biblioitems` ( > `issn` longtext DEFAULT NULL COMMENT 'ISSN (MARC21 022$a)', > `ean` longtext DEFAULT NULL, > `publicationyear` mediumtext DEFAULT NULL, >- `publishercode` longtext DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 246$b)', >+ `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 246$b)', > `volumedate` date DEFAULT NULL, > `volumedesc` mediumtext DEFAULT NULL COMMENT 'volume information (MARC21 362$a)', > `collectiontitle` longtext DEFAULT NULL, >@@ -1132,11 +1132,11 @@ CREATE TABLE `biblioitems` ( > `editionstatement` mediumtext DEFAULT NULL, > `editionresponsibility` mediumtext DEFAULT NULL, > `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), >- `illus` longtext DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)', >- `pages` longtext DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)', >+ `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)', >+ `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)', > `notes` longtext DEFAULT NULL, >- `size` longtext DEFAULT NULL COMMENT 'material size (MARC21 300$c)', >- `place` longtext DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)', >+ `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)', >+ `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264$a)', > `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)', > `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)', > `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)', >@@ -2526,7 +2526,7 @@ CREATE TABLE `deletedbiblioitems` ( > `issn` longtext DEFAULT NULL COMMENT 'ISSN (MARC21 022$a)', > `ean` longtext DEFAULT NULL, > `publicationyear` mediumtext DEFAULT NULL, >- `publishercode` longtext DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)', >+ `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)', > `volumedate` date DEFAULT NULL, > `volumedesc` mediumtext DEFAULT NULL COMMENT 'volume information (MARC21 362$a)', > `collectiontitle` longtext DEFAULT NULL, >@@ -2535,11 +2535,11 @@ CREATE TABLE `deletedbiblioitems` ( > `editionstatement` mediumtext DEFAULT NULL, > `editionresponsibility` mediumtext DEFAULT NULL, > `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), >- `illus` longtext DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)', >- `pages` longtext DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)', >+ `illus` text DEFAULT NULL COMMENT 'illustrations (MARC21 300$b)', >+ `pages` text DEFAULT NULL COMMENT 'number of pages (MARC21 300$a)', > `notes` longtext DEFAULT NULL, >- `size` longtext DEFAULT NULL COMMENT 'material size (MARC21 300$c)', >- `place` longtext DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264§a)', >+ `size` text DEFAULT NULL COMMENT 'material size (MARC21 300$c)', >+ `place` text DEFAULT NULL COMMENT 'publication place (MARC21 260$a and 264§a)', > `lccn` longtext DEFAULT NULL COMMENT 'library of congress control number (MARC21 010$a)', > `url` mediumtext DEFAULT NULL COMMENT 'url (MARC21 856$u)', > `cn_source` varchar(10) DEFAULT NULL COMMENT 'classification source (MARC21 942$2)', >-- >2.30.2
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=152648">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 34029
:
152404
|
152417
|
152418
|
152490
|
152647
|
152648
|
152670
|
152671
|
152866