| * Test case Name : scan-delete-btree-secondary-index-nullable.aql |
| * Description : This test is intended to test insertion into secondary btree indexes that are built on nullable fields |
| * Expected Result : Success |
| drop dataverse test if exists; |
| create type AddressType as closed { |
| create type CustomerType as closed { |
| children: [ { name: string, age: int32? } ] |
| create dataset Customers(CustomerType) partitioned by key cid; |
| create dataset CustomersMini(CustomerType) partitioned by key cid; |
| using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" |
| (("path"="nc1://data/semistructured/co1k/customer.adm"),("format"="adm")); |
| create index age_index on CustomersMini(age); |
| insert into dataset CustomersMini |
| for $c in dataset('Customers') |
| "interests": $c.interests, |
| write output to nc1:"rttest/dml_scan-insert-btree-secondary-index-nullable.adm"; |
| for $c in dataset('CustomersMini') |