query criteria - problem when more than 1 leftJoin()

[wojtek77]

For this code:

$result = Models\Uzytkownicy::query()
                ->leftJoin('Models\Testerzy')
                ->leftJoin('Models\Inzynierowie')
                ->execute();

is error: PhalconException: Scanning error before '] JOIN [] JOIN [...' when parsing: SELECT [Models\Uzytkownicy].* FROM [Models\Uzytkownicy] LEFT JOIN [Models\Testerzy] JOIN [] JOIN [] JOIN [] JOIN

When is this code:

$result = Models\Uzytkownicy::query()
                ->leftJoin('Models\Testerzy')
//                ->leftJoin('Models\Inzynierowie')
                ->execute();

is OK.

---

I use Phalcon 1.2.6 x86 on Windows 7 64 bit, Wamp 32 bit

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

[maxgalbu]

Here's the discussion about it:
http://forum.phalconphp.com/discussion/1479/multiple-joins-in-oo-notation-fail

A temporary solution is to use Phalcon\Mvc\Model\Query\Builder until this bug is fixed

[wojtek77]

Thank you for your quick response and I am sorry that I have already discussed the problem of previously reported.

[maxgalbu]

@wojtek77 sorry, my comment was just a temporary solution that i recommend to you until this bug is fixed
you can leave the issue open, so others can find it and see the status of the bug resolution

(tldr: please reopen it, this is actually a bug :-)