diff options
Diffstat (limited to 'tests')
| -rwxr-xr-x | tests/it_dbi.t | 19 |
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(); |