| /* | |
| * Description : Notice the query hint to avoid using any secondary index to evaluate the predicate in the where clause | |
| * Expected Res : Success | |
| * Date : 21th December 2013 | |
| */ | |
| drop dataverse test if exists; | |
| create dataverse test; | |
| use dataverse test; | |
| create type AddressType as closed { | |
| number: int32, | |
| street: string, | |
| city: string | |
| } | |
| create type CustomerType as closed { | |
| cid: int32, | |
| name: string, | |
| age: int32, | |
| address: AddressType?, | |
| interests: {{string}}, | |
| children: [ { name: string, age: int32? } ] | |
| } | |
| create dataset Customers(CustomerType) primary key cid; | |
| create index age_index on Customers(age); | |
| delete $c from dataset Customers where $c.age /*+ skip-index */ < 20; | |