Doctrine

Timestamp:

03/19/08 04:58:51 (16 months ago)

Author:

jwage

Message:

Added failing test for aggregate with comma in it in the groupby

Files:

• branches/0.10/tests/RecordTestCase.php (modified) (1 diff)

branches/0.10/tests/RecordTestCase.php

@@ -894 +894 @@
         $this->assertEqual(count($user->Address), 1);
     }
+    
+    public function testAggregateWithCommaGroupBy()
+    {
+        try {
+            $query = Doctrine_Query::create()->from('EntityAddress e')->groupby('COALESCE(e.user_id, e.address_id)');
+            $this->assertEqual($query->getSql(), 'SELECT e.user_id AS e__user_id, e.address_id AS e__address_id FROM entity_address e GROUP BY COALESCE(e.user_id, e.address_id)');
+        } catch (Exception $e) {
+            $this->fail($e->getMessage());
+        }
+    }
 }