You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Sandeep Pal (Jira)" <ji...@apache.org> on 2021/03/26 00:40:00 UTC

[jira] [Updated] (PHOENIX-6428) Join on columns with VARCHAR and CHAR types doesn't work

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

Sandeep Pal updated PHOENIX-6428:
---------------------------------
    Description: 
When doing the join on two tables on columns with VARCHAR and CHAR, the join condition doesn't work. 

Steps to reproduce:

CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID,));

CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID));

 

UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000000000000000');

UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000000000000000');

 

select * from test.table_varchar as T join test.table_with_char as S on S.ID=T.ID;

 

This returns empty.  

 

  was:
When doing the join on two tables on columns with VARCHAR and CHAR, the join condition doesn't work. 

Steps to reproduce:

CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID,));

CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID));

 

UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('ABC');

UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('ABC');

 

select * from test.table_varchar as T join test.table_with_char as S on S.ID=T.ID;

 

This returns empty.  

 


> Join on columns with VARCHAR and CHAR types doesn't work
> --------------------------------------------------------
>
>                 Key: PHOENIX-6428
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6428
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.14.3, 4.16.0, 4.17.0
>            Reporter: Sandeep Pal
>            Priority: Major
>
> When doing the join on two tables on columns with VARCHAR and CHAR, the join condition doesn't work. 
> Steps to reproduce:
> CREATE TABLE TEST.TABLE_WITH_VARCHAR (ID VARCHAR NOT NULL,CONSTRAINT PK PRIMARY KEY (ID,));
> CREATE TABLE TEST.TABLE_WITH_CHAR (ID CHAR(15) NOT NULL,CONSTRAINT PK PRIMARY KEY (ID));
>  
> UPSERT INTO TEST.TABLE_WITH_VARCHAR(ID) VALUES ('000000000000000');
> UPSERT INTO TEST.TABLE_WITH_CHAR(ID) VALUES ('000000000000000');
>  
> select * from test.table_varchar as T join test.table_with_char as S on S.ID=T.ID;
>  
> This returns empty.  
>  



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