| /* |
| * Description : This test case is to verify the fix for issue697 |
| * https://code.google.com/p/asterixdb/issues/detail?id=697 |
| * Expected Result : Success |
| * Date : 16th Nov. 2014 |
| */ |
| |
| drop dataverse test if exists; |
| create dataverse test; |
| |
| use dataverse test; |
| |
| create type TestType as closed { |
| key1: int32, |
| value: int32 |
| } |
| |
| create dataset test(TestType) |
| primary key key1; |
| |
| |
| for $i in dataset("test") |
| group by $aid := $i.key1 with $i |
| return { |
| "gid": $aid, |
| "avg": avg(for $j in $i where not(is-null($j.value)) return $j.value) |
| } |