test/tools/csql/exp.test048.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 echo select * from t1;
  14 ---------------------------------------------------------
  15         t1.f1   t1.f2
  16 ---------------------------------------------------------
  17         1       1
  18         2       2
  19         3       3
  20         4       4
  21         5       5
  22         6       6
  23         7       7
  24         8       8
  25         9       9
  26         10      10
  27
  28 echo select * from t1 where f1>-1;
  29 ---------------------------------------------------------
  30         t1.f1   t1.f2
  31 ---------------------------------------------------------
  32         1       1
  33         2       2
  34         3       3
  35         4       4
  36         5       5
  37         6       6
  38         7       7
  39         8       8
  40         9       9
  41         10      10
  42
  43 echo select * from t1 where f1>-2;
  44 ---------------------------------------------------------
  45         t1.f1   t1.f2
  46 ---------------------------------------------------------
  47         1       1
  48         2       2
  49         3       3
  50         4       4
  51         5       5
  52         6       6
  53         7       7
  54         8       8
  55         9       9
  56         10      10
  57
  58 echo select * from t1 where f1>-3;
  59 ---------------------------------------------------------
  60         t1.f1   t1.f2
  61 ---------------------------------------------------------
  62         1       1
  63         2       2
  64         3       3
  65         4       4
  66         5       5
  67         6       6
  68         7       7
  69         8       8
  70         9       9
  71         10      10
  72
  73 echo select * from t1 where f1>-4;
  74 ---------------------------------------------------------
  75         t1.f1   t1.f2
  76 ---------------------------------------------------------
  77         1       1
  78         2       2
  79         3       3
  80         4       4
  81         5       5
  82         6       6
  83         7       7
  84         8       8
  85         9       9
  86         10      10
  87
  88 echo select * from t1 where f1>-5;
  89 ---------------------------------------------------------
  90         t1.f1   t1.f2
  91 ---------------------------------------------------------
  92         1       1
  93         2       2
  94         3       3
  95         4       4
  96         5       5
  97         6       6
  98         7       7
  99         8       8
 100         9       9
 101         10      10
 102
 103 echo select * from t1 where f1>-10;
 104 ---------------------------------------------------------
 105         t1.f1   t1.f2
 106 ---------------------------------------------------------
 107         1       1
 108         2       2
 109         3       3
 110         4       4
 111         5       5
 112         6       6
 113         7       7
 114         8       8
 115         9       9
 116         10      10
 117
 118 echo select * from t1 where f1>-100;
 119 ---------------------------------------------------------
 120         t1.f1   t1.f2
 121 ---------------------------------------------------------
 122         1       1
 123         2       2
 124         3       3
 125         4       4
 126         5       5
 127         6       6
 128         7       7
 129         8       8
 130         9       9
 131         10      10
 132
 133 echo select * from t1 where f1>-1000;
 134 ---------------------------------------------------------
 135         t1.f1   t1.f2
 136 ---------------------------------------------------------
 137         1       1
 138         2       2
 139         3       3
 140         4       4
 141         5       5
 142         6       6
 143         7       7
 144         8       8
 145         9       9
 146         10      10
 147
 148 Statement Executed