| | 89 | public function testSubQueryInJoins() |
| | 90 | { |
| | 91 | try { |
| | 92 | $q = new Doctrine_Query(); |
| | 93 | |
| | 94 | $q->from('Record_Country c') |
| | 95 | ->innerJoin('c.City c2 WITH (c2.name = ? OR c2.id IN (SELECT c3.id FROM Record_City c3 WHERE c3.id = ? OR c3.id = ?))'); |
| | 96 | $sql = $q->getSql(); |
| | 97 | $this->assertEqual($sql, '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 (r2.name = ? OR c2.id IN (SELECT c3.id FROM Record_City c3 WHERE c3.id = ? OR c3.id = ?))'); |
| | 98 | $this->pass(); |
| | 99 | } catch (Exception $e) { |
| | 100 | $this->fail($e->getMessage()); |
| | 101 | } |
| | 102 | } |
