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

["Benchao Li (Jira)" <ji...@apache.org>]

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

Benchao Li updated CALCITE-5078:
--------------------------------
    Docs Text: 
SqlCollation is an object representing a collate statement.
It can be set for RelDataType, especially for string types. You can get current RelDataType's SqlCollation by invoking RelDataType#getCollation.
If you want to use a special SqlCollation, you can create the RelDataType by RelDataTypeFactory#createTypeWithCharsetAndCollation, and pass your own SqlCollation.

> 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)