From 9f3ed54bddd49d1c22e111a3403bd155605efdd3 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 6 Feb 2018 13:27:32 -0300 Subject: [PATCH] Bug 20144: [sql_modes] Set default value for biblio.datecreated in tests Fix for: Field 'datecreated' doesn't have a default value Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice --- t/db_dependent/Creators/Lib.t | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/t/db_dependent/Creators/Lib.t b/t/db_dependent/Creators/Lib.t index 749c6a761e..248c4e76d9 100644 --- a/t/db_dependent/Creators/Lib.t +++ b/t/db_dependent/Creators/Lib.t @@ -148,8 +148,8 @@ my $author3 = 'Author 3'; $query = ' INSERT INTO biblio - (title, author) - VALUES (?,?)'; + (title, author, datecreated) + VALUES (?,?, NOW())'; $insert_sth = $dbh->prepare($query); $insert_sth->execute( $title1, $author1 ); $insert_sth->execute( $title2, undef ); -- 2.14.2