[jira] [Resolved] (CALCITE-5078) ORDER BY gets confused by upper/lower case

["Julian Hyde (Jira)" <ji...@apache.org>]

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

Julian Hyde resolved CALCITE-5078.
----------------------------------
    Resolution: Invalid

I'm marking this issue as invalid.

As others have noted, SQL has collations. If Calcite is sorting consistent with the collation, as it seems to be, then its behavior is correct. If it is incorrect, please re-open.

Can someone document here: 1. how to find out what the collation is for a particular column (even implicit columns as in this case), and 2. how to change the collation.

> ORDER BY gets confused by upper/lower case
> ------------------------------------------
>
>                 Key: CALCITE-5078
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5078
>             Project: Calcite
>          Issue Type: Bug
>    Affects Versions: 1.30.0
>            Reporter: Magnus Mogren
>            Priority: Major
>
> This SQL returnes the values in the wrong order:
> {{SELECT * FROM (VALUES ('a'), ('B')) AS tbl(col1) order by col1 asc}}
> "B" is returned before "a".
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)