Problem with multiple joins to the same model

[karlisl]

QueryBuilder maps and returns data only from the last join:

$builder = $app->modelsManager->createBuilder()
        ->columns(array(
            'Jobs.*',
            'MasterRobot.*',
            'PeasantRobot.*'
        ))
        ->from('Jobs')
        ->leftJoin('Robots', 'MasterRobot.id = Jobs.master_robot_id', 'MasterRobot')
        ->leftJoin('Robots', 'PeasantRobot.id = Jobs.peasant_robot_id', 'PeasantRobot')
        ->getQuery()
        ->execute();

Generated query:

SELECT `jobs`.`id` AS `_jobs_id`, `jobs`.`master_robot_id` AS `_jobs_master_robot_id`, `jobs`.`peasant_robot_id` AS `_jobs_peasant_robot_id`, `jobs`.`title` AS `_jobs_title`, `PeasantRobot`.`id` AS `_PeasantRobot_id`, `PeasantRobot`.`name` AS `_PeasantRobot_name` FROM `jobs` LEFT JOIN `robots` AS `MasterRobot` ON `MasterRobot`.`id` = `jobs`.`master_robot_id`  LEFT JOIN `robots` AS `PeasantRobot` ON `PeasantRobot`.`id` = `jobs`.`peasant_robot_id`

You can see that MasterRobot columns are missing from SELECT block.

Returned data contains only PeasentRobot values:

...
[PeasantRobot] => Robots Object
        (
            [id] => 2
            [name] => Just Peasant
...

Also if you switch "MasterRobot" and "PeasantRobot" in createBuilder columns array, then returned data under the key "PeasentRobot" containts MasterRobot values:

...
[PeasantRobot] => Robots Object
        (
            [id] => 1
            [name] => Mister Chief
...

Robots model:

class Robots extends Model
{
    public $id;
    public $name;

    public function initialize() {
        $this->hasMany('id', 'Jobs', 'master_robot_id');
        $this->hasMany('id', 'Jobs', 'peasant_robot_id');
    }
}

Jobs model:

class Jobs extends Model
{
    public $id;
    public $master_robot_id;
    public $peasant_robot_id;

    public function initialize() {
        $this->belongsTo('master_robot_id', 'Robots', 'id', array('alias' => 'MasterRobot'));
        $this->belongsTo('peasant_robot_id', 'Robots', 'id', array('alias' => 'PeasantRobot'));
    }
}

Problem persists either relations are or aren't defined. Same thing happens when model aliases are present in relation definitions.

Tried in versions 1.2.4 and 1.3.0.

Update
Same thing with this:

$di = \Phalcon\DI::getDefault();
$mgr  = $di->get('modelsManager');
$phql = "
    SELECT Jobs.*, MasterRobot.*, PeasantRobot.*
        FROM Jobs AS Jobs
            LEFT JOIN Robots AS MasterRobot ON MasterRobot.id = Jobs.master_robot_id
            LEFT JOIN Robots AS PeasantRobot ON PeasantRobot.id = Jobs.peasant_robot_id
";

$mgr->executeQuery($phql);

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[maxgalbu]

This was already reported, see #2113