[FLINK-17944] Wrong output in sql client's table mode

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Fix Version/s: 1.11.0
• Component/s: Table SQL / Client
• Labels: pull-request-available
• Assignee: Jeff Zhang
• Reporter: Jeff Zhang
• Created: 26/May/20 13:53
• Updated: 10/Jun/20 09:45
• Resolved: 10/Jun/20 09:45

Description

When I run the following sql example, I get the wrong output

SELECT name, COUNT(*) AS cnt FROM (VALUES ('Bob'), ('Alice'), ('Greg'), ('Bob')) AS NameTable(name) GROUP BY name; 

 

                      Bob                         1
                     Alice                         1
                      Greg                         1
                       Bob                         2 

This is due to we add kind in Row, so the sematics of equals method changes

Issue Links

• links to: GitHub Pull Request #12346