From c5df4dfb8914886e0b49be5736d5b891ec0364dd Mon Sep 17 00:00:00 2001
From: Nathan Gass
Date: Thu, 19 Jan 2023 19:23:44 +0100
Subject: add urbans tests

---
 test/it_dbi.t | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'test')

diff --git a/test/it_dbi.t b/test/it_dbi.t
index ac6d526..eef2632 100755
--- a/test/it_dbi.t
+++ b/test/it_dbi.t
@@ -203,6 +203,11 @@ $record->update(['z' => $value]);
 is($record->z, $value, "update 64bit integer without double representation");
 is($record->select(['z' => $value]), 1, "select 64bit integer without double representation");
 
+$record->update(['foo' => "10", 'x' => 10]);
+is($record->select(['x <' => 9]), 0, "always use integer comparision for int field");
+is($record->select(['x <' => '9']), 0, "always use integer comparision for int field");
+is($record->select(['foo <' => 9]), 1, "always use string comparision for varchar field");
+is($record->select(['foo <' => '9']), 1, "always use string comparision for varchar field");
 
 $record->update(['foo' => "00"]);
 $rand = $record->x;
-- 
cgit v1.2.3