From 06f31080c7281c8227d2556cd0807744e91c9fb5 Mon Sep 17 00:00:00 2001 From: webchick Date: Sat, 10 Dec 2011 23:29:21 -0600 Subject: Issue #813540 by jbrown, chx: Fixed Comparisons involving NULL must never return true. --- modules/simpletest/tests/database_test.test | 18 ++++++++++++++++-- 1 file changed, 16 insertions(+), 2 deletions(-) (limited to 'modules') diff --git a/modules/simpletest/tests/database_test.test b/modules/simpletest/tests/database_test.test index 87d386aa7..91a51f361 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -1454,11 +1454,25 @@ class DatabaseSelectTestCase extends DatabaseTestCase { } /** - * Test that we can find a record with a NULL value. + * Test that a comparison with NULL is always FALSE. */ function testNullCondition() { $this->ensureSampleDataNull(); + $names = db_select('test_null', 'tn') + ->fields('tn', array('name')) + ->condition('age', NULL) + ->execute()->fetchCol(); + + $this->assertEqual(count($names), 0, t('No records found when comparing to NULL.')); + } + + /** + * Test that we can find a record with a NULL value. + */ + function testIsNullCondition() { + $this->ensureSampleDataNull(); + $names = db_select('test_null', 'tn') ->fields('tn', array('name')) ->isNull('age') @@ -1471,7 +1485,7 @@ class DatabaseSelectTestCase extends DatabaseTestCase { /** * Test that we can find a record without a NULL value. */ - function testNotNullCondition() { + function testIsNotNullCondition() { $this->ensureSampleDataNull(); $names = db_select('test_null', 'tn') -- cgit v1.2.3