phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maryann Xue (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4615) Anonymous derived table causes NPE in join queries
Date Fri, 16 Feb 2018 18:19:00 GMT
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)

Mime
View raw message