Hi Team,
I am facing one issue
I created one table as below
CREATE TABLE STUDENT
(
ID INTEGER NOT NULL,
NAME VARCHAR(200) NOT NULL,
SALARY INTGER NOT NULL,
PRIMARY KEY(STUDENTID)
)WITH "KEY_TYPE=Tab_Key,VALUE_TYPE=TAB_VALUE";



I used datastreamer to load the data into the table
try(IgniteDataStreamer<BinaryObject,BinaryObject>
stmr=ignite.dataStreamer("SQL_PUBLIC_STUDENT")){
  stmr.keepBinary(true);
  stmr.allowOverwrite(true);
  BinaryObjectBuilder keyBuilder=ignite.binary().builder("Tab_Key");
  BinaryObjectBuilder keyBuilder=ignite.binary().builder("Tab_Value");
  keyBuilder.setField("ID",new Integer(100));
  valueBuilder.setField(" NAME","Petit");// did not insert any value for
SALARY in the value builder
  stmr.addData( keyBuilder.build(), valueBuilder.build());
 }

When I am running this for the first time , data gets inserted with
id=100,name=Petit,salary=null though the SALARY is not null field.
In the second run it gives NULL value is not allowed for column SALARY
Why it is not giving this error in the first run itself.

Thanks

Reply via email to