[#MCOL-1426] Using lower/upper on a value with special characters returns null

[MCOL-1426] Using lower/upper on a value with special characters returns null Created: 2018-05-18 Updated: 2019-07-10 Resolved: 2019-07-10
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	?
Affects Version/s:	1.1.4
Fix Version/s:	Icebox

Type:

Bug

Priority:

Trivial

Reporter:

Dalu (Inactive)

Assignee:

Unassigned

Resolution:

Not a Bug

Votes:

Labels:

None

Description

CREATE TABLE `testtable` (
`id` int(11) NOT NULL,
`name` varchar(80) NOT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;

insert into testtable value (1, "tüst");

select id, name, lower(name) from (testtable);

returns:
1, tüst, null

Comments

Comment by Dalu (Inactive) [ 2018-05-21 ]

Issue is solved, <SystemLang>en_US.utf8</SystemLang> wasn't set correctly

Generated at Thu Feb 08 02:28:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.