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