test/tools/csql/exp.testnw016.ksh

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