*** empty log message ***
[csql.git] / test / tools / csql / exp.test133.ksh
blob76ef1b106f40000c2be5cf6b3259a457e8cd3f84
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
11 Statement Executed