| /* |
| * Description : Tests the scalar version of max with nulls. |
| * Success : Yes |
| */ |
| |
| drop dataverse test if exists; |
| create dataverse test; |
| use dataverse test; |
| |
| write output to nc1:"rttest/aggregate_scalar_max_null.adm"; |
| |
| let $i8 := max([int8("1"), int8("2"), int8("3"), null]) |
| let $i16 := max([int16("1"), int16("2"), int16("3"), null]) |
| let $i32 := max([int32("1"), int32("2"), int32("3"), null]) |
| let $i64 := max([int64("1"), int64("2"), int64("3"), null]) |
| let $f := max([float("1"), float("2"), float("3"), null]) |
| let $d := max([double("1"), double("2"), double("3"), null]) |
| let $s := max(["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 |