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

/*
 * Testcase Name  :  open-closed-17.aql
 * Description    :  Test open type dataset by inserting additional data along with inserting data for existing fields.
 * Success        :  Yes
 * Date           :  March 30th 2012
 */

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

create type Schema as open{
id_8: int8,
id_16: int16,
id_32: int32,
id_64: int64,
fp : float,
name: string,
dt: date,
tm: time,
dt_tm: datetime,
lat_lon: point
}

create dataset tdtst(Schema) partitioned by key id_32; 

insert into dataset tdtst(
let $f1:=time("10:50:56:200+05:00")
let $f2:=datetime("2011-12-31T14:00:00-10:00")
let $f3:=point("100.0,200.0")
return {
"id_8":100,
"id_16":1011,
"id_32":23455,
"id_64":34567,
"fp":87.61863f,
"name":"John",
"dt":"03-21-1982",
"tm": $f1,
"dt_tm": $f2,
"lat_lon": $f3,
"mydata":{{"this is my additional data"}}
}
);

for $l in dataset('tdtst')
return $l