From 4947ee2a528ebdb4c60ad96772bb9d2ae76a3e33 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 5 Feb 2018 18:23:59 -0300 Subject: [PATCH] Bug 20144: [sql_modes] Correct quotes.timestamp values in tests Fix for: Incorrect datetime value: '0000-00-00 00:00:00' for column 'timestamp' t/db_dependent/Koha.t Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice --- t/db_dependent/Koha.t | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/t/db_dependent/Koha.t b/t/db_dependent/Koha.t index 64bb045cde..4e814a0738 100644 --- a/t/db_dependent/Koha.t +++ b/t/db_dependent/Koha.t @@ -173,15 +173,15 @@ SKIP: # Fill the quote table with the default needed and a spare $dbh->do("DELETE FROM quotes WHERE id=3 OR id=25;"); my $sql = "INSERT INTO quotes (id,source,text,timestamp) VALUES -(25,'Richard Nixon','When the President does it, that means that it is not illegal.','0000-00-00 00:00:00'), -(3,'Abraham Lincoln','Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.','0000-00-00 00:00:00');"; +(25,'Richard Nixon','When the President does it, that means that it is not illegal.',NOW()), +(3,'Abraham Lincoln','Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',NOW());"; $dbh->do($sql); my $expected_quote = { id => 3, source => 'Abraham Lincoln', text => 'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.', - timestamp => re('\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}'), #'0000-00-00 00:00:00', + timestamp => re('\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}'), #'YYYY-MM-DD HH:MM:SS' }; # test quote retrieval based on id -- 2.14.2