[ https://issues.apache.org/jira/browse/IGNITE-17997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17625538#comment-17625538 ]
Andrey Khitrin commented on IGNITE-17997: ----------------------------------------- Thank you, I see expected behavior with `VARCHAR`: {code:sql} sql-cli> select cast('a' AS VARCHAR) = cast('a' AS VARCHAR) as test; ╔═════════╗ ║ TEST ║ ╠═════════╣ ║ true ║ ╚═════════╝ sql-cli> select cast('a' AS VARCHAR) = cast('a ' AS VARCHAR) as test; ╔═════════╗ ║ TEST ║ ╠═════════╣ ║ false ║ ╚═════════╝ {code} > Whitespaces at the end are ignored during string comparison > ----------------------------------------------------------- > > Key: IGNITE-17997 > URL: https://issues.apache.org/jira/browse/IGNITE-17997 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 3.0.0-beta1 > Reporter: Andrey Khitrin > Priority: Major > > In 3.0.0-Beta-1: > {code:java} > sql-cli> select 'a' = 'a' as t1, 'a' = 'b' as t2, 'a' = 'a ' as t3, 'a' = ' > a' as t4; > ╔══════╤═══════╤══════╤═══════╗ > ║ T1 │ T2 │ T3 │ T4 ║ > ╠══════╪═══════╪══════╪═══════╣ > ║ true │ false │ true │ false ║ > ╚══════╧═══════╧══════╧═══════╝ > {code} > Tests T1, T2, and T4 show correct behavior. But in test T2 we see that string > 'a' is considered being equal to string 'a ' (same string but with > arbitrary amount of whitespaces at the end). This is incorrect behavior. > This issue may have the same nature as IGNITE-17996, but it's just a > hypothesis. -- This message was sent by Atlassian Jira (v8.20.10#820010)