From bd40fd31b0efd2ad976075eceb926f15045fa8e1 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Mon, 1 Mar 2021 11:18:22 -0300 Subject: [PATCH] Bug 27808: (QA follow-up) Make sure the update catches the items we want This query: SELECT * FROM items LEFT JOIN issues ON issues.itemnumber=items.itemnumber WHERE items.onloan IS NULL; returns 961 rows on the sample data, with 2 items checked out and onloan set to NULL. With this tweak, the query only matches the 2 checkout items with onloan set to NULL: SELECT * FROM items LEFT JOIN issues ON issues.itemnumber=items.itemnumber WHERE items.onloan IS NULL AND issues.issue_id IS NOT NULL; This is the query that needs to be used on the atomic update for filtering the items to be updated. This patch does that. Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/atomicupdate/bug_27808.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_27808.perl b/installer/data/mysql/atomicupdate/bug_27808.perl index 0cf95a51580..ec8c233aaf0 100644 --- a/installer/data/mysql/atomicupdate/bug_27808.perl +++ b/installer/data/mysql/atomicupdate/bug_27808.perl @@ -5,7 +5,7 @@ if( CheckVersion( $DBversion ) ) { UPDATE items LEFT JOIN issues ON issues.itemnumber=items.itemnumber SET items.onloan=CAST(issues.date_due AS DATE) - WHERE items.onloan IS NULL + WHERE items.onloan IS NULL AND issues.issue_id IS NOT NULL |); NewVersion( $DBversion, 27808, "Adjust items.onloan if needed"); -- 2.30.1