test script fixes
[csql.git] / test / tools / csql / exp.test012.ksh
blob146da3a751ab1efef22f1d9e45b6552abb8e662e
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
23 echo select * from t1 where f2<='2007-05-05';
24 ---------------------------------------------------------
25 t1.f1 t1.f2
26 ---------------------------------------------------------
27 6 2007/5/5
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
36 echo select * from t1 where f2='2007-05-05';
37 ---------------------------------------------------------
38 t1.f1 t1.f2
39 ---------------------------------------------------------
40 6 2007/5/5
42 echo drop table t1;
43 Statement Executed