You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Dawid Wysakowicz (Jira)" <ji...@apache.org> on 2024/09/09 15:25:00 UTC

[jira] [Updated] (FLINK-36241) Table API .plus should support string concatenation

     [ https://issues.apache.org/jira/browse/FLINK-36241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dawid Wysakowicz updated FLINK-36241:
-------------------------------------
    Description: 
It should be possible to concatenate strings using `plus`. Moreover, since plus is not very SQL-native for concatenating strings we should also have a fluent `.concat` function.

{code}
          TestSetSpec.forFunction(BuiltInFunctionDefinitions.PLUS)
                  .onFieldsWithData("Beginning", " Ending")
                  .andDataTypes(DataTypes.STRING(), DataTypes.STRING())
                  .testResult($("f0").plus($("f1")), "concat(f0, f1)", "Beginning Ending" ,
                          DataTypes.STRING())
{code}

  was:
It should be possible to concatenate strings using `plus`. Moreover, since plus is not very SQL-native for concatenating strings we should also have a fluent `.concat` function.

{code}
          TestSetSpec.forFunction(BuiltInFunctionDefinitions.PLUS)
                  .onFieldsWithData("Beginning", " Ending")
                  .andDataTypes(DataTypes.STRING(), DataTypes.STRING())
                  .testResult($("f0").plus($("f1")), "concat(f0, f1)", "Beginning Ending" ,
                          DataTypes.STRING())
(code)


> Table API .plus should support string concatenation
> ---------------------------------------------------
>
>                 Key: FLINK-36241
>                 URL: https://issues.apache.org/jira/browse/FLINK-36241
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / API
>            Reporter: Dawid Wysakowicz
>            Assignee: Dawid Wysakowicz
>            Priority: Major
>             Fix For: 2.0.0
>
>
> It should be possible to concatenate strings using `plus`. Moreover, since plus is not very SQL-native for concatenating strings we should also have a fluent `.concat` function.
> {code}
>           TestSetSpec.forFunction(BuiltInFunctionDefinitions.PLUS)
>                   .onFieldsWithData("Beginning", " Ending")
>                   .andDataTypes(DataTypes.STRING(), DataTypes.STRING())
>                   .testResult($("f0").plus($("f1")), "concat(f0, f1)", "Beginning Ending" ,
>                           DataTypes.STRING())
> {code}



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