*** empty log message ***
[csql.git] / test / tools / csql / exp.test100.ksh
blob1090722ae425ebd3b29a0b2e7908ccf78efb9eb3
1 echo Create table t1(f1 int, f2 char(10000));
2 Statement Executed
3 echo insert into t1 values(1,'wraFASDvgaserrerqwe');
4 Statement Executed: Rows Affected = 1
5 echo insert into t1 values(2,'wraFASDvgaserrerqwe');
6 Statement Executed: Rows Affected = 1
7 echo insert into t1 values(3,'wraFASDvgaserrerqwe');
8 Statement Executed: Rows Affected = 1
9 echo insert into t1 values(4,'wraFASDvgaserrerqwe');
10 Statement Executed: Rows Affected = 1
11 echo insert into t1 values(5,'wraFASDvgaserrerqwe');
12 Statement Executed: Rows Affected = 1
13 echo insert into t1 values(6,'wraFASDvgaserrerqwe');
14 Statement Executed: Rows Affected = 1
15 echo insert into t1 values(7,'wraFASDvgaserrerqwe');
16 Statement Executed: Rows Affected = 1
17 echo insert into t1 values(8,'wraFASDvgaserrerqwe');
18 Statement Executed: Rows Affected = 1
19 echo insert into t1 values(9,'wraFASDvgaserrerqwe');
20 Statement Executed: Rows Affected = 1
21 echo insert into t1 values(10,'wraFASDvgaserrerqwe');
22 Statement Executed: Rows Affected = 1
23 echo select * from t1;
24 ---------------------------------------------------------
25 t1.f1 t1.f2
26 ---------------------------------------------------------
27 1 wraFASDvgaserrerqwe
28 2 wraFASDvgaserrerqwe
29 3 wraFASDvgaserrerqwe
30 4 wraFASDvgaserrerqwe
31 5 wraFASDvgaserrerqwe
32 6 wraFASDvgaserrerqwe
33 7 wraFASDvgaserrerqwe
34 8 wraFASDvgaserrerqwe
35 9 wraFASDvgaserrerqwe
36 10 wraFASDvgaserrerqwe
38 <Table Information of all tables>
39 <TableInfo>
40 <TableName> t1 </TableName>
41 <FieldInfo>
42 <FieldName> f1 </FieldName>
43 <Type> 0 </Type>
44 <Length> 4 </Length>
45 <Primary> 0 </Primary>
46 <Null> 0 </Null>
47 <Default> 0 </Default>
48 <DefaultValue> </DefaultValue>
49 </FieldInfo>
50 <FieldInfo>
51 <FieldName> f2 </FieldName>
52 <Type> 30 </Type>
53 <Length> 10000 </Length>
54 <Primary> 0 </Primary>
55 <Null> 0 </Null>
56 <Default> 0 </Default>
57 <DefaultValue> </DefaultValue>
58 </FieldInfo>
59 </TableInfo>
60 </Table Information of all tables>
61 <Index Information of all Indexs>
62 </Index Information of all Indexs>
63 update t1 set f2='LAKSHYA-CSQL' where f1>=3;
64 Statement Executed: Rows Affected = 8
65 echo select * from t1;
66 ---------------------------------------------------------
67 t1.f1 t1.f2
68 ---------------------------------------------------------
69 1 wraFASDvgaserrerqwe
70 2 wraFASDvgaserrerqwe
71 3 LAKSHYA-CSQL
72 4 LAKSHYA-CSQL
73 5 LAKSHYA-CSQL
74 6 LAKSHYA-CSQL
75 7 LAKSHYA-CSQL
76 8 LAKSHYA-CSQL
77 9 LAKSHYA-CSQL
78 10 LAKSHYA-CSQL
80 delete from t1 where f1<= 7;
81 Statement Executed: Rows Affected = 7
82 echo select * from t1;
83 ---------------------------------------------------------
84 t1.f1 t1.f2
85 ---------------------------------------------------------
86 8 LAKSHYA-CSQL
87 9 LAKSHYA-CSQL
88 10 LAKSHYA-CSQL
90 <Table Information of all tables>
91 <TableInfo>
92 <TableName> t1 </TableName>
93 <FieldInfo>
94 <FieldName> f1 </FieldName>
95 <Type> 0 </Type>
96 <Length> 4 </Length>
97 <Primary> 0 </Primary>
98 <Null> 0 </Null>
99 <Default> 0 </Default>
100 <DefaultValue> </DefaultValue>
101 </FieldInfo>
102 <FieldInfo>
103 <FieldName> f2 </FieldName>
104 <Type> 30 </Type>
105 <Length> 10000 </Length>
106 <Primary> 0 </Primary>
107 <Null> 0 </Null>
108 <Default> 0 </Default>
109 <DefaultValue> </DefaultValue>
110 </FieldInfo>
111 </TableInfo>
112 </Table Information of all tables>
113 <Index Information of all Indexs>
114 </Index Information of all Indexs>
115 Statement Executed