asterix-app/src/test/resources/runtimets/queries/open-closed/open-closed-29.aql

/*
 * Testcase Name  : open-closed-29.aql
 * Description    : Query for undeclared data from an open type internal dataset
 *                : use the some keyword in the where clause
 * Status         : Yes
 * Date           : 31st May 2012
 */

drop dataverse testdv2 if exists;
create dataverse testdv2;
use dataverse testdv2;

create type testtype01 as open {
  id: string,
  name: string
}

create type testtype02 as open {
id : string,
name : string
}

create dataset testds01(testtype01) partitioned by key id;

create dataset testds02(testtype02) partitioned by key id;

insert into dataset testds02 (
{ "id": "001", "name": "Person One", "hobbies": {{"scuba", "music"}}}
);

insert into dataset testds02 (
{ "id": "002", "name": "Person Two", "hobbies": {{"fishing", "dance"}}}
);


insert into dataset testds02 (
{ "id": "003", "name": "Person Three", "hobbies": {{"hiking", "surfing"}}}
);

insert into dataset testds01(
for $d in dataset("testds02")
return $d
);

// select all hobbies where hiking is one of the hobbies

for $d in dataset('testds01')
where some $h in $d.hobbies satisfies $h='hiking' 
return $d