You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "Timo Walther (Jira)" <ji...@apache.org> on 2023/06/28 09:36:00 UTC

[jira] [Created] (FLINK-32466) Invalid input strategy for CONCAT allows BINARY strings

Timo Walther created FLINK-32466:
------------------------------------

             Summary: Invalid input strategy for CONCAT allows BINARY strings
                 Key: FLINK-32466
                 URL: https://issues.apache.org/jira/browse/FLINK-32466
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
            Reporter: Timo Walther
            Assignee: Timo Walther


"string" in SQL terms covers both character strings and binary strings. The author of CONCAT might not have known this. In any case, the code gen instead of the validator fails when executing:

{code}
TableEnvironment t = TableEnvironment.create(EnvironmentSettings.inStreamingMode());
t.createTemporaryView("t", t.fromValues(lit(new byte[] {97})));
t.executeSql("SELECT CONCAT(f0, '-magic') FROM t").print();
{code}

As future work, we should also allow binary strings.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)