test/tools/csql/exp.test133.ksh

   1 echo CREATE TABLE t1(f1 int default 1,f2 smallint default 10,f3 bigint default 100,f4 float default 1.9,f5 double default 987654321.123456,f6 char(20) default 'CSQl-CACHE',f7 date default '2001-01-01',f8 time default '01:01:01',f9 timestamp default '2001-01-01 01:01:01');
   2 Statement Executed
   3 echo INSERT INTO t1(f7,f8,f9) VALUES('2009-06-09','21:09:09','2009-06-09 21:09:09');
   4 Statement Executed: Rows Affected = 1
   5 echo SELECT * FROM t1;
   6 ---------------------------------------------------------
   7         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
   8 ---------------------------------------------------------
   9         1       10      100     1.900000        987654321.123456        CSQl-CACHE      2009/6/9        21:9:9.0        2009/6/9 21:9:9.0
  10
  11 Statement Executed