From 9888e8884e7142509d28575c8c97854f6357d6bd Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 28 Apr 2011 06:02:43 -0400 Subject: - Patch #1139638 by DamZ: the SQLite driver cannot update a column to NULL. --- modules/simpletest/tests/database_test.test | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'modules/simpletest/tests') diff --git a/modules/simpletest/tests/database_test.test b/modules/simpletest/tests/database_test.test index 2a086ceed..231355ceb 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -718,6 +718,21 @@ class DatabaseUpdateTestCase extends DatabaseTestCase { $this->assertIdentical($saved_name, 'Tiffany', t('Updated name successfully.')); } + /** + * Confirm updating to NULL. + */ + function testSimpleNullUpdate() { + $this->ensureSampleDataNull(); + $num_updated = db_update('test_null') + ->fields(array('age' => NULL)) + ->condition('name', 'Kermit') + ->execute(); + $this->assertIdentical($num_updated, 1, t('Updated 1 record.')); + + $saved_age = db_query('SELECT age FROM {test_null} WHERE name = :name', array(':name' => 'Kermit'))->fetchField(); + $this->assertNull($saved_age, t('Updated name successfully.')); + } + /** * Confirm that we can update a multiple records successfully. */ -- cgit v1.2.3