test/tools/csql/exp.test012.ksh

   1 echo create table t1 (f1 int,f2 date);
   2 Statement Executed
   3 echo insert into t1 values(1,'2008-10-29');
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 values(2,'28-12-2008');
   6 Statement prepare failed with error -16
   7 echo insert into t1 values(3,'2008-2-30');
   8 Statement prepare failed with error -16
   9 echo insert into t1 values(4,'2008-3- -20');
  10 Statement prepare failed with error -16
  11 echo insert into t1 values(5,NULL);
  12 Statement Executed: Rows Affected = 1
  13 echo insert into t1 values(6,'2007-05-05');
  14 Statement Executed: Rows Affected = 1
  15 echo select * from t1;
  16 ---------------------------------------------------------
  17         t1.f1   t1.f2
  18 ---------------------------------------------------------
  19         1       2008/10/29
  20         5       NULL
  21         6       2007/5/5
  22
  23 echo select * from t1 where f2<='2007-05-05';
  24 ---------------------------------------------------------
  25         t1.f1   t1.f2
  26 ---------------------------------------------------------
  27         6       2007/5/5
  28
  29 echo select * from t1 where f2>='2007-05-05';
  30 ---------------------------------------------------------
  31         t1.f1   t1.f2
  32 ---------------------------------------------------------
  33         1       2008/10/29
  34         6       2007/5/5
  35
  36 echo select * from t1 where f2='2007-05-05';
  37 ---------------------------------------------------------
  38         t1.f1   t1.f2
  39 ---------------------------------------------------------
  40         6       2007/5/5
  41
  42 echo drop table t1;
  43 Statement Executed