[jira] [Comment Edited] (IMPALA-1652) Fix CHAR datatype: Incorrect results with basic predicate on CHAR typed column.

["Tim Armstrong (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-1652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17177408#comment-17177408 ] 

Tim Armstrong edited comment on IMPALA-1652 at 8/14/20, 5:10 PM:
-----------------------------------------------------------------

http://databasearchitects.blogspot.com/2015/01/fun-with-char.html has some relevant discussion here. It does point out that approach 1 is commonly used but can be observably different from the SQL standard.


was (Author: tarmstrong):
http://databasearchitects.blogspot.com/2015/01/fun-with-char.html has some relevant discussion here.


> Fix CHAR datatype: Incorrect results with basic predicate on CHAR typed column.
> -------------------------------------------------------------------------------
>
>                 Key: IMPALA-1652
>                 URL: https://issues.apache.org/jira/browse/IMPALA-1652
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 2.1, Impala 2.3.0
>            Reporter: Alexander Behm
>            Priority: Major
>              Labels: correctness, downgraded, usability
>
> Repro:
> {code}
> create table foo(col1 char(10));
> insert into foo values (cast('test1' as char(10)));
> select * from foo where col1 = 'test1'; <-- returns an empty result set
> select * from foo where col1 = cast('test1' as char(10)); <-- correctly returns 1 row
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org