alamb commented on PR #3608:
URL:
https://github.com/apache/arrow-datafusion/pull/3608#issuecomment-1257180838
In case anyone else is interested in how `concat_ws` works, I tested it out
with datafusion-cli
```sql
❯ select concat_ws('--', 'foo', 'bar', 'baz');
+---------------------------------------------------------------------+
| concatwithseparator(Utf8("--"),Utf8("foo"),Utf8("bar"),Utf8("baz")) |
+---------------------------------------------------------------------+
| foo--bar--baz |
+---------------------------------------------------------------------+
1 row in set. Query took 0.000 seconds.
❯ select concat_ws('--', null, 'bar', 'baz');
+--------------------------------------------------------------+
| concatwithseparator(Utf8("--"),NULL,Utf8("bar"),Utf8("baz")) |
+--------------------------------------------------------------+
| bar--baz |
+--------------------------------------------------------------+
1 row in set. Query took 0.003 seconds.
❯ select concat_ws(null, 'foo', 'bar', 'baz');
+---------------------------------------------------------------+
| concatwithseparator(NULL,Utf8("foo"),Utf8("bar"),Utf8("baz")) |
+---------------------------------------------------------------+
| |
+---------------------------------------------------------------+
1 row in set. Query took 0.000 seconds.
```
--
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]
