blob: acef21e42aa3607f37b976bc7a43abdd57bc1dec [file] [log] [blame]
/*
* Testcase Name : open-closed-28.aql
* Description : Query for undeclared data from an open type internal dataset
* : use the every 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) primary key id;
create dataset testds02(testtype02) primary 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
write output to nc1:"rttest/open-closed_open-closed-28.adm";
for $d in dataset('testds01')
where every $h in $d.hobbies satisfies $h='hiking'
order by $d.id
return $d