From b0fb07d8bb6cb754f5a28a067101a970c1d46c66 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 6 Feb 2018 14:39:32 -0300 Subject: [PATCH] Bug 20144: [sql_modes] Fix values when creating a sql report in tests For fix: Data too long for column 'report_area' Incorrect integer value: 'null' for column 'cache_expiry' Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice --- t/db_dependent/Reports/Guided.t | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/t/db_dependent/Reports/Guided.t b/t/db_dependent/Reports/Guided.t index 0a2c734447..2de73402ee 100644 --- a/t/db_dependent/Reports/Guided.t +++ b/t/db_dependent/Reports/Guided.t @@ -186,19 +186,19 @@ subtest 'get_saved_reports' => sub { is( $count, 0, "There is no report" ); my @report_ids; - foreach ( 1..3 ) { + foreach my $ii ( 1..3 ) { my $id = $builder->build({ source => 'Borrower' })->{ borrowernumber }; push @report_ids, save_report({ borrowernumber => $id, sql => "SQL$id", name => "Name$id", - area => "area$id", + area => "area$ii", # ii vs id area is varchar(6) group => "group$id", subgroup => "subgroup$id", type => "type$id", notes => "note$id", - cache_expiry => "null", - public => "null" + cache_expiry => undef, + public => 0, }); $count++; } -- 2.14.2