| /* |
| * Description : Tests the scalar version of min with nulls. |
| * Success : Yes |
| */ |
| |
| drop dataverse test if exists; |
| create dataverse test; |
| use dataverse test; |
| |
| write output to nc1:"rttest/aggregate_scalar_min_null.adm"; |
| |
| let $i8 := min([int8("1"), int8("2"), int8("3"), null]) |
| let $i16 := min([int16("1"), int16("2"), int16("3"), null]) |
| let $i32 := min([int32("1"), int32("2"), int32("3"), null]) |
| let $i64 := min([int64("1"), int64("2"), int64("3"), null]) |
| let $f := min([float("1"), float("2"), float("3"), null]) |
| let $d := min([double("1"), double("2"), double("3"), null]) |
| let $s := min(["foo", "bar", "world", null]) |
| let $dt := min([datetime("2012-03-01T00:00:00Z"), datetime("2012-01-01T00:00:00Z"), datetime("2012-02-01T00:00:00Z"), null]) |
| for $i in [$i8, $i16, $i32, $i64, $f, $d, $s, $dt] |
| return $i |
