test/tools/csql/exp.testnw008.ksh

   1 Network CSql
   2 echo Description:BETWEEN and IN test;
   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 echo  select * from t1 where f1 between 12 and 14;
  11 ---------------------------------------------------------
  12         t1.f1   t1.f2   t1.f3
  13 ---------------------------------------------------------
  14         12      22      12
  15         13      23      13
  16         14      24      14
  17
  18 echo  select * from t1 where f1 not between 12 and 14;
  19 ---------------------------------------------------------
  20         t1.f1   t1.f2   t1.f3
  21 ---------------------------------------------------------
  22         10      20      10
  23         11      21      11
  24         50      50      50
  25
  26 echo  select * from t1 where f3 between 12 and 14;
  27 ---------------------------------------------------------
  28         t1.f1   t1.f2   t1.f3
  29 ---------------------------------------------------------
  30         12      22      12
  31         13      23      13
  32         14      24      14
  33
  34 echo select * from t1 where f1 IN (12, 14, 50);
  35 ---------------------------------------------------------
  36         t1.f1   t1.f2   t1.f3
  37 ---------------------------------------------------------
  38         12      22      12
  39         14      24      14
  40         50      50      50
  41
  42 echo select * from t1 where f1 IN (12, 14, 50) AND f3 IN (50);
  43 ---------------------------------------------------------
  44         t1.f1   t1.f2   t1.f3
  45 ---------------------------------------------------------
  46         12      22      12
  47         14      24      14
  48         50      50      50
  49
  50 echo select * from t1 where f1 IN (12, 14, 50) OR f3 IN (50);
  51 ---------------------------------------------------------
  52         t1.f1   t1.f2   t1.f3
  53 ---------------------------------------------------------
  54         12      22      12
  55         14      24      14
  56         50      50      50
  57
  58 echo select * from t1 where f1 IN (12, 14, 50) AND f3 between 12 and 14;
  59 ---------------------------------------------------------
  60         t1.f1   t1.f2   t1.f3
  61 ---------------------------------------------------------
  62         12      22      12
  63         14      24      14
  64
  65 echo select * from t1 where f1 NOT IN (12, 14, 50);
  66 ---------------------------------------------------------
  67         t1.f1   t1.f2   t1.f3
  68 ---------------------------------------------------------
  69         10      20      10
  70         11      21      11
  71         13      23      13
  72
  73 Statement Executed