?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
adding test scripts
[csql.git] / test / tools / csql / exp.test045.ksh
blob35df4534aef935e9227954730d9f30e764bd42eb
1 Statement Executed
2 Statement Executed
3 Statement Executed: Rows Affected = 1
4 Statement Executed: Rows Affected = 1
5 Statement Executed: Rows Affected = 1
6 Statement Executed: Rows Affected = 1
7 Statement Executed: Rows Affected = 1
8 Statement Executed: Rows Affected = 1
9 Statement Executed: Rows Affected = 1
10 Statement Executed: Rows Affected = 1
11 Statement Executed: Rows Affected = 1
12 Statement Executed: Rows Affected = 1
13 Statement Executed: Rows Affected = 1
14 Statement Executed: Rows Affected = 1
15 Statement Executed: Rows Affected = 1
16 Statement Executed: Rows Affected = 1
17 Statement Executed: Rows Affected = 1
18 Statement Executed: Rows Affected = 1
19 Statement Executed: Rows Affected = 1
20 Statement Executed: Rows Affected = 1
21 Statement Executed: Rows Affected = 1
22 Statement Executed: Rows Affected = 1
23 Statement Executed: Rows Affected = 1
24 Statement Executed: Rows Affected = 1
25 Statement Executed: Rows Affected = 1
26 Statement Executed: Rows Affected = 1
27 Statement Executed: Rows Affected = 1
28 Statement Executed: Rows Affected = 1
29 Statement Executed: Rows Affected = 1
30 Statement Executed: Rows Affected = 1
31 Statement Executed: Rows Affected = 1
32 Statement Executed: Rows Affected = 1
33 Statement Executed: Rows Affected = 1
34 Statement Executed: Rows Affected = 1
35 Statement Executed: Rows Affected = 1
36 Statement Executed: Rows Affected = 1
37 Statement Executed: Rows Affected = 1
38 Statement Executed: Rows Affected = 1
39 Statement Executed: Rows Affected = 1
40 Statement Executed: Rows Affected = 1
41 Statement Executed: Rows Affected = 1
42 Statement Executed: Rows Affected = 1
43 Statement Executed: Rows Affected = 1
44 Statement Executed: Rows Affected = 1
45 Statement Executed: Rows Affected = 1
46 Statement Executed: Rows Affected = 1
47 Statement Executed: Rows Affected = 1
48 Statement Executed: Rows Affected = 1
49 Statement Executed: Rows Affected = 1
50 Statement Executed: Rows Affected = 1
51 Statement Executed: Rows Affected = 1
52 Statement Executed: Rows Affected = 1
53 echo select * from t1;
54 ---------------------------------------------------------
55 t1.f1 t1.f2
56 ---------------------------------------------------------
57 1 1
58 2 2
59 3 3
60 4 4
61 5 5
62 6 6
63 7 7
64 8 8
65 9 9
66 10 10
67 11 11
68 12 12
69 13 13
70 14 14
71 15 15
72 16 16
73 17 17
74 18 18
75 19 19
76 20 20
77 21 21
78 22 22
79 23 23
80 24 24
81 25 25
82 26 26
83 27 27
84 28 28
85 29 29
86 30 30
87 31 31
88 32 32
89 33 33
90 34 34
91 35 35
92 36 36
93 37 37
94 38 38
95 39 39
96 40 40
97 41 41
98 42 42
99 43 43
100 44 44
101 45 45
102 46 46
103 47 47
104 48 48
105 49 49
106 50 50
107
108 50 rows selected
109 echo select * from t1 where f1=10;
110 ---------------------------------------------------------
111 t1.f1 t1.f2
112 ---------------------------------------------------------
113 10 10
114
115 echo select * from t1 where f1=99;
116 ---------------------------------------------------------
117 t1.f1 t1.f2
118 ---------------------------------------------------------
119
120 echo select * from t1 where f1>27;
121 ---------------------------------------------------------
122 t1.f1 t1.f2
123 ---------------------------------------------------------
124 28 28
125 29 29
126 30 30
127 31 31
128 32 32
129 33 33
130 34 34
131 35 35
132 36 36
133 37 37
134 38 38
135 39 39
136 40 40
137 41 41
138 42 42
139 43 43
140 44 44
141 45 45
142 46 46
143 47 47
144 48 48
145 49 49
146 50 50
147
148 echo select * from t1 where f1>=27;
149 ---------------------------------------------------------
150 t1.f1 t1.f2
151 ---------------------------------------------------------
152 27 27
153 28 28
154 29 29
155 30 30
156 31 31
157 32 32
158 33 33
159 34 34
160 35 35
161 36 36
162 37 37
163 38 38
164 39 39
165 40 40
166 41 41
167 42 42
168 43 43
169 44 44
170 45 45
171 46 46
172 47 47
173 48 48
174 49 49
175 50 50
176
177 echo select * from t1 where f1<=27;
178 ---------------------------------------------------------
179 t1.f1 t1.f2
180 ---------------------------------------------------------
181 1 1
182 2 2
183 3 3
184 4 4
185 5 5
186 6 6
187 7 7
188 8 8
189 9 9
190 10 10
191 11 11
192 12 12
193 13 13
194 14 14
195 15 15
196 16 16
197 17 17
198 18 18
199 19 19
200 20 20
201 21 21
202 22 22
203 23 23
204 24 24
205 25 25
206 26 26
207 27 27
208
209 echo select * from t1 where f1<27;
210 ---------------------------------------------------------
211 t1.f1 t1.f2
212 ---------------------------------------------------------
213 1 1
214 2 2
215 3 3
216 4 4
217 5 5
218 6 6
219 7 7
220 8 8
221 9 9
222 10 10
223 11 11
224 12 12
225 13 13
226 14 14
227 15 15
228 16 16
229 17 17
230 18 18
231 19 19
232 20 20
233 21 21
234 22 22
235 23 23
236 24 24
237 25 25
238 26 26
239
240 echo select * from t1 where f1>99;
241 ---------------------------------------------------------
242 t1.f1 t1.f2
243 ---------------------------------------------------------
244
245 echo select * from t1 where f1<-1;
246 ---------------------------------------------------------
247 t1.f1 t1.f2
248 ---------------------------------------------------------
249
250 echo select * from t1 where f1=40 and f1> 27;
251 ---------------------------------------------------------
252 t1.f1 t1.f2
253 ---------------------------------------------------------
254 40 40
255
256 echo select * from t1 where f1> 27 and f1=40;
257 ---------------------------------------------------------
258 t1.f1 t1.f2
259 ---------------------------------------------------------
260 40 40
261
262 echo select * from t1 where f1> 27 and f2=40;
263 ---------------------------------------------------------
264 t1.f1 t1.f2
265 ---------------------------------------------------------
266 40 40
267
268 echo select * from t1 where f1 >10 and f1 <20;
269 ---------------------------------------------------------
270 t1.f1 t1.f2
271 ---------------------------------------------------------
272 11 11
273 12 12
274 13 13
275 14 14
276 15 15
277 16 16
278 17 17
279 18 18
280 19 19
281
282 echo select * from t1 where f1 >10 and f1 <20 and f2=15;
283 ---------------------------------------------------------
284 t1.f1 t1.f2
285 ---------------------------------------------------------
286 15 15
287
288 Statement Executed
Main memory database SQL engine (cvs import)