From 8ebc03581c5de937dfa2aa1f3f4b7f77c3c225c1 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 6 Feb 2018 10:55:15 -0300 Subject: [PATCH] Bug 20144: [sql_modes] Set correct value for old_issues.issue_id in tests Fix for: Column 'issue_id' cannot be null Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice --- t/db_dependent/UsageStats.t | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/t/db_dependent/UsageStats.t b/t/db_dependent/UsageStats.t index 0391b355a9..2b33165985 100644 --- a/t/db_dependent/UsageStats.t +++ b/t/db_dependent/UsageStats.t @@ -294,8 +294,8 @@ sub construct_objects_needed { # ---------- Add 1 old_issues $query = ' INSERT INTO old_issues - (borrowernumber, branchcode, itemnumber) - VALUES (?,?,?)'; + (issue_id, borrowernumber, branchcode, itemnumber) + VALUES ((select coalesce(max(issue_id), 0)+1 from issues),?,?,?)'; $insert_sth = $dbh->prepare($query); $insert_sth->execute( $borrowernumber1, $branchcode, $item_number1 ); my $issue_id1 = $dbh->last_insert_id( undef, undef, 'old_issues', undef ); -- 2.14.2