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

[Sandeep Pal (Jira)]

Sandeep Pal created PHOENIX-6428:
------------------------------------

             Summary: 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.16.0, 4.14.3, 4.17.0
            Reporter: Sandeep Pal


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.  

 



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