From efdf8cc9641f16c6cf3e7d4d7aebcbf22350863b Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Mon, 5 Feb 2018 14:51:43 -0300
Subject: [PATCH] Bug 20144: [sql_modes] Fix generated value for
 account_offsets.amount

Fix error:
Out of range value for column 'amount'

DBD::mysql::st execute failed: Out of range value for column 'amount' at
row 1 [for Statement "INSERT INTO `account_offsets` ( `amount`,
`debit_id`, `type`) VALUES ( ?, ?, ? )" with ParamValues:
0=7925469795795194609664.000000, 1='10', 2='Manual Debit'] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832.

7925469795795194609664.000000
=> Should be lower anyway

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 t/lib/TestBuilder.pm | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git a/t/lib/TestBuilder.pm b/t/lib/TestBuilder.pm
index d42cb03346..5937e0f664 100644
--- a/t/lib/TestBuilder.pm
+++ b/t/lib/TestBuilder.pm
@@ -473,6 +473,13 @@ sub _gen_default_values {
         Item => {
             more_subfields_xml => undef,
         },
+        Category => {
+            enrolmentfee => 0,
+            reservefee   => 0,
+        },
+        Itemtype => {
+            rentalcharge => 0,
+        },
     };
 }
 
-- 
2.39.5