*** empty log message ***
[csql.git] / test / tools / csql / exp.testnw009.ksh
blob1dade29472efbc55af337bd33d48cbff628d9b1d
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 Executed: Rows Affected = 1
8 echo insert into t1 values(3,'2008-2-30');
9 Statement Executed: Rows Affected = 1
10 echo insert into t1 values(4,'2008-3- -20');
11 Statement Executed: Rows Affected = 1
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 2 0/0/0
22 3 0/0/0
23 4 0/0/0
24 5 NULL
25 6 2007/5/5
27 echo select * from t1 where f2<='2007-05-05';
28 ---------------------------------------------------------
29 t1.f1 t1.f2
30 ---------------------------------------------------------
31 2 0/0/0
32 3 0/0/0
33 4 0/0/0
34 6 2007/5/5
36 echo select * from t1 where f2>='2007-05-05';
37 ---------------------------------------------------------
38 t1.f1 t1.f2
39 ---------------------------------------------------------
40 1 2008/10/29
41 6 2007/5/5
43 echo select * from t1 where f2='2007-05-05';
44 ---------------------------------------------------------
45 t1.f1 t1.f2
46 ---------------------------------------------------------
47 6 2007/5/5
49 echo drop table t1;
50 Statement Executed