[
https://issues.apache.org/jira/browse/TAJO-1453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14383168#comment-14383168
]
Keuntae Park commented on TAJO-1453:
------------------------------------
Tajo typically follows the way of PostgreSQL on SQL parsing and PostgreSQL also
does not support the table name with parentheses.
{code}
mydb=# select * from test join test2 on test.value = test2.name;
value | num | name | num
-------+-----+------+-----
abc | 1 | abc | 3
(1 row)
mydb=# select * from test join (test2) on test.value = test2.name;
ERROR: syntax error at or near ")"
{code}
In my thought, PostgreSQL does not allow table name with parentheses not to be
confused with columns of composite type,
http://www.postgresql.org/docs/9.4/static/rowtypes.html
> sql parse error occured with join query
> ---------------------------------------
>
> Key: TAJO-1453
> URL: https://issues.apache.org/jira/browse/TAJO-1453
> Project: Tajo
> Issue Type: Bug
> Components: parser
> Affects Versions: 0.10.0
> Reporter: Jungryong Lee
> Priority: Minor
>
> It is simple parse error.
> I am testing Tajo with BI solution, Birst.
> Birst usually generate join query like following:
> select table1.* from table1 inner join (table2) on (table1.id = table2.id);
> If "table2" has parenthesis, Tajo displays follwing error:
> ERROR: syntax error at or near 'table2'
> I didn't check ANSI SQL doesn't allow parenthesis in this case.
> But Almost databases I evaluated support this case.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
