| /* |
| * Description : Tests that non-datascan unnests are pushed through join and |
| * : the query plan is rewritten as hybrid hash join. |
| * Success : Yes |
| */ |
| |
| drop dataverse test if exists; |
| create dataverse test; |
| use dataverse test; |
| |
| create type TestType as open { |
| id:int32, |
| name:string |
| } |
| |
| create dataset t1(TestType) primary key id; |
| create dataset t2(TestType) primary key id; |
| |
| write output to nc1:"rttest/hahsjoin-with-unnest.adm"; |
| |
| for $m in dataset('t1') |
| for $n in dataset('t2') |
| for $a in $m.hobbies |
| for $b in $n.hobbies |
| where $a = $b |
| return {"t1":$m, "t2":$n} |