[DRILL-3226] Upper and lower casing doesn't work correctly on non-ASCII characters

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Ted Dunning
• Created: 31/May/15 11:38
• Updated: 28/Aug/18 17:50

Description

0: jdbc:drill:zk=local> select z, lower(z), upper(z) from dfs.root.`/Users/tdunning/tmp/data.json`;
+------+---------+---------+
|  z   | EXPR$1  | EXPR$2  |
+------+---------+---------+
| åäö  | åäö     | åäö     |
| aBc  | abc     | ABC     |
+------+---------+---------+

Expected result would be

+------+---------+---------+
|  z   | EXPR$1  | EXPR$2  |
+------+---------+---------+
| åäö  | åäö     | ÅÄÖ     |
| aBc  | abc     | ABC     |
+------+---------+---------+

Issue Links

• is duplicated by: DRILL-6717 lower and upper functions not works with national charactes