[
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)
