[Bug] LOWER() does not work for non-english character in columns

[khaidot]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.1.8

What's Wrong?

When i do lower() for table columns with non-English character, the non-english part is not lowered, but if I do it manually (eg. select lower('ΔΛABc')) it works fine

What You Expected?

lowered character for non-english character

How to Reproduce?

CREATE TABLE testtable0 (
text varchar(30)
) ENGINE=OLAP
PROPERTIES (
"replication_allocation" = "tag.location.default: 2, tag.location.offline: 1");

insert into testtable0 values ('ΔΛABc');
insert into testtable0 values ('TEST');

select lower(text), text from testtable0

RETURNED RESULT
lower(text) text
ΔΛabc ΔΛABc
test TEST

but when I do select lower('ΔΛABc');

This is returned
δλabc

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[yiguolei]

@Mryange please take a look at this problem.

[yiguolei]

#49231 @khaidot This PR fixed the problem, it will be released on 2.1.10 version.