2 # Testing DATE_DIFF function
3 # Create table t1(f1 date, f2 date);
4 # insert into t1 values('2001-01-01', '2001-01-03');
5 # insert into t1 values('2001-01-01', '2001-02-01');
6 # insert into t1 values('2001-01-01', '2001-03-01');
7 # insert into t1 values('2001-01-01', '2002-01-01');
8 # insert into t1 values('2001-01-01', '2002-02-02');
10 # select * from t1 where date_diff(f2,f1)=2;
11 # select * from t1 where date_diff(f1,f2)=2;
12 # select * from t1 where date_diff(f2,f1)=31;
13 # select * from t1 where date_diff(f2,f1)=59;
14 # select * from t1 where date_diff(f2,f1)=365;
15 # select * from t1 where date_diff(f2,f1)=397;
16 # select * from t1 where date_diff(f2,f1)<59;
17 # select * from t1 where date_diff(f2,f1)<=59;
18 # select * from t1 where date_diff(f2,f1)>59;
19 # select * from t1 where date_diff(f2,f1)>=59;
20 # select * from t1 where date_diff(f2,f1)!=59;
21 # select * from t1 where date_diff(f2,'2001-01-01')=2;
22 # select * from t1 where date_diff(f2,'2001-01-01')>=59;
23 # select * from t1 where date_diff(f2,'2001-01-01')!=365;
24 # select * from t1 where date_diff('2001-01-02','2001-01-01')=1;
26 CREATEFILE
=${PWD}/sql
/ScalarFunction
/csql.conf
28 if [ -s "$CREATEFILE" ]
30 REL_PATH
=`pwd`/sql
/ScalarFunction
33 echo "drop table t1;" >${REL_PATH}/dropt1.sql
35 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1.sql
>/dev
/null
2>&1
37 if [ "$VALGRIND" = "true" ]
39 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/date_diff.sql
41 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/date_diff.sql
44 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1.sql
45 rm -f ${REL_PATH}/dropt1.sql
50 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/dropt1.sql
56 rm -f ${REL_PATH}/dropt1.sql