[
https://issues.apache.org/jira/browse/IGNITE-17997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17625170#comment-17625170
]
Konstantin Orlov edited comment on IGNITE-17997 at 10/27/22 3:06 PM:
---------------------------------------------------------------------
Yes in IGNITE-17996 the same rule about type inference is applied. You could
make an explicit cast to
varchar, though. This will do the trick.
Well, right now we don't have any plans to support different/custom collations,
but this may be subject to change in the future.
was (Author: korlov):
Yes in IGNITE-17996 the same rule about type inference is applied. You could
make an explicit cast to
varchar, though. This will do the trick.
> 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)
