This is an automated email from the ASF dual-hosted git repository.
victoria pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/druid.git
The following commit(s) were added to refs/heads/master by this push:
new d4e478c909 NVL function docs update (#14169)
d4e478c909 is described below
commit d4e478c90918edbb83799372691439d3b55f82ee
Author: Jill Osborne <[email protected]>
AuthorDate: Thu Apr 27 19:17:21 2023 +0100
NVL function docs update (#14169)
Co-authored-by: Victoria Lim <[email protected]>
---
docs/querying/sql-scalar.md | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/docs/querying/sql-scalar.md b/docs/querying/sql-scalar.md
index 6e94eb4e25..ffdac7b7a2 100644
--- a/docs/querying/sql-scalar.md
+++ b/docs/querying/sql-scalar.md
@@ -270,6 +270,6 @@ The [DataSketches
extension](../development/extensions-core/datasketches-extensi
|`CASE WHEN boolean_expr1 THEN result1 \[ WHEN boolean_expr2 THEN result2 ...
\] \[ ELSE resultN \] END`|Searched CASE.|
|`NULLIF(value1, value2)`|Returns NULL if value1 and value2 match, else
returns value1.|
|`COALESCE(value1, value2, ...)`|Returns the first value that is neither NULL
nor empty string.|
-|`NVL(expr, expr-for-null)`|Returns `expr-for-null` if `expr` is null (or
empty string for string type).|
+|`NVL(value1, value2)`|Returns `value1` if `value1` is not null, otherwise
`value2`.|
|`BLOOM_FILTER_TEST(expr, serialized-filter)`|Returns true if the value of
`expr` is contained in the Base64-serialized Bloom filter. See the [Bloom
filter extension](../development/extensions-core/bloom-filter.md) documentation
for additional details. See the [`BLOOM_FILTER` function](sql-aggregations.md)
for computing Bloom filters.|
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]