From a7f6efc8a14efb0a553aae313cb63ea404618add Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sat, 8 Nov 2008 22:52:24 +0000
Subject: - Patch #329080 by chx, Damien Tournoud, pwolanin: statics in objects
 are not per-instance.

---
 modules/simpletest/tests/database_test.test | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

(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 5656dc740..118e19448 100644
--- a/modules/simpletest/tests/database_test.test
+++ b/modules/simpletest/tests/database_test.test
@@ -1043,6 +1043,28 @@ class DatabaseSelectTestCase extends DatabaseTestCase {
     $this->assertEqual($record->$age_field, 27*2, t('Fetched age expression is correct.'));
   }
 
+  /**
+   * 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.
    */
-- 
cgit v1.2.3