[MCOL-735] String Manipulation Functions Either Returns Incorrect Resultsets or Cause Internal Error When Applied To Japanese Data Created: 2017-06-01 Updated: 2017-07-27 Resolved: 2017-07-27 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr |
| Affects Version/s: | None |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Minor |
| Reporter: | Yuichiro Kosila | Assignee: | Andrew Hutchings (Inactive) |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | community | ||
| Environment: |
Amazon EC2 , MariaDB ColumnStore AMI |
||
| Description |
|
(1) USASCII data seems not affected /* Test Code (Begin) */ |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2017-06-01 ] |
|
Hi Yuichiro, Whilst this won't solve all your issues did you set the system locale in Columnstore.xml as indicated near the end of this documentation?: https://mariadb.com/kb/en/mariadb/mariadb-columnstore-system-usage/ It may require a restart of ColumnStore afterwards but should at least resolve the TRIM, UPPER and SUBSTRING. LENGTH is known to not work for UTF-8 but I'm not sure if this is documented, we can resolve this as part of this ticket. We do intend to improve our multi-byte handling in future versions, especially around collations and getting the current information from MariaDB Server about the session. |
| Comment by Yuichiro Kosila [ 2017-07-25 ] |
|
First of all, my deep apologies being silent from this issue for a long time. 1) 2) 3) 4) Therefore, this incident is not even a bug, solely the lack of my preparation.... LENGTH() function gives back the length in unit of bytes, but since Once again, thank you for your valueable inputs, and let us close this issue. |
| Comment by Andrew Hutchings (Inactive) [ 2017-07-27 ] |
|
Based on previous comment, closing as "Not a Bug". Many thanks for your input. |