jatin510 commented on issue #13872: URL: https://github.com/apache/datafusion/issues/13872#issuecomment-2569547645
``` > SELECT array_remove([1,null], 1); +--------------------------------------------------+ | array_remove(make_array(Int64(1),NULL),Int64(1)) | +--------------------------------------------------+ | [] | +--------------------------------------------------+ 1 row(s) fetched. Elapsed 0.006 seconds. > SELECT cardinality(array_remove([1,null], 1)); +---------------------------------------------------------------+ | cardinality(array_remove(make_array(Int64(1),NULL),Int64(1))) | +---------------------------------------------------------------+ | 1 | +---------------------------------------------------------------+ 1 row(s) fetched. Elapsed 0.009 seconds. > SELECT array_remove([1], 1); +---------------------------------------------+ | array_remove(make_array(Int64(1)),Int64(1)) | +---------------------------------------------+ | [] | +---------------------------------------------+ 1 row(s) fetched. Elapsed 0.005 seconds. > SELECT cardinality(array_remove([1], 1)); +----------------------------------------------------------+ | cardinality(array_remove(make_array(Int64(1)),Int64(1))) | +----------------------------------------------------------+ | | +----------------------------------------------------------+ 1 row(s) fetched. Elapsed 0.005 seconds. ``` happening for array_remove as well in this case also should we return null ? @jayzhan211 -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
