Note that filed "name" is defined as mandatory in open type EmpType, however,
if I do not insert any value for "name" field in the insert statement, I do not
see an Exception/error. Interestingly, after the insert, doing a select returns
results.
Another observation : If EmpType was defined to be of closed type, exactly same
behavior is observed, no Exception/error.
What steps will reproduce the problem?
Start asterix using managix, two NC's one CC. Run these statements from Web UI.
drop dataverse test if exists;
create dataverse test;
use dataverse test;
create type EmpType as open {
id : int32,
name : string
}
create dataset Employee(EmpType) primary key id;
insert into dataset Employee ({ "id":123});
for $l in dataset Employee
return $l
Results :
{ "id": 123, "name": "" }
What is the expected output? What do you see instead?
An exception should be caught, user should be informed that mandatory field
"name" is missing in the insert statement.
Please use labels and text to provide additional information.
Here are the details from managix;
kfmohamm@khurram:~/asterix-managix/bin$ ./managix describe -admin
INFO: Name:astx01
Created:Wed May 29 15:19:33 PDT 2013
Web-Url:http://127.0.0.1:19001
State:ACTIVE
Master node:master:127.0.0.1
node1:127.0.0.1
node2:127.0.0.1
Asterix version:0.0.6-SNAPSHOT
Metadata Node:node1
Processes
NC at node1 [ 692 ]
NC at node2 [ 709 ]
CC at master [ 328 ]
Asterix Configuration
nc.java.opts:-Xmx1024m
cc.java.opts:-Xmx1024m
storage.buffercache.pagesize:32768
storage.buffercache.numpages:1024
storage.buffercache.maxopenfiles:214748364
storage.memorycomponent.pagesize:32768
storage.memorycomponent.numpages:4096
storage.memorycomponent.globalbudget:1073741824
storage.lsm.mergethreshold:3
storage.lsm.bloomfilter.falsepositiverate:0.01
txn.log.buffer.numpages:8
txn.log.buffer.pagesize:131072
txn.log.partitionsize:2147483648
txn.log.groupcommitinterval:200
txn.log.checkpoint.lsnthreshold:67108864
txn.log.checkpoint.pollfrequency:120
txn.lock.escalationthreshold:1000
txn.lock.shrinktimer:120000
compiler.sortmemory:536870912
compiler.joinmemory:536870912
compiler.framesize:32768
web.port:19001
api.port:19101
log.level:INFO
Original issue reported on code.google.com by khfaraaz82 on 30 May 2013 at 4:02
Original issue reported on code.google.com by
khfaraaz82
on 30 May 2013 at 4:02