Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Query with joins returns null when client is v4.8.0 and server is 4.x head with https://github.com/apache/phoenix/pull/232 and https://issues.apache.org/jira/browse/PHOENIX-3678 patch applied.
CREATE TABLE Employee ( Region VARCHAR NOT NULL, LocalID VARCHAR NOT NULL, Name VARCHAR, CONSTRAINT pk PRIMARY KEY (Region, LocalID)); CREATE TABLE Patent ( PatentID VARCHAR NOT NULL, Region VARCHAR, LocalID VARCHAR, Title VARCHAR, Category VARCHAR, CONSTRAINT pk PRIMARY KEY (PatentID)); upsert into employee values ('region1','local1','foo'); upsert into patent values ('patent1', 'region1','local1','title1','cat1'); SELECT E.Name, E.Region, P.PCount FROM Employee AS E JOIN (SELECT Region, LocalID, count(*) AS PCount FROM Patent GROUP BY Region, LocalID) AS P ON E.Region = P.Region AND E.LocalID = P.LocalID;
Resultset returns
+---------+-----------+-----------+ | E.NAME | E.REGION | P.PCOUNT | +---------+-----------+-----------+ | | region1 | null | +---------+-----------+-----------+