test/tools/csql/exp.testnw009.ksh

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