Bug 18936: (follow-up) fix tests, null vs. empty behavior for limiting rules

[koha-ffzg.git] / installer / data / mysql / atomicupdate / bug_18936.perl

diff --git a/installer/data/mysql/atomicupdate/bug_18936.perl b/installer/data/mysql/atomicupdate/bug_18936.perl
index b420fce..935f718 100644 (file)
--- a/installer/data/mysql/atomicupdate/bug_18936.perl
+++ b/installer/data/mysql/atomicupdate/bug_18936.perl
@@ -27,13 +27,15 @@ if( CheckVersion( $DBversion ) ) {
         onshelfholds
         opacitemholds
         article_requests
+        maxissueqty
+        maxonsiteissueqty
     );
 
     if ( column_exists( 'issuingrules', 'categorycode' ) ) {
         foreach my $column ( @columns ) {
             $dbh->do("
                 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
-                SELECT categorycode, branchcode, itemtype, \'$column\', $column
+                SELECT categorycode, branchcode, itemtype, \'$column\', COALESCE( $column, '' )
                 FROM issuingrules
             ");
         }