You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Nikita Timofeev (Jira)" <ji...@apache.org> on 2024/05/10 12:34:00 UTC

[jira] [Updated] (CAY-2842) Prevent duplicate select columns when using distinct with order by

     [ https://issues.apache.org/jira/browse/CAY-2842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nikita Timofeev updated CAY-2842:
---------------------------------
    Fix Version/s: 5.0-M1

> Prevent duplicate select columns when using distinct with order by
> ------------------------------------------------------------------
>
>                 Key: CAY-2842
>                 URL: https://issues.apache.org/jira/browse/CAY-2842
>             Project: Cayenne
>          Issue Type: Improvement
>          Components: Core Library
>    Affects Versions: 4.2
>            Reporter: Jurgen Doll
>            Priority: Minor
>              Labels: pull-request-available
>             Fix For: 5.0-M1
>
>          Time Spent: 7h 10m
>  Remaining Estimate: 0h
>
> When a "select distinct" query has an "order by" clause then the "order by" fields must also be listed in the select clause. However no check is currently done to see if the column is already specified which can result in duplicate columns being fetched.
> This is listed as a TODO item in OrderingStage.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)