test/sql/Datatype/exp.test001.ksh

   1 echo Create table t1(f1 int, f2 varchar(15) default 'CSQL');
   2 Statement Executed
   3 echo insert into t1 values(1,'Lakshya1');
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 values(2,NULL);
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 values(3,'Lakshya3');
   8 Statement Executed: Rows Affected = 1
   9 echo insert into t1 values(4,NULL);
  10 Statement Executed: Rows Affected = 1
  11 echo insert into t1(f1) values(5);
  12 Statement Executed: Rows Affected = 1
  13 echo select * from t1;
  14 ---------------------------------------------------------
  15         t1.f1   t1.f2
  16 ---------------------------------------------------------
  17         1       Lakshya1
  18         2       NULL
  19         3       Lakshya3
  20         4       NULL
  21         5       CSQL
  22
  23 echo select * from t1 where f2='CSQL';
  24 ---------------------------------------------------------
  25         t1.f1   t1.f2
  26 ---------------------------------------------------------
  27         5       CSQL
  28
  29 echo update t1 set f2=NULL where f2='Lakshya3';
  30 Statement Executed: Rows Affected = 1
  31 echo select * from t1;
  32 ---------------------------------------------------------
  33         t1.f1   t1.f2
  34 ---------------------------------------------------------
  35         1       Lakshya1
  36         2       NULL
  37         3       NULL
  38         4       NULL
  39         5       CSQL
  40
  41 echo select * from t1 where f2 IS NULL;
  42 ---------------------------------------------------------
  43         t1.f1   t1.f2
  44 ---------------------------------------------------------
  45         2       NULL
  46         3       NULL
  47         4       NULL
  48
  49 <Table Information of all tables>
  50   <TableInfo>
  51     <TableName> t1 </TableName>
  52       <FieldInfo>
  53         <FieldName> f1 </FieldName>
  54         <Type> 0 </Type>
  55         <Length> 4 </Length>
  56         <Primary> 0 </Primary>
  57         <Null> 0 </Null>
  58         <Default> 0 </Default>
  59         <DefaultValue>  </DefaultValue>
  60       </FieldInfo>
  61       <FieldInfo>
  62         <FieldName> f2 </FieldName>
  63         <Type> 32 </Type>
  64         <Length> 16 </Length>
  65         <Primary> 0 </Primary>
  66         <Null> 0 </Null>
  67         <Default> 1 </Default>
  68         <DefaultValue> CSQL </DefaultValue>
  69       </FieldInfo>
  70   </TableInfo>
  71 </Table Information of all tables>
  72 <Index Information of all Indexs>
  73 </Index Information of all Indexs>
  74 Statement Executed