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