From 3ba39c132ff157c3e758ea42e861b92db2c19e7a Mon Sep 17 00:00:00 2001
From: Dries <dries@buytaert.net>
Date: Wed, 21 Dec 2011 14:52:05 -0500
Subject: - Patch #1258000 by chx, xjm, bfroehle: SelectQuery::countQuery()
 inappropriately removes SQL expressions.

---
 modules/simpletest/tests/database_test.test | 10 ++++++++++
 1 file changed, 10 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 87d386aa7..4d3a86886 100644
--- a/modules/simpletest/tests/database_test.test
+++ b/modules/simpletest/tests/database_test.test
@@ -2062,6 +2062,16 @@ class DatabaseSelectComplexTestCase extends DatabaseTestCase {
     $this->assertEqual($record->$age_field, 27, t('Correct data retrieved.'));
   }
 
+  function testHavingCountQuery() {
+    $query = db_select('test')
+      ->extend('PagerDefault')
+      ->having('age + 1 > 0');
+    $query->addField('test', 'age');
+    $query->addExpression('age + 1');
+    $count = count($query->execute()->fetchCol());
+    $this->assertEqual($count, 4, t('Counted the correct number of records.'));
+  }
+
   /**
    * Test that countQuery properly removes 'all_fields' statements and
    * ordering clauses.
-- 
cgit v1.2.3