| alexander.behm | 941c32b | 2012-07-08 22:16:38 +0000 | [diff] [blame] | 1 | /* |
| 2 | * Description : Tests that non-datascan unnests are rewritten into joins. | ||||
| 3 | * Success : Yes | ||||
| 4 | */ | ||||
| 5 | |||||
| 6 | drop dataverse test if exists; | ||||
| 7 | create dataverse test; | ||||
| 8 | use dataverse test; | ||||
| 9 | |||||
| 10 | write output to nc1:"rttest/unnest-to-join_01.adm"; | ||||
| 11 | |||||
| 12 | for $x in [1,2,3,4,5,6] | ||||
| 13 | for $y in [4,5,6,7,8,9] | ||||
| 14 | where $x = $y | ||||
| 15 | return $y | ||||