test/tools/csql/exp.test028.ksh

   1 echo LIKE operator char datatype testing;
   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 echo select * from t1;
  15 ---------------------------------------------------------
  16         t1.f1   t1.f2
  17 ---------------------------------------------------------
  18         10      A
  19         11      B
  20         12      C
  21         13      D
  22         14      14
  23         50      E
  24         This is really a ve     E
  25         UPPERCASE       UPPER
  26         uppercase       LOWER
  27         upperletter     LOWER
  28         uppercaseletter LOWER
  29
  30 echo select * from t1 where f1 LIKE 'UPP%';
  31 ---------------------------------------------------------
  32         t1.f1   t1.f2
  33 ---------------------------------------------------------
  34         UPPERCASE       UPPER
  35
  36 echo select * from t1 where f1 LIKE 'upp%';
  37 ---------------------------------------------------------
  38         t1.f1   t1.f2
  39 ---------------------------------------------------------
  40         uppercase       LOWER
  41         upperletter     LOWER
  42         uppercaseletter LOWER
  43
  44 echo select * from t1 where f1 LIKE 'upper%letter';
  45 ---------------------------------------------------------
  46         t1.f1   t1.f2
  47 ---------------------------------------------------------
  48         upperletter     LOWER
  49         uppercaseletter LOWER
  50
  51 echo select * from t1 where f1 LIKE 'upper____letter';
  52 ---------------------------------------------------------
  53         t1.f1   t1.f2
  54 ---------------------------------------------------------
  55         uppercaseletter LOWER
  56
  57 echo select * from t1 where f1 like 'UP__R%SE';
  58 ---------------------------------------------------------
  59         t1.f1   t1.f2
  60 ---------------------------------------------------------
  61         UPPERCASE       UPPER
  62
  63 echo select * from t1 where f1 like 'UP__R%SE' and f2 = 'B';
  64 ---------------------------------------------------------
  65         t1.f1   t1.f2
  66 ---------------------------------------------------------
  67
  68 echo select * from t1 where f1 like 'UP__R%SE' and f2 = 'UPPER';
  69 ---------------------------------------------------------
  70         t1.f1   t1.f2
  71 ---------------------------------------------------------
  72         UPPERCASE       UPPER
  73
  74 echo select * from t1 where f1 like 'UP__R%SE' and f2 like 'UPPER';
  75 ---------------------------------------------------------
  76         t1.f1   t1.f2
  77 ---------------------------------------------------------
  78         UPPERCASE       UPPER
  79
  80 Statement Executed