@@ -, +, @@ MariaDB versions) --- .../bug_8367-add_holds_pickup_period_circrule.perl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) --- a/installer/data/mysql/atomicupdate/bug_8367-add_holds_pickup_period_circrule.perl +++ a/installer/data/mysql/atomicupdate/bug_8367-add_holds_pickup_period_circrule.perl @@ -2,8 +2,8 @@ $DBversion = 'XXX'; if( CheckVersion( $DBversion ) ) { $dbh->do(q{ INSERT INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value) - SELECT NULL, NULL, NULL, 'holds_pickup_period', '' - WHERE NOT EXISTS ( SELECT rule_name FROM circulation_rules where rule_name = 'holds_pickup_period' ) + SELECT u.* FROM (SELECT NULL as branchcode, NULL as categorycode, NULL as itemtype, 'holds_pickup_period' as rule_name, '' as rule_value) u + WHERE NOT EXISTS ( SELECT rule_name FROM circulation_rules where rule_name = 'holds_pickup_period' ); }); NewVersion( $DBversion, 8367, "Add holds_pickup_period circulation rule" ); --