From c0160f756aaee8f139c058936fafa9b887e8e67c Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Tue, 14 May 2019 13:17:01 +0100 Subject: [PATCH] Bug 22899: (QA follow-up) Ensure constraint is created Signed-off-by: Martin Renvoize --- .../bug_22899_add_items_constraint_to_tmpholdsqueue.perl | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_22899_add_items_constraint_to_tmpholdsqueue.perl b/installer/data/mysql/atomicupdate/bug_22899_add_items_constraint_to_tmpholdsqueue.perl index 1e14394955..79e8f41646 100644 --- a/installer/data/mysql/atomicupdate/bug_22899_add_items_constraint_to_tmpholdsqueue.perl +++ b/installer/data/mysql/atomicupdate/bug_22899_add_items_constraint_to_tmpholdsqueue.perl @@ -2,6 +2,11 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { # you can use $dbh here like: unless ( foreign_key_exists( 'tmp_holdsqueue', 'tmp_holdsqueue_ibfk_1' ) ) { + $dbh->do(q{ + DELETE t FROM tmp_holdsqueue t + LEFT JOIN items i ON t.itemnumber=i.itemnumber + WHERE i.itemnumber IS NULL + }); $dbh->do(q{ ALTER TABLE tmp_holdsqueue ADD CONSTRAINT `tmp_holdsqueue_ibfk_1` FOREIGN KEY (`itemnumber`) -- 2.20.1