Skip to content

Loading…

DDC-2532: Bring back LIMIT in DQL #3256

Closed
doctrinebot opened this Issue · 2 comments

2 participants

@doctrinebot

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

Comment created by @beberlei:

This impossible to support across all vendors, and therefore not an optoin for us.

@doctrinebot

Issue was closed with resolution "Invalid"

@beberlei beberlei was assigned by doctrinebot
@doctrinebot doctrinebot closed this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.