You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "snuyanzin (via GitHub)" <gi...@apache.org> on 2023/02/17 12:08:57 UTC

[GitHub] [flink] snuyanzin commented on pull request #21958: [FLINK-31118][table] Add ARRAY_UNION function.

snuyanzin commented on PR #21958:
URL: https://github.com/apache/flink/pull/21958#issuecomment-1434551541

   Thanks for your contribution.
   
   To be honest i didn't get the logic.
   What i did:
   1. Built it from the PR's branch
   2. Started standalone Flink
   3. Via sqlClient submitted several queries
   
   ```sql
   SELECT array_union(array[1], array[2]);
   -- result array[1, 2]
   -- this is OK
   ```
   
   ```sql
   SELECT array_union(array[1], array[2, 3]);
   -- result array[1, 2, 3]
   --- this is OK
   ```
   
   ```sql
   SELECT array_union(array[1], array[2, 3, null]);
   -- result array[1, 2, 3, 0]
   --- this is NOT OK
   ```
   
   ```sql
   SELECT array_union(array[1], array['this is a string']);
   -- result [1, 16]
   -- this is NOT OK
   ```
   
   ```sql
   SELECT array_union(array[1], array['this is a string']);
   -- result [1, 16]
   -- this is NOT OK
   ```
   
   ```sql
   SELECT array_union(array[1], array[array[1, 2, 3]]);
   -- result [1, 24]
   -- this is NOT OK
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@flink.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org