Hello group.
I have this little query in a repo:
-- snip --
$dql = <<<EODQL
SELECT f
FROM Foo\BarBundle\Entity\Frog f
WHERE
f.id in (
SELECT distinct(i.frog)
FROM NTE\InventoryBundle\Entity\Item i
WHERE i.function = :itemfunction
)
EODQL;
$q = $this->_em->createQuery($dql);
$q->setParameter('itemfunction', $itemfunction);
return $q->getResult();
-- snip --
When there are no items with the itemfunction from the sub select, I end up
with these two:
PHP Warning: Illegal offset type in
doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php on line 601,
And
PHP Fatal error: Call to a member function getTableName() on a non-object in
doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php on line 602
Doctrine version (from composer.lock):
"name": "doctrine/dbal",
"version": "v2.4.2",
Symfony 2.4.1 (If that's of any interest)
So, is this just the stupid and wrong way to query or a bug?
Doing (well, close) this in SQL gives 0 rows and no error.
Thomas.
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/groups/opt_out.
