mateuszkj opened a new issue #2100:
URL: https://github.com/apache/arrow-datafusion/issues/2100
**Describe the bug**
Function *concat_ws* is not ignoring NULL in last argument and seperator
text is added at the end of the result.
**To Reproduce**
```sql
SELECT concat_ws('|', 'a', NULL);
-- Result: a|
```
Tested on master (refs 73ea6e1)
**Expected behavior**
```sql
SELECT concat_ws('|', 'a', NULL);
-- Result: a
```
There should not be spectator added as the end of result.
**Additional context**
There is test case for ignoring NULLs in arguments but only in the middle:
https://github.com/apache/arrow-datafusion/blob/master/datafusion/tests/sql/expr.rs#L553=
Function description says NULLs should be ignored:
https://github.com/apache/arrow-datafusion/blob/master/datafusion-physical-expr/src/string_expressions.rs#L326=
--
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]
