| /* |
| * Description : Create dataverse, types, nodegroup and a dataset. Cause exception by re-creating nodegroup. |
| * Subsequent statement(s) should not executed. This is verified in a separate session (compilation unit) |
| * Expected Res : Exception |
| * Date : 24 Nov 2012 |
| */ |
| drop dataverse custord if exists; |
| |
| create dataverse custord; |
| |
| use dataverse custord; |
| |
| create type StreetType as closed { |
| number: int32?, |
| name: string |
| } |
| |
| create type AddressType as open { |
| street: StreetType, |
| city: string, |
| state: string, |
| zip: int16 |
| } |
| |
| create type CustomerType as closed { |
| cid: int32, |
| name: string, |
| age: int32?, |
| address: AddressType?, |
| interests: {{string}}, |
| children: [ { |
| name : string, |
| dob : string |
| } ] |
| } |
| |
| create nodegroup group1 if not exists on nc1, nc2; |
| |
| create dataset Customers(CustomerType) |
| partitioned by key cid, name on group1; |
| |
| create nodegroup group1 on nc1, nc2; |
| |
| // the following statement should not get executed |
| // as the above statement causes an exception |
| create index custName on Customers(name, cid); |
| |