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

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

Andrey Khitrin created IGNITE-17997:
---------------------------------------

             Summary: 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
    Affects Versions: 3.0.0-beta1
            Reporter: Andrey Khitrin


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)