Oracle Offset/Limit Queries Failing When "ID, *" Selected

XMLWordPrintable

      DVCS connector does something odd, selecting "ID, *" in its queries e.g.
      https://bitbucket.org/atlassian/jira-dvcs-connector/src/5a1d55788fa95a2f6b0553bbe229438ddb580877/jira-dvcs-connector-api/src/main/java/com/atlassian/jira/plugins/dvcs/util/ao/QueryTemplate.java?at=master#cl-292

      This results in queries that are unparseable with limit or offset e.g.

      SELECT
    *
FROM
    (
        SELECT
            queueItem."ID",
            queueItem.*
        FROM
            "AO_E8B6CC_MESSAGE_QUEUE_ITEM" queueItem
        JOIN
            "AO_E8B6CC_MESSAGE" MESSAGE
        ON
            QUEUEITEM."MESSAGE_ID" = MESSAGE."ID"
        WHERE
            MESSAGE."ADDRESS" = ?
        AND QUEUEITEM."QUEUE" = ?
        AND QUEUEITEM."STATE" = ?
        ORDER BY
            "MESSAGE"."PRIORITY" DESC ,
            "MESSAGE"."ID" ASC )
WHERE
    ROWNUM <= 1

            Assignee:
            ZehuaA
            Reporter:
            alex
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: