[
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)
