mirror of
https://github.com/doctrine/orm.git
synced 2026-03-23 22:42:18 +01:00
DDC-2532: Bring back LIMIT in DQL #3173
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @doctrinebot on GitHub (Jun 27, 2013).
Originally assigned to: @beberlei on GitHub.
Jira issue originally created by user jumika:
Hi!
I want to use limit in dql. Consider the following query:
SELECT p FROM Products p
INNER JOIN p.prices price
WITH price =
(SELECT prc FROM Prices prc
WHERE prc.from < :time
AND prc.product = p
ORDER BY prc.from desc)
WHERE p.id IN(:product_ids)
I want it to use like this:
SELECT p FROM Products p
INNER JOIN p.prices price
WITH price =
(SELECT prc FROM Prices prc
WHERE prc.from < :time
AND prc.product = p
ORDER BY prc.from desc
LIMIT 1)
WHERE p.id IN(:product_ids)
I think it doesn't need further explanation.
@doctrinebot commented on GitHub (Jun 27, 2013):
Comment created by @beberlei:
This impossible to support across all vendors, and therefore not an optoin for us.
@doctrinebot commented on GitHub (Jun 27, 2013):
Issue was closed with resolution "Invalid"