Maksim Zhuravkov created IGNITE-22472:
-----------------------------------------
Summary: Sql. Char. Inconsistent handling of comparison operation.
Key: IGNITE-22472
URL: https://issues.apache.org/jira/browse/IGNITE-22472
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Maksim Zhuravkov
Consider the following example (all test cases pass):
{noformat}
query T
SELECT 'a'::char(1) < 'a'::char(2)
----
true
query T
SELECT 'a'::char(2) > 'a'::char(1)
----
true
query T
SELECT 'a'::char(1) = 'a'::char(2)
----
true
{noformat}
A closer look:
{noformat}
query TT
SELECT 'a'::char(1) < 'a'::char(2), 'a'::char(2) > 'a'::char(1)
----
true true
Plan:
Project(EXPR$0=[<(_UTF-8'a', _UTF-8'a ')], EXPR$1=[>(_UTF-8'a ', _UTF-8'a')])
Values(tuples=[[{ 0 }]])
query TT
SELECT 'a'::char(1) = 'a'::char(2), 'a'::char(1) != 'a'::char(2)
----
true false
Plan:
Values(tuples=[[{ true, false }]])
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
