New update() optimization: Optimize away 42 <=> "42"

1 files changed, 17 insertions, 2 deletions

diff --git a/tests/it_dbi.t b/tests/it_dbi.t
index 4a58188..ecd40e3 100755
--- a/tests/it_dbi.t
+++ b/tests/it_dbi.t
@@ -151,13 +151,28 @@ isnt(
 	"update with function"
 );
 
+$record->update(array('foo' => "00"));
 $rand = $record->x;
 is (
-	$record->_set(array('x' => $rand, 'foo' => "bar")),
-	"SET `foo`='bar'",
+	$record->_set(array('x' => $rand, 'foo' => "0")),
+	"SET `foo`='0'",
 	'update: _set optimization'
 );
 
+$record->update(array('foo' => NULL));
+is (
+	$record->_set('foo' => ""),
+	"SET `foo`=''",
+	'update: _set optimization with NULL => ""'
+);
+$record->update(array('foo' => "bar"));
+$record->update(array('foo' => ""));
+is (
+	$record->_set('foo' => NULL),
+	"SET `foo`=NULL",
+	'update: _set optimization with "" => NULL'
+);
+
 $record->update(array('foo' => "bar"));
 $record->select(array('foo' => "bar"));
 $record->iterate();