Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Invalid
    • Affects Version/s: 2.3.4
    • Fix Version/s: None
    • Component/s: DQL
    • Security Level: All
    • Labels:

      Description

      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.

        Activity

        Hide
        Benjamin Eberlei added a comment -

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

        Show
        Benjamin Eberlei added a comment - This impossible to support across all vendors, and therefore not an optoin for us.

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Stancsik Miklós
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: