public function testSwitchingTheFieldOrder() { $query = new Doctrine_RawSql(); $query->parseQuery('SELECT {phonenumber.*}, {entity.name} FROM entity LEFT JOIN phonenumber ON phonenumber.entity_id = entity.id LIMIT 3'); $query->addComponent('entity', 'Entity'); $query->addComponent('phonenumber', 'Entity.Phonenumber'); $this->assertEqual($query->getSql(), 'SELECT entity.name AS entity__name, entity.id AS entity__id, phonenumber.id AS phonenumber__id, phonenumber.phonenumber AS phonenumber__phonenumber, phonenumber.entity_id AS phonenumber__entity_id FROM entity LEFT JOIN phonenumber ON phonenumber.entity_id = entity.id LIMIT 3'); $coll = $query->execute(array(), Doctrine::HYDRATE_ARRAY); $this->assertEqual(count($coll), 3); }