You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "Jeff Zhang (Jira)" <ji...@apache.org> on 2020/05/26 13:54:00 UTC

[jira] [Created] (FLINK-17944) Wrong output in sql client's table mode

Jeff Zhang created FLINK-17944:
----------------------------------

             Summary: Wrong output in sql client's table mode
                 Key: FLINK-17944
                 URL: https://issues.apache.org/jira/browse/FLINK-17944
             Project: Flink
          Issue Type: Improvement
          Components: Table SQL / Client
    Affects Versions: 1.11.0
            Reporter: Jeff Zhang


When I run the following sql example, I get the wrong output
{code:java}

SELECT name, COUNT(*) AS cnt FROM (VALUES ('Bob'), ('Alice'), ('Greg'), ('Bob')) AS NameTable(name) GROUP BY name; {code}
 
{code:java}
                      Bob                         1
                     Alice                         1
                      Greg                         1
                       Bob                         2 {code}

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



--
This message was sent by Atlassian Jira
(v8.3.4#803005)