You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2020/02/26 22:05:25 UTC
[GitHub] [druid] sascha-coenen opened a new issue #9415: SQL: NVL does not
work with empty strings as documentation states it would
sascha-coenen opened a new issue #9415: SQL: NVL does not work with empty strings as documentation states it would
URL: https://github.com/apache/druid/issues/9415
### Affected Version
0.16.0 and 0.17.0
### Description
NVL does NOT work with empty strings
```
SELECT
NVL('something', 'fallback') AS tst1,
NVL(null, 'fallback') AS tst2,
NVL('', 'fallback') AS tst3
```
this yields
"something", "fallback", ""
According to the documentation, the third projection should also yield the output "fallback"
> NVL(expr,expr-for-null) | Returns 'expr-for-null' if 'expr' is null (or empty string for string type).
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] gianm commented on issue #9415: SQL: NVL does not work with
empty strings as documentation states it would
Posted by GitBox <gi...@apache.org>.
gianm commented on issue #9415: SQL: NVL does not work with empty strings as documentation states it would
URL: https://github.com/apache/druid/issues/9415#issuecomment-591674056
I'd make a similar comment about this as https://github.com/apache/druid/issues/9416#issuecomment-591673574.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org