[
https://issues.apache.org/jira/browse/CAY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrus Adamchik closed CAY-2967.
--------------------------------
Resolution: Fixed
> SQLTemplate/SQLSelect broken pagination
> ----------------------------------------
>
> Key: CAY-2967
> URL: https://issues.apache.org/jira/browse/CAY-2967
> Project: Cayenne
> Issue Type: Bug
> Affects Versions: 4.2.3
> Reporter: Andrus Adamchik
> Assignee: Andrus Adamchik
> Priority: Minor
> Fix For: 5.0-M3
>
>
> SQLTemplate/SQLSelect pagination is broken if the PK column is not the first
> one on the list of columns. So {{SELECT ARTIST_ID, ARTIST_NAME FROM ARTIST
> ORDER BY ARTIST_ID}} works while {{SELECT ARTIST_NAME, ARTIST_ID FROM ARTIST
> ORDER BY ARTIST_ID}} doesn't
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
