add urbans tests

1 files changed, 5 insertions, 0 deletions

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;