-
Bug
-
Resolution: Fixed
-
High
-
None
-
None
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
