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: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
