summaryrefslogtreecommitdiff
path: root/modules/simpletest/tests/database_test.test
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2008-11-08 22:52:24 +0000
committerDries Buytaert <dries@buytaert.net>2008-11-08 22:52:24 +0000
commita7f6efc8a14efb0a553aae313cb63ea404618add (patch)
tree2b58334bfbd5a08315217e3f01512a56695b78c9 /modules/simpletest/tests/database_test.test
parent50b3072f5577849a37cfe8e38f49d839fd15eaf0 (diff)
downloadbrdo-a7f6efc8a14efb0a553aae313cb63ea404618add.tar.gz
brdo-a7f6efc8a14efb0a553aae313cb63ea404618add.tar.bz2
- Patch #329080 by chx, Damien Tournoud, pwolanin: statics in objects are not per-instance.
Diffstat (limited to 'modules/simpletest/tests/database_test.test')
-rw-r--r--modules/simpletest/tests/database_test.test22
1 files changed, 22 insertions, 0 deletions
diff --git a/modules/simpletest/tests/database_test.test b/modules/simpletest/tests/database_test.test
index 5656dc740..118e19448 100644
--- a/modules/simpletest/tests/database_test.test
+++ b/modules/simpletest/tests/database_test.test
@@ -1044,6 +1044,28 @@ class DatabaseSelectTestCase extends DatabaseTestCase {
}
/**
+ * Test SELECT statements with multiple expressions.
+ */
+ function testSimpleSelectExpressionMultiple() {
+ $query = db_select('test');
+ $name_field = $query->addField('test', 'name');
+ $age_double_field = $query->addExpression("age*2");
+ $age_triple_field = $query->addExpression("age*3");
+ $query->condition('age', 27);
+ $result = $query->execute();
+
+ // Check that the aliases are being created the way we want.
+ $this->assertEqual($age_double_field, 'expression', t('Double age field alias is correct.'));
+ $this->assertEqual($age_triple_field, 'expression_2', t('Triple age field alias is correct.'));
+
+ // Ensure that we got the right record.
+ $record = $result->fetch();
+ $this->assertEqual($record->$name_field, 'George', t('Fetched name is correct.'));
+ $this->assertEqual($record->$age_double_field, 27*2, t('Fetched double age expression is correct.'));
+ $this->assertEqual($record->$age_triple_field, 27*3, t('Fetched triple age expression is correct.'));
+ }
+
+ /**
* Test adding multiple fields to a select statement at the same time.
*/
function testSimpleSelectMultipleFields() {