test/tools/csql/exp.test010.ksh

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