blob: 354757dbcbc66f56352219aa27a54c5ef1aca3e7 [file] [log] [blame]
/*
* 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) partitioned by key id;
create dataset T2(TestType) partitioned by 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