asterix-app/src/test/resources/runtimets/queries/open-closed/c2c-w-optional.aql

/*
 * Testcase Name  : c2c-w-optional.aql
 * Description    : Insert data into target datase by doing a select on source dataset.
 *                : Here both source and target datasets are internal datasets
 *                : The schema includes one optional field named optnl_fld.
 * Success        : Yes
 * Date           : 23rd May 2012
 */

drop dataverse test if exists;
create dataverse test;
use dataverse test;

create type TestType as closed {
id:int32,
description:string,
name:string,
optnl_fld:string?
}

create dataset T1(TestType) primary key id;

create dataset T2(TestType) primary key id;

insert into dataset T1({
"id":1234,
"description":"donut",
"name":"Cake",
"optnl_fld":"optional data goes here"
}
);

insert into dataset T2(for $l in dataset("T1") return $l );

for $d in dataset("T2")
order by $d.id
return $d