Github user maropu commented on a diff in the pull request:

    https://github.com/apache/spark/pull/19977#discussion_r157937149
  
    --- Diff: 
sql/core/src/test/resources/sql-tests/inputs/typeCoercion/native/concat.sql ---
    @@ -0,0 +1,21 @@
    +-- Concatenate binary inputs
    +SELECT (col1 || col2 || col3 || col4) col
    +FROM (
    +  SELECT
    +    encode(string(id), 'utf-8') col1,
    +    encode(string(id + 1), 'utf-8') col2,
    +    encode(string(id + 2), 'utf-8') col3,
    +    encode(string(id + 3), 'utf-8') col4
    +  FROM range(10)
    +);
    +
    +-- Concatenate mixed inputs between strings and binary
    +SELECT (col1 || col2 || col3 || col4) col
    +FROM (
    +  SELECT
    +    string(id) col1,
    +    string(id + 1) col2,
    +    encode(string(id + 2), 'utf-8') col3,
    +    encode(string(id + 3), 'utf-8') col4
    +  FROM range(10)
    +);
    --- End diff --
    
    ok


---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org

Reply via email to