[ASTERIXDB-2734] Hash Group by broken for min and max

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.5
• Component/s: RT - Runtime, SQL - Translator SQL++
• Assignee: Dmitry Lychagin
• Reporter: Gift Sinthong
• Created: 13/May/20 23:19
• Updated: 13/May/20 23:22

Description

1. SELECT twenty, MIN(four) AS max_four FROM wisconsin1 t /*+ hash */ GROUP BY twenty;

2. SELECT twenty, SUM(four) AS max_four FROM wisconsin1 t /*+ hash */ GROUP BY twenty;

This first query uses sort group by even when 'hash' is given as a hint but the second query is using hash group by. At best, this is confusing to users.