| | 76 | |
| | 77 | public function testQueryAggFunctionInJoins() |
| | 78 | { |
| | 79 | $q = new Doctrine_Query(); |
| | 80 | |
| | 81 | $q->select('c.*, c2.*, d.*') |
| | 82 | ->from('Record_Country c') |
| | 83 | ->innerJoin('c.City c2 WITH LOWER(c2.name) LIKE LOWER(?)', array('city 1')) |
| | 84 | ->where('c.id = ?', array(1)); |
| | 85 | |
| | 86 | $this->assertEqual($q->getSql(), 'SELECT r.id AS r__id, r.name AS r__name, r2.id AS r2__id, r2.name AS r2__name, r2.country_id AS r2__country_id, r2.district_id AS r2__district_id FROM record__country r INNER JOIN record__city r2 ON r.id = r2.country_id AND LOWER(r2.name) LIKE LOWER(?) WHERE r.id = ?'); |
| | 87 | } |
| | 88 | |
| | 89 | |
