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

Sandeep Pal updated PHOENIX-6428:
---------------------------------
    Summary: Phoenix select subquery doesn't work on VARCHAR and CHAR types  
(was: Join on columns with VARCHAR and CHAR types doesn't work)

> Phoenix select subquery doesn't work on VARCHAR and CHAR types
> --------------------------------------------------------------
>
>                 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)

Reply via email to