test/sql/Predicate/exp.test001.ksh

   1 echo CREATE TABLE t1 (f1 INT , f2 VARCHAR (12));
   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 echo select * from t1;
  11 ---------------------------------------------------------
  12         t1.f1   t1.f2
  13 ---------------------------------------------------------
  14         1       ABCD
  15         2       ABCDE
  16         3       ABCEF
  17         4       ABCCF
  18         5       ABCFF
  19         6       ABCDG
  20         7       ABDCG
  21
  22 echo select * from t1 where f2='ABCD';
  23 ---------------------------------------------------------
  24         t1.f1   t1.f2
  25 ---------------------------------------------------------
  26         1       ABCD
  27
  28 echo select * from t1 where f2<'ABCD';
  29 ---------------------------------------------------------
  30         t1.f1   t1.f2
  31 ---------------------------------------------------------
  32         4       ABCCF
  33
  34 echo select * from t1 where f2>'ABCD';
  35 ---------------------------------------------------------
  36         t1.f1   t1.f2
  37 ---------------------------------------------------------
  38         2       ABCDE
  39         3       ABCEF
  40         5       ABCFF
  41         6       ABCDG
  42         7       ABDCG
  43
  44 echo select * from t1 where f2<='ABCD';
  45 ---------------------------------------------------------
  46         t1.f1   t1.f2
  47 ---------------------------------------------------------
  48         1       ABCD
  49         4       ABCCF
  50
  51 echo select * from t1 where f2>='ABCD';
  52 ---------------------------------------------------------
  53         t1.f1   t1.f2
  54 ---------------------------------------------------------
  55         1       ABCD
  56         2       ABCDE
  57         3       ABCEF
  58         5       ABCFF
  59         6       ABCDG
  60         7       ABDCG
  61
  62 echo select * from t1 where f2!='ABCD';
  63 ---------------------------------------------------------
  64         t1.f1   t1.f2
  65 ---------------------------------------------------------
  66         2       ABCDE
  67         3       ABCEF
  68         4       ABCCF
  69         5       ABCFF
  70         6       ABCDG
  71         7       ABDCG
  72
  73 Statement Executed