[PHOENIX-4283] Group By statement truncating BIGINTs

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.11.0
• Fix Version/s: 4.13.0
• Assignee: Ethan Wang
• Reporter: Steven Sadowski
• Created: 12/Oct/17 02:55
• Updated: 04/Nov/17 01:15
• Resolved: 19/Oct/17 21:51

Description

Versions:
Phoenix 4.11.0
HBase: 1.3.1
(Amazon EMR: 5.8.0)

Steps to reproduce:
1. From the `sqlline-thin.py` client setup the following table:

CREATE TABLE test_table (
    a BIGINT NOT NULL, 
    c BIGINT NOT NULL
    CONSTRAINT PK PRIMARY KEY (a, c)
);

UPSERT INTO test_table(a,c) VALUES(4444444444444444444, 5555555555555555555);

SELECT a FROM (SELECT a, c FROM test_table GROUP BY a, c) GROUP BY a, c;

Expected Result:

+----------------------+
|          A           |
+----------------------+
| 4444444444444444444  |
+----------------------+

Actual Result:

+----------------------+
|          A           |
+----------------------+
| 4444444444444000000  |
+----------------------+

Comments:
Having the two Group By statements together seems to truncate the last 6 or so digits of the final result. Removing the outer (or either) group by will produce the correct result.

Please fix the Group by statement to not truncate the outer result's value.