[BUG] В QueryBuilder не работает DISTINCT

[scarbo87]

$this->modelsManager->createBuilder()
->distinct(true)
->columns([ 'pt.*'])
->addFrom('Pin\Model\PinsTags', 'pt')
->getQuery()
->execute();
SQL Statement: SELECT pins_tags.id, pins_tags.pin_id, pins_tags.tag_id FROM pins_tags

$phql = 'SELECT DISTINCT [Pin\Model\PinsTags].* FROM [Pin\Model\PinsTags]';
$this->modelsManager->executeQuery($phql);
SQL Statement: SELECT pins_tags.id, pins_tags.pin_id, pins_tags.tag_id FROM pins_tags

Судя по коду - https://github.com/phalcon/cphalcon/blob/master/ext/mvc/model/query/builder.c#L1525
если передавать true/false, то на выходе получим SELECT DISTINCT/SELECT ALL, но чтобы я туда не передавал, на выходе только SELECT.

[dreamsxin]

Could you try again compiling from the 1.3.2 branch?

[scarbo87]

Thank you, in 1.3.2 branch DISTINCT it works.
Example:
$this->modelsManager->createBuilder()
->distinct(true)
->columns('t.*')
->addFrom('Pin\Model\Tags', 't')
->join('Pin\Model\PinsTags', null, 'pt')
->join('Pin\Model\Pins', 'p.id = pt.pin_id', 'p')
->where('p.status = 1')
->orderBy('t.weight')
->getQuery()
->execute();
SQL Statement: SELECT DISTINCT t.id, t.slug, t.name, t.weight, t.created_at, t.changed_at FROM tags AS t INNER JOIN pins_tags AS pt ON t.id = pt.tag_id INNER JOIN pins AS p ON p.id = pt.pin_id WHERE p.status = 1 ORDER BY t.weight

$phql = 'SELECT DISTINCT [Pin\Model\PinsTags].* FROM [Pin\Model\PinsTags]';
$this->modelsManager->executeQuery($phql);
SQL Statement: SELECT DISTINCT pins_tags.id, pins_tags.pin_id, pins_tags.tag_id FROM pins_tags

[flinux]

Nice work guys! I was waiting for the resolution of this problem 👍