[GitHub] [arrow-datafusion] vincev commented on issue #7136: `make_array` null handling with nested version

["vincev (via GitHub)" <gi...@apache.org>]

vincev commented on issue #7136:
URL: https://github.com/apache/arrow-datafusion/issues/7136#issuecomment-1657158833

   This makes sense to me too, another thing I have noticed (maybe related to this) is that arrays with a null value generate error: 
   
   ```
   DataFusion CLI v28.0.0
   ❯ select make_array([1,2], [3,4]) as a;
   +------------------+
   | a                |
   +------------------+
   | [[1, 2], [3, 4]] |
   +------------------+
   ❯ select make_array([1,null], [3,4]) as a;
   This feature is not implemented: Arrays with different types are not supported: {Int64, Null}
   ```
   
   DuckDB generates:
   
   ```
   D select array[[1,null],[3,4]] as a;
   ┌─────────────────────┐
   │          a          │
   │      int32[][]      │
   ├─────────────────────┤
   │ [[1, NULL], [3, 4]] │
   └─────────────────────┘
   ```


-- 
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: github-unsubscribe@arrow.apache.org

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