test/tools/csql/exp.test047.ksh

   1 Statement Executed
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 Statement Executed: Rows Affected = 1
  12 Statement Executed: Rows Affected = 1
  13 Statement Executed: Rows Affected = 1
  14 Statement Executed: Rows Affected = 1
  15 Statement Executed: Rows Affected = 1
  16 Statement Executed: Rows Affected = 1
  17 Statement Executed: Rows Affected = 1
  18 Statement Executed: Rows Affected = 1
  19 Statement Executed: Rows Affected = 1
  20 Statement Executed: Rows Affected = 1
  21 Statement Executed: Rows Affected = 1
  22 Statement Executed: Rows Affected = 1
  23 Statement Executed: Rows Affected = 1
  24 Statement Executed: Rows Affected = 1
  25 Statement Executed: Rows Affected = 1
  26 Statement Executed: Rows Affected = 1
  27 Statement Executed: Rows Affected = 1
  28 Statement Executed: Rows Affected = 1
  29 Statement Executed: Rows Affected = 1
  30 Statement Executed: Rows Affected = 1
  31 Statement Executed: Rows Affected = 1
  32 Statement Executed: Rows Affected = 1
  33 Statement Executed: Rows Affected = 1
  34 Statement Executed: Rows Affected = 1
  35 Statement Executed: Rows Affected = 1
  36 Statement Executed: Rows Affected = 1
  37 Statement Executed: Rows Affected = 1
  38 Statement Executed: Rows Affected = 1
  39 Statement Executed: Rows Affected = 1
  40 Statement Executed: Rows Affected = 1
  41 Statement Executed: Rows Affected = 1
  42 Statement Executed: Rows Affected = 1
  43 Statement Executed: Rows Affected = 1
  44 Statement Executed: Rows Affected = 1
  45 Statement Executed: Rows Affected = 1
  46 Statement Executed: Rows Affected = 1
  47 Statement Executed: Rows Affected = 1
  48 Statement Executed: Rows Affected = 1
  49 Statement Executed: Rows Affected = 1
  50 Statement Executed: Rows Affected = 1
  51 Statement Executed: Rows Affected = 1
  52 Statement Executed: Rows Affected = 1
  53 Statement Executed: Rows Affected = 1
  54 echo select * from t1 where f1>5 and f1<15;
  55 ---------------------------------------------------------
  56         t1.f1   t1.f2
  57 ---------------------------------------------------------
  58         6       6
  59         7       7
  60         8       8
  61         9       9
  62         11      11
  63         12      12
  64         13      13
  65         14      14
  66
  67 echo delete from t1 where f1>40;
  68 Statement Executed: Rows Affected = 10
  69 echo commit;
  70 echo select * from t1 where f1>35 and f1<55;
  71 ---------------------------------------------------------
  72         t1.f1   t1.f2
  73 ---------------------------------------------------------
  74         36      36
  75         37      37
  76         38      38
  77         39      39
  78         40      40
  79
  80 echo delete from t1 where f1<8;
  81 Statement Executed: Rows Affected = 7
  82 echo commit;
  83 echo select * from t1 where f1>=-5 and f1<15;
  84 ---------------------------------------------------------
  85         t1.f1   t1.f2
  86 ---------------------------------------------------------
  87         8       8
  88         9       9
  89         11      11
  90         12      12
  91         13      13
  92         14      14
  93
  94 echo insert into t1 values(10,10);
  95 Statement Executed: Rows Affected = 1
  96 echo commit;
  97 echo select * from t1 where f1 >5 and f1 <15;
  98 ---------------------------------------------------------
  99         t1.f1   t1.f2
 100 ---------------------------------------------------------
 101         8       8
 102         9       9
 103         10      10
 104         11      11
 105         12      12
 106         13      13
 107         14      14
 108
 109 Statement Executed