[PHOENIX-6339] Older client using aggregate queries shows incorrect results.

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 5.1.0, 4.16.0
• Fix Version/s: 5.1.0, 4.16.0
• Assignee: Kadir OZDEMIR
• Reporter: Jacob Isaac
• Created: 25/Jan/21 21:37
• Updated: 01/Feb/21 20:27
• Resolved: 27/Jan/21 20:41

Description

When running an older client for eg (4.15) against a 4.16 server
The output of aggregate queries are incorrect -

expected one row with the count, actual 9 rows with counts.

The 9 rows correspond to the number of regions in the data set. As shown in the explain plan.

Connected to: Phoenix (version 4.15)
Driver: PhoenixEmbeddedDriver (version 4.15)
Autocommit status: true
Transaction isolation: TRANSACTION_READ_COMMITTED
Building list of tables and columns for tab-completion (set fastconnect to true to skip)...
225/225 (100%) Done
Done
sqlline version 1.5.0
0: jdbc:phoenix:localhost> select count from BENCHMARK.BM_AGGREGATION_TABLE_2;
-----------

COUNT(1)

-----------

2389483
2319177
1958007
2389483
2319178
1958005
2233646
2249033
2183988

-----------
9 rows selected (6.56 seconds)
0: jdbc:phoenix:localhost> explain select count from BENCHMARK.BM_AGGREGATION_TABLE_2;
----------------------------------------------------------------------------------------------------------------------------------------------------------+

PLAN

EST_BYTES_READ

EST_ROWS_READ

EST_INFO_TS

----------------------------------------------------------------------------------------------------------------------------------------------------------+

CLIENT 9-CHUNK 10191406 ROWS 1887436990 BYTES PARALLEL 1-WAY FULL SCAN OVER BENCHMARK.BM_AGGREGATION_TABLE_2	1887436990	10191406	1611584394492
SERVER FILTER BY FIRST KEY ONLY	1887436990	10191406	1611584394492
SERVER AGGREGATE INTO SINGLE ROW	1887436990	10191406	1611584394492

----------------------------------------------------------------------------------------------------------------------------------------------------------+

Issue Links

• links to: GitHub Pull Request #1111