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