Powpow Shen created PHOENIX-2799:
------------------------------------
Summary: dynamic column can not be used with "AS" alias in join
Key: PHOENIX-2799
URL: https://issues.apache.org/jira/browse/PHOENIX-2799
Project: Phoenix
Issue Type: Bug
Reporter: Powpow Shen
Join can be performed on dynamic columns, ex:
Say we have 2 tables created like this
{quote}
create table test1 ( id integer not null primary key, field1 varchar, field2
varchar);
create table test2 ( id integer not null primary key, field1 varchar, field2
varchar);
{quote}
Join 2 tables on dynamic colums can be done like this:
{quote}
select test1.id from test1(dynamic varchar) join test2(dynamic varchar) on
test1.dynamic = test2.dynamic;
{quote}
But syntax errors occur when alias is given to table name:
{quote}
select L.id from test1(dynamic varchar) as L join test2(dynamic varchar) as R
on L.dynamic = R.dynamic;
Error: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column 41.
(state=42P00,code=602)
{quote}
And in some cases, alias is required. for example: self join:
{quote}
select L.id from test1 as L join test1 as R on L.field1 = R.field2;
{quote}
works
{quote}
select L.id from test1(dynamic varchar) as L join test1(dynamic varchar) as R
on L.dynamic = R.dynamic;
{quote}
doesn't work
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
