[jira] [Created] (PHOENIX-2315) Group by fields of primary key columns together with non-primary key columns can give wrong result

[Alicia Ying Shu (JIRA)]

Alicia Ying Shu created PHOENIX-2315:
----------------------------------------

             Summary: Group by fields of primary key columns together with 
non-primary key columns can give wrong result
                 Key: PHOENIX-2315
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2315
             Project: Phoenix
          Issue Type: Bug
            Reporter: Alicia Ying Shu
            Assignee: Alicia Ying Shu


create table tgb_counter(tgb_id integer NOT NULL,utc_date_epoch integer NOT 
NULL,tgb_name varchar(40),ack_success_count integer,ack_success_one_ack_count 
integer, CONSTRAINT pk_tgb_counter PRIMARY KEY(tgb_id, utc_date_epoch)); 

SELECT tgb_id, tgb_name, (utc_date_epoch/10)*10 AS 
utc_epoch_hour,SUM(ack_success_count + ack_success_one_ack_count) AS ack_tx_sum 
FROM tgb_counter GROUP BY tgb_id, tgb_name, utc_epoch_hour;

tgb_name returns NULL.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)