Maryann Xue created PHOENIX-4615:
------------------------------------
Summary: Anonymous derived table causes NPE in join queries
Key: PHOENIX-4615
URL: https://issues.apache.org/jira/browse/PHOENIX-4615
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.13.0
Reporter: Maryann Xue
Assignee: Maryann Xue
{code}
SELECT * FROM (
SELECT A, B, C, D FROM T2
WHERE T2.A IN ('A','G') and T2.B = 'A' and T2.D = 'D'
)
RIGHT JOIN T1 ON T2.A = T1.A
WHERE T1.A = 'B' and T1.C='C'
{code}
causes NPE in JoinCompiler, but
{code}
SELECT * FROM (
SELECT A, B, C, D FROM T2
WHERE T2.A IN ('A','G') and T2.B = 'A' and T2.D = 'D'
) T2
RIGHT JOIN T1 ON T2.A = T1.A
WHERE T1.A = 'B' and T1.C='C'
{code}
is fine.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
