| /* |
| * Description : Tests the scalar version of avg with nulls. |
| * Success : Yes |
| */ |
| |
| drop dataverse test if exists; |
| create dataverse test; |
| use dataverse test; |
| |
| write output to nc1:"rttest/aggregate_scalar_avg_null.adm"; |
| |
| let $i8 := avg([int8("1"), int8("2"), int8("3"), null]) |
| let $i16 := avg([int16("1"), int16("2"), int16("3"), null]) |
| let $i32 := avg([int32("1"), int32("2"), int32("3"), null]) |
| let $i64 := avg([int64("1"), int64("2"), int64("3"), null]) |
| let $f := avg([float("1"), float("2"), float("3"), null]) |
| let $d := avg([double("1"), double("2"), double("3"), null]) |
| for $i in [$i8, $i16, $i32, $i64, $f, $d] |
| return $i |
