From d30a41e79147b29c22027e64fdf53e34d24bafe0 Mon Sep 17 00:00:00 2001 From: Angie Byron Date: Mon, 20 Apr 2009 02:23:17 +0000 Subject: Roll-back of #333054; needs more discussion. --- modules/simpletest/tests/database_test.test | 28 ---------------------------- 1 file changed, 28 deletions(-) (limited to 'modules/simpletest/tests/database_test.test') diff --git a/modules/simpletest/tests/database_test.test b/modules/simpletest/tests/database_test.test index b0b299215..a59e321aa 100644 --- a/modules/simpletest/tests/database_test.test +++ b/modules/simpletest/tests/database_test.test @@ -1995,34 +1995,6 @@ class DatabaseRegressionTestCase extends DatabaseTestCase { $this->assertTrue(db_table_exists('node'), t('Returns true for existent table.')); $this->assertFalse(db_table_exists('nosuchtable'), t('Returns false for nonexistent table.')); } - - /** - * Test that string comparison is case-sensitive. - */ - function testCaseSensitiviteCompare() { - $num_matches = db_query("SELECT COUNT(*) FROM {test} WHERE name = :name", array(':name' => 'George'))->fetchField(); - $this->assertEqual($num_matches, 1, t('Correct number of records found with proper case.')); - $num_matches = db_query("SELECT COUNT(*) FROM {test} WHERE name = :name", array(':name' => 'GEORGE'))->fetchField(); - $this->assertEqual($num_matches, 0, t('Correct number of records found with wrong case.')); - - $num_matches = db_query("SELECT COUNT(*) FROM {test} WHERE name LIKE :name", array(':name' => 'Geo%'))->fetchField(); - $this->assertEqual($num_matches, 1, t('Correct number of records found with proper case.')); - $num_matches = db_query("SELECT COUNT(*) FROM {test} WHERE name LIKE :name", array(':name' => 'GEO%'))->fetchField(); - $this->assertEqual($num_matches, 0, t('Correct number of records found with wrong case.')); - - $num_matches = db_select('test') - ->condition('name', 'Geo%', 'LIKE') - ->countQuery() - ->execute() - ->fetchField(); - $this->assertEqual($num_matches, 1, t('Correct number of records found with proper case.')); - $num_matches = db_select('test') - ->condition('name', 'GEO%', 'LIKE') - ->countQuery() - ->execute() - ->fetchField(); - $this->assertEqual($num_matches, 0, t('Correct number of records found with wrong case.')); - } } /** -- cgit v1.2.3