Affects Version/s: 4.14.0
Fix Version/s: 4.14.0
It's related to the optimizations for group by that were made in
PHOENIX-3451. Test case to reproduce:
Execution result :
As we can see there is no client side sort, so it keeps the original order we get from server which is wrong.
That happens because of OrderPreservingTracker.hasEqualityConstraints decides that WHERE clause on ID column is constant and let us perform the optimization and skip the client side sort.
James R. Taylor, Chenglei any thoughts?