Function test_nvl

datafusion/core/tests/dataframe/dataframe_functions.rs:218–245

()

#[tokio::test]
async fn test_nvl() -> Result<()> {
    let lit_null = lit(ScalarValue::Utf8(None));
    // nvl(CASE WHEN a = 'abcDEF' THEN NULL ELSE a END, 'TURNED_NULL')
    let expr = nvl(
        when(col("a").eq(lit("abcDEF")), lit_null)
            .otherwise(col("a"))
            .unwrap(),
        lit("TURNED_NULL"),
    )
    .alias("nvl_expr");

    let batches = get_batches(expr).await?;

    assert_snapshot!(
        batches_to_string(&batches),
        @r"
    +-------------+
    | nvl_expr    |
    +-------------+
    | TURNED_NULL |
    | abc123      |
    | CBAdef      |
    | 123AbcDef   |
    +-------------+
    ");

    Ok(())
}

#[tokio::test]
async fn test_nvl2() -> Result<()> {