You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vyacheslav Koptilin (Jira)" <ji...@apache.org> on 2022/11/01 12:24:00 UTC

[jira] [Updated] (IGNITE-17997) Whitespaces at the end are ignored during string comparison

     [ https://issues.apache.org/jira/browse/IGNITE-17997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vyacheslav Koptilin updated IGNITE-17997:
-----------------------------------------
    Labels: ignite-3  (was: )

> 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
>              Labels: ignite-3
>
> 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)