code reorg for Transactionw!
[csql.git] / test / sql / Datatype / exp.test001.ksh
blob6e8c9e4dbcb339984143a0a55b735b62b275ee57
1 echo Create table t1(f1 int, f2 varchar(15) default 'CSQL');
2 Statement Executed
3 echo insert into t1 values(1,'Lakshya1');
4 Statement Executed: Rows Affected = 1
5 echo insert into t1 values(2,NULL);
6 Statement Executed: Rows Affected = 1
7 echo insert into t1 values(3,'Lakshya3');
8 Statement Executed: Rows Affected = 1
9 echo insert into t1 values(4,NULL);
10 Statement Executed: Rows Affected = 1
11 echo insert into t1(f1) values(5);
12 Statement Executed: Rows Affected = 1
13 echo select * from t1;
14 ---------------------------------------------------------
15 t1.f1 t1.f2
16 ---------------------------------------------------------
17 1 Lakshya1
18 2 NULL
19 3 Lakshya3
20 4 NULL
21 5 CSQL
23 echo select * from t1 where f2='CSQL';
24 ---------------------------------------------------------
25 t1.f1 t1.f2
26 ---------------------------------------------------------
27 5 CSQL
29 echo update t1 set f2=NULL where f2='Lakshya3';
30 Statement Executed: Rows Affected = 1
31 echo select * from t1;
32 ---------------------------------------------------------
33 t1.f1 t1.f2
34 ---------------------------------------------------------
35 1 Lakshya1
36 2 NULL
37 3 NULL
38 4 NULL
39 5 CSQL
41 echo select * from t1 where f2 IS NULL;
42 ---------------------------------------------------------
43 t1.f1 t1.f2
44 ---------------------------------------------------------
45 2 NULL
46 3 NULL
47 4 NULL
49 <Table Information of all tables>
50 <TableInfo>
51 <TableName> t1 </TableName>
52 <FieldInfo>
53 <FieldName> f1 </FieldName>
54 <Type> 0 </Type>
55 <Length> 4 </Length>
56 <Primary> 0 </Primary>
57 <Null> 0 </Null>
58 <Default> 0 </Default>
59 <DefaultValue> </DefaultValue>
60 </FieldInfo>
61 <FieldInfo>
62 <FieldName> f2 </FieldName>
63 <Type> 32 </Type>
64 <Length> 16 </Length>
65 <Primary> 0 </Primary>
66 <Null> 0 </Null>
67 <Default> 1 </Default>
68 <DefaultValue> CSQL </DefaultValue>
69 </FieldInfo>
70 </TableInfo>
71 </Table Information of all tables>
72 <Index Information of all Indexs>
73 </Index Information of all Indexs>
74 Statement Executed