test/sql/ScalarFunction/exp.test034.ksh

   1 Statement Executed
   2 Statement Executed: Rows Affected = 1
   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 echo select * from t1;
   8 ---------------------------------------------------------
   9         t1.f1   t1.f2
  10 ---------------------------------------------------------
  11         2001/1/1        2001/1/1
  12         2001/1/1        2001/1/3
  13         2001/1/3        2002/2/3
  14         2001/1/1        2002/2/4
  15         2001/1/1        2003/3/5
  16
  17 echo select * from t1 where extract(month from f2) = 02;
  18 ---------------------------------------------------------
  19         t1.f1   t1.f2
  20 ---------------------------------------------------------
  21         2001/1/3        2002/2/3
  22         2001/1/1        2002/2/4
  23
  24 echo select * from t1 where extract(month from f2) < 02;
  25 ---------------------------------------------------------
  26         t1.f1   t1.f2
  27 ---------------------------------------------------------
  28         2001/1/1        2001/1/1
  29         2001/1/1        2001/1/3
  30
  31 echo select * from t1 where extract(month from f2)<= 02;
  32 ---------------------------------------------------------
  33         t1.f1   t1.f2
  34 ---------------------------------------------------------
  35         2001/1/1        2001/1/1
  36         2001/1/1        2001/1/3
  37         2001/1/3        2002/2/3
  38         2001/1/1        2002/2/4
  39
  40 echo select * from t1 where extract(month from f2) > 02;
  41 ---------------------------------------------------------
  42         t1.f1   t1.f2
  43 ---------------------------------------------------------
  44         2001/1/1        2003/3/5
  45
  46 echo select * from t1 where extract(month from f2)>= 02;
  47 ---------------------------------------------------------
  48         t1.f1   t1.f2
  49 ---------------------------------------------------------
  50         2001/1/3        2002/2/3
  51         2001/1/1        2002/2/4
  52         2001/1/1        2003/3/5
  53
  54 echo select * from t1 where extract(month from f2)!= 02;
  55 ---------------------------------------------------------
  56         t1.f1   t1.f2
  57 ---------------------------------------------------------
  58         2001/1/1        2001/1/1
  59         2001/1/1        2001/1/3
  60         2001/1/1        2003/3/5
  61
  62 Statement Executed