test/tools/csql/exp.test100.ksh

   1 echo Create table t1(f1 int, f2 char(10000));
   2 Statement Executed
   3 echo insert into t1 values(1,'wraFASDvgaserrerqwe');
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 values(2,'wraFASDvgaserrerqwe');
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 values(3,'wraFASDvgaserrerqwe');
   8 Statement Executed: Rows Affected = 1
   9 echo insert into t1 values(4,'wraFASDvgaserrerqwe');
  10 Statement Executed: Rows Affected = 1
  11 echo insert into t1 values(5,'wraFASDvgaserrerqwe');
  12 Statement Executed: Rows Affected = 1
  13 echo insert into t1 values(6,'wraFASDvgaserrerqwe');
  14 Statement Executed: Rows Affected = 1
  15 echo insert into t1 values(7,'wraFASDvgaserrerqwe');
  16 Statement Executed: Rows Affected = 1
  17 echo insert into t1 values(8,'wraFASDvgaserrerqwe');
  18 Statement Executed: Rows Affected = 1
  19 echo insert into t1 values(9,'wraFASDvgaserrerqwe');
  20 Statement Executed: Rows Affected = 1
  21 echo insert into t1 values(10,'wraFASDvgaserrerqwe');
  22 Statement Executed: Rows Affected = 1
  23 echo select * from t1;
  24 ---------------------------------------------------------
  25         t1.f1   t1.f2
  26 ---------------------------------------------------------
  27         1       wraFASDvgaserrerqwe
  28         2       wraFASDvgaserrerqwe
  29         3       wraFASDvgaserrerqwe
  30         4       wraFASDvgaserrerqwe
  31         5       wraFASDvgaserrerqwe
  32         6       wraFASDvgaserrerqwe
  33         7       wraFASDvgaserrerqwe
  34         8       wraFASDvgaserrerqwe
  35         9       wraFASDvgaserrerqwe
  36         10      wraFASDvgaserrerqwe
  37
  38 <Table Information of all tables>
  39   <TableInfo>
  40     <TableName> t1 </TableName>
  41       <FieldInfo>
  42         <FieldName> f1 </FieldName>
  43         <Type> 0 </Type>
  44         <Length> 4 </Length>
  45         <Primary> 0 </Primary>
  46         <Null> 0 </Null>
  47         <Default> 0 </Default>
  48         <DefaultValue>  </DefaultValue>
  49       </FieldInfo>
  50       <FieldInfo>
  51         <FieldName> f2 </FieldName>
  52         <Type> 30 </Type>
  53         <Length> 10000 </Length>
  54         <Primary> 0 </Primary>
  55         <Null> 0 </Null>
  56         <Default> 0 </Default>
  57         <DefaultValue>  </DefaultValue>
  58       </FieldInfo>
  59   </TableInfo>
  60 </Table Information of all tables>
  61 <Index Information of all Indexs>
  62 </Index Information of all Indexs>
  63 update t1 set f2='LAKSHYA-CSQL' where f1>=3;
  64 Statement Executed: Rows Affected = 8
  65 echo select * from t1;
  66 ---------------------------------------------------------
  67         t1.f1   t1.f2
  68 ---------------------------------------------------------
  69         1       wraFASDvgaserrerqwe
  70         2       wraFASDvgaserrerqwe
  71         3       LAKSHYA-CSQL
  72         4       LAKSHYA-CSQL
  73         5       LAKSHYA-CSQL
  74         6       LAKSHYA-CSQL
  75         7       LAKSHYA-CSQL
  76         8       LAKSHYA-CSQL
  77         9       LAKSHYA-CSQL
  78         10      LAKSHYA-CSQL
  79
  80 delete from t1 where f1<= 7;
  81 Statement Executed: Rows Affected = 7
  82 echo select * from t1;
  83 ---------------------------------------------------------
  84         t1.f1   t1.f2
  85 ---------------------------------------------------------
  86         8       LAKSHYA-CSQL
  87         9       LAKSHYA-CSQL
  88         10      LAKSHYA-CSQL
  89
  90 <Table Information of all tables>
  91   <TableInfo>
  92     <TableName> t1 </TableName>
  93       <FieldInfo>
  94         <FieldName> f1 </FieldName>
  95         <Type> 0 </Type>
  96         <Length> 4 </Length>
  97         <Primary> 0 </Primary>
  98         <Null> 0 </Null>
  99         <Default> 0 </Default>
 100         <DefaultValue>  </DefaultValue>
 101       </FieldInfo>
 102       <FieldInfo>
 103         <FieldName> f2 </FieldName>
 104         <Type> 30 </Type>
 105         <Length> 10000 </Length>
 106         <Primary> 0 </Primary>
 107         <Null> 0 </Null>
 108         <Default> 0 </Default>
 109         <DefaultValue>  </DefaultValue>
 110       </FieldInfo>
 111   </TableInfo>
 112 </Table Information of all tables>
 113 <Index Information of all Indexs>
 114 </Index Information of all Indexs>
 115 Statement Executed