test/sql/Datatype/exp.test002.ksh

   1 echo Create table t1( f1 int, f2 varchar(15) NOT NULL);
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement execute failed with error -22
   5 Statement Executed: Rows Affected = 1
   6 Statement execute failed with error -22
   7 Statement Executed: Rows Affected = 1
   8 echo select * from t1;
   9 ---------------------------------------------------------
  10         t1.f1   t1.f2
  11 ---------------------------------------------------------
  12         1       Lakshya1
  13         3       Lakshya3
  14         5       Lakshya5
  15
  16 echo update t1 set f2=NULL where f1<=3;
  17 Statement prepare failed with error -22
  18 echo select * from t1;
  19 ---------------------------------------------------------
  20         t1.f1   t1.f2
  21 ---------------------------------------------------------
  22         1       Lakshya1
  23         3       Lakshya3
  24         5       Lakshya5
  25
  26 <Table Information of all tables>
  27   <TableInfo>
  28     <TableName> t1 </TableName>
  29       <FieldInfo>
  30         <FieldName> f1 </FieldName>
  31         <Type> 0 </Type>
  32         <Length> 4 </Length>
  33         <Primary> 0 </Primary>
  34         <Null> 0 </Null>
  35         <Default> 0 </Default>
  36         <DefaultValue>  </DefaultValue>
  37       </FieldInfo>
  38       <FieldInfo>
  39         <FieldName> f2 </FieldName>
  40         <Type> 32 </Type>
  41         <Length> 16 </Length>
  42         <Primary> 0 </Primary>
  43         <Null> 1 </Null>
  44         <Default> 0 </Default>
  45         <DefaultValue>  </DefaultValue>
  46       </FieldInfo>
  47   </TableInfo>
  48 </Table Information of all tables>
  49 <Index Information of all Indexs>
  50 </Index Information of all Indexs>
  51 Statement Executed