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/25 23:27:00 UTC
[jira] [Created] (PHOENIX-6428) Join on columns with VARCHAR and
CHAR types doesn't work
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)