[IMPALA-4599] qgen: improve DML statement comparison validation

• Type: Task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 2.7.0
• Component/s: Infrastructure
• Labels: query_generator query_generator_development
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Michael Brown
• Created: 06/Dec/16 22:00
• Updated: 28/Sep/17 19:50

Description

The random query generator needs to have its DML correctness algorithm improved. It's not simply enough to count the rows, or even compare all the rows: there's no guarantee a conflicted INSERTed or UPSERTed row in one database will match that in the other database, though the primary keys should always match. In cases where the primary key matches but the rows of the other columns differ, we have to have known if the values in the other columns were part of a set of rows attempted to be inserted/upserted.