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