From 255b45b8900fed7aab59c37b0847e5936bf62e54 Mon Sep 17 00:00:00 2001
From: Christian Schneider
Date: Thu, 10 May 2012 13:21:26 +0000
Subject: New update() optimization: Optimize away 42 <=> "42"

---
 tests/it_dbi.t | 19 +++++++++++++++++--
 1 file changed, 17 insertions(+), 2 deletions(-)

(limited to 'tests')

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();
-- 
cgit v1.2.3