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)