From 569aaa65f5523069adb748715e36c9e3cba3992d Mon Sep 17 00:00:00 2001
From: Nathan Gass
Date: Tue, 28 Feb 2023 18:57:33 +0100
Subject: adapt escaping of ints and floats to better handle booleans and
 strings as input

---
 test/it_dbi.t | 11 +++++++----
 1 file changed, 7 insertions(+), 4 deletions(-)

(limited to 'test')

diff --git a/test/it_dbi.t b/test/it_dbi.t
index ff0303a..356a093 100755
--- a/test/it_dbi.t
+++ b/test/it_dbi.t
@@ -174,11 +174,14 @@ is(
 	"update"
 );
 
-$record->update(['flag' => 1]);
-is($record->flag, true, "use integer 1 to set flag to true");
+$record->update(['flag' => "astring"]);
+is($record->flag, 0, "use non-numeric string to set tinyint flag");
 
-$record->update(['flag' => 0]);
-is($record->flag, false, "use integer 0 to set flag to false");
+$record->update(['flag' => true]);
+is($record->flag, 1, "use boolean true to set tinyint flag");
+
+$record->update(['flag' => false]);
+is($record->flag, 0, "use boolean false to set tinyint flag");
 
 is(
 	$record->update(['x' => 18], ['x' => 17]),
-- 
cgit v1.2.3