?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
adding test scripts
[csql.git] / test / sql / Order / exp.test004.ksh
blobbcfff01e19a77f32624a4396de2439f6ab29f28f
1 Statement Executed
2 Statement Executed: Rows Affected = 1
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 ---------------------------------------------------------
19 t1.f0 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
20 ---------------------------------------------------------
21 1 10 100 1000 Bijay 1000.000000 100000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0
22 2 11 110 1100 Jitendr 2000.000000 200000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0
23 3 12 120 1000 Nihar 3000.000000 300000.000000 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0
24 4 13 130 1100 Kishor 4000.000000 400000.000000 2009/3/4 11:59:59.0 2009/3/4 11:59:59.0
25 5 14 100 1000 Praba 5000.000000 500000.000000 2009/3/1 11:59:58.0 2009/3/1 11:59:59.0
26 6 15 110 1100 Sanjit 6000.000000 600000.000000 2009/3/2 11:59:57.0 2009/3/2 11:59:59.0
27 7 16 120 1000 Sanjay 7000.000000 700000.000000 2009/3/3 11:59:59.0 2009/3/3 11:59:59.0
28 1 17 130 1100 Arindam 8000.000000 800000.000000 2009/3/4 11:59:58.0 2009/3/4 11:59:59.0
29 2 10 100 1000 Bijay 9000.000000 900000.000000 2009/3/1 11:59:57.0 2009/3/1 11:59:59.0
30 3 11 110 1100 Jitendr 1000.000000 100000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0
31 4 12 120 1000 Nihar 2000.000000 200000.000000 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0
32 5 13 130 1100 Kishor 3000.000000 300000.000000 2009/3/5 11:59:56.0 2009/3/5 11:59:59.0
33 6 14 100 1000 Praba 4000.000000 400000.000000 2009/3/1 11:59:55.0 2009/3/4 11:59:59.0
34 7 15 110 1100 Sanjit 5000.000000 500000.000000 2009/3/2 11:59:56.0 2009/3/1 11:59:59.0
35 1 16 120 1000 Sanjay 6000.000000 600000.000000 2009/3/3 11:59:55.0 2009/3/3 11:59:59.0
36 2 17 130 1100 Arindam 7000.000000 700000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0
37
38 echo select f0,f4 from t1 order by f0 desc;
39 ---------------------------------------------------------
40 f0 f4
41 ---------------------------------------------------------
42 7 Sanjit
43 7 Sanjay
44 6 Praba
45 6 Sanjit
46 5 Kishor
47 5 Praba
48 4 Nihar
49 4 Kishor
50 3 Jitendr
51 3 Nihar
52 2 Arindam
53 2 Bijay
54 2 Jitendr
55 1 Sanjay
56 1 Arindam
57 1 Bijay
58
59 echo select f1,f4 from t1 order by f1 desc;
60 ---------------------------------------------------------
61 f1 f4
62 ---------------------------------------------------------
63 17 Arindam
64 17 Arindam
65 16 Sanjay
66 16 Sanjay
67 15 Sanjit
68 15 Sanjit
69 14 Praba
70 14 Praba
71 13 Kishor
72 13 Kishor
73 12 Nihar
74 12 Nihar
75 11 Jitendr
76 11 Jitendr
77 10 Bijay
78 10 Bijay
79
80 echo select f2,f4 from t1 order by f2 desc;
81 ---------------------------------------------------------
82 f2 f4
83 ---------------------------------------------------------
84 130 Arindam
85 130 Kishor
86 130 Arindam
87 130 Kishor
88 120 Sanjay
89 120 Nihar
90 120 Sanjay
91 120 Nihar
92 110 Sanjit
93 110 Jitendr
94 110 Sanjit
95 110 Jitendr
96 100 Praba
97 100 Bijay
98 100 Praba
99 100 Bijay
100
101 echo select f3,f4 from t1 order by f3 desc;
102 ---------------------------------------------------------
103 f3 f4
104 ---------------------------------------------------------
105 1100 Arindam
106 1100 Sanjit
107 1100 Kishor
108 1100 Jitendr
109 1100 Arindam
110 1100 Sanjit
111 1100 Kishor
112 1100 Jitendr
113 1000 Sanjay
114 1000 Praba
115 1000 Nihar
116 1000 Bijay
117 1000 Sanjay
118 1000 Praba
119 1000 Nihar
120 1000 Bijay
121
122 echo select f4,f4 from t1 order by f4 desc;
123 ---------------------------------------------------------
124 f4 f4
125 ---------------------------------------------------------
126 Sanjit Sanjit
127 Sanjit Sanjit
128 Sanjay Sanjay
129 Sanjay Sanjay
130 Praba Praba
131 Praba Praba
132 Nihar Nihar
133 Nihar Nihar
134 Kishor Kishor
135 Kishor Kishor
136 Jitendr Jitendr
137 Jitendr Jitendr
138 Bijay Bijay
139 Bijay Bijay
140 Arindam Arindam
141 Arindam Arindam
142
143 echo select f5,f4 from t1 order by f5 desc;
144 ---------------------------------------------------------
145 f5 f4
146 ---------------------------------------------------------
147 9000.000000 Bijay
148 8000.000000 Arindam
149 7000.000000 Arindam
150 7000.000000 Sanjay
151 6000.000000 Sanjay
152 6000.000000 Sanjit
153 5000.000000 Sanjit
154 5000.000000 Praba
155 4000.000000 Praba
156 4000.000000 Kishor
157 3000.000000 Kishor
158 3000.000000 Nihar
159 2000.000000 Nihar
160 2000.000000 Jitendr
161 1000.000000 Jitendr
162 1000.000000 Bijay
163
164 echo select f6,f4 from t1 order by f6 desc;
165 ---------------------------------------------------------
166 f6 f4
167 ---------------------------------------------------------
168 900000.000000 Bijay
169 800000.000000 Arindam
170 700000.000000 Arindam
171 700000.000000 Sanjay
172 600000.000000 Sanjay
173 600000.000000 Sanjit
174 500000.000000 Sanjit
175 500000.000000 Praba
176 400000.000000 Praba
177 400000.000000 Kishor
178 300000.000000 Kishor
179 300000.000000 Nihar
180 200000.000000 Nihar
181 200000.000000 Jitendr
182 100000.000000 Jitendr
183 100000.000000 Bijay
184
185 echo select f7,f4 from t1 order by f7 desc;
186 ---------------------------------------------------------
187 f7 f4
188 ---------------------------------------------------------
189 2009/3/5 Kishor
190 2009/3/4 Arindam
191 2009/3/4 Kishor
192 2009/3/3 Sanjay
193 2009/3/3 Nihar
194 2009/3/3 Sanjay
195 2009/3/3 Nihar
196 2009/3/2 Sanjit
197 2009/3/2 Jitendr
198 2009/3/2 Sanjit
199 2009/3/2 Jitendr
200 2009/3/1 Arindam
201 2009/3/1 Praba
202 2009/3/1 Bijay
203 2009/3/1 Praba
204 2009/3/1 Bijay
205
206 echo select f8,f4 from t1 order by f8 desc;
207 ---------------------------------------------------------
208 f8 f4
209 ---------------------------------------------------------
210 11:59:59.0 Arindam
211 11:59:59.0 Sanjay
212 11:59:59.0 Kishor
213 11:59:59.0 Bijay
214 11:59:58.0 Jitendr
215 11:59:58.0 Arindam
216 11:59:58.0 Praba
217 11:59:58.0 Jitendr
218 11:59:57.0 Nihar
219 11:59:57.0 Bijay
220 11:59:57.0 Sanjit
221 11:59:57.0 Nihar
222 11:59:56.0 Sanjit
223 11:59:56.0 Kishor
224 11:59:55.0 Sanjay
225 11:59:55.0 Praba
226
227 echo select f9,f4 from t1 order by f9 desc;
228 ---------------------------------------------------------
229 f9 f4
230 ---------------------------------------------------------
231 2009/3/5 11:59:59.0 Kishor
232 2009/3/4 11:59:59.0 Praba
233 2009/3/4 11:59:59.0 Arindam
234 2009/3/4 11:59:59.0 Kishor
235 2009/3/3 11:59:59.0 Sanjay
236 2009/3/3 11:59:59.0 Nihar
237 2009/3/3 11:59:59.0 Sanjay
238 2009/3/3 11:59:59.0 Nihar
239 2009/3/2 11:59:59.0 Jitendr
240 2009/3/2 11:59:59.0 Sanjit
241 2009/3/2 11:59:59.0 Jitendr
242 2009/3/1 11:59:59.0 Arindam
243 2009/3/1 11:59:59.0 Sanjit
244 2009/3/1 11:59:59.0 Bijay
245 2009/3/1 11:59:59.0 Praba
246 2009/3/1 11:59:59.0 Bijay
247
248 echo select f0,f1,f4 from t1 order by f0,f1 desc;
249 ---------------------------------------------------------
250 f0 f1 f4
251 ---------------------------------------------------------
252 1 17 Arindam
253 1 16 Sanjay
254 1 10 Bijay
255 2 17 Arindam
256 2 11 Jitendr
257 2 10 Bijay
258 3 12 Nihar
259 3 11 Jitendr
260 4 13 Kishor
261 4 12 Nihar
262 5 14 Praba
263 5 13 Kishor
264 6 15 Sanjit
265 6 14 Praba
266 7 16 Sanjay
267 7 15 Sanjit
268
269 echo select f0,f1,f4 from t1 order by f1,f0 desc;
270 ---------------------------------------------------------
271 f0 f1 f4
272 ---------------------------------------------------------
273 2 10 Bijay
274 1 10 Bijay
275 3 11 Jitendr
276 2 11 Jitendr
277 4 12 Nihar
278 3 12 Nihar
279 5 13 Kishor
280 4 13 Kishor
281 6 14 Praba
282 5 14 Praba
283 7 15 Sanjit
284 6 15 Sanjit
285 7 16 Sanjay
286 1 16 Sanjay
287 2 17 Arindam
288 1 17 Arindam
289
290 echo select f2,f3,f4 from t1 order by f2,f3,f4 desc;
291 ---------------------------------------------------------
292 f2 f3 f4
293 ---------------------------------------------------------
294 100 1000 Praba
295 100 1000 Praba
296 100 1000 Bijay
297 100 1000 Bijay
298 110 1100 Sanjit
299 110 1100 Sanjit
300 110 1100 Jitendr
301 110 1100 Jitendr
302 120 1000 Sanjay
303 120 1000 Sanjay
304 120 1000 Nihar
305 120 1000 Nihar
306 130 1100 Kishor
307 130 1100 Kishor
308 130 1100 Arindam
309 130 1100 Arindam
310
311 echo select f7,f8,f4 from t1 order by f7,f8 desc;
312 ---------------------------------------------------------
313 f7 f8 f4
314 ---------------------------------------------------------
315 2009/3/1 11:59:59.0 Arindam
316 2009/3/1 11:59:59.0 Bijay
317 2009/3/1 11:59:58.0 Praba
318 2009/3/1 11:59:57.0 Bijay
319 2009/3/1 11:59:55.0 Praba
320 2009/3/2 11:59:58.0 Jitendr
321 2009/3/2 11:59:58.0 Jitendr
322 2009/3/2 11:59:57.0 Sanjit
323 2009/3/2 11:59:56.0 Sanjit
324 2009/3/3 11:59:59.0 Sanjay
325 2009/3/3 11:59:57.0 Nihar
326 2009/3/3 11:59:57.0 Nihar
327 2009/3/3 11:59:55.0 Sanjay
328 2009/3/4 11:59:59.0 Kishor
329 2009/3/4 11:59:58.0 Arindam
330 2009/3/5 11:59:56.0 Kishor
331
332 echo select f7,f8,f9,f4 from t1 order by f7,f8,f9 desc;
333 ---------------------------------------------------------
334 f7 f8 f9 f4
335 ---------------------------------------------------------
336 2009/3/1 11:59:55.0 2009/3/4 11:59:59.0 Praba
337 2009/3/1 11:59:57.0 2009/3/1 11:59:59.0 Bijay
338 2009/3/1 11:59:58.0 2009/3/1 11:59:59.0 Praba
339 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0 Arindam
340 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0 Bijay
341 2009/3/2 11:59:56.0 2009/3/1 11:59:59.0 Sanjit
342 2009/3/2 11:59:57.0 2009/3/2 11:59:59.0 Sanjit
343 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0 Jitendr
344 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0 Jitendr
345 2009/3/3 11:59:55.0 2009/3/3 11:59:59.0 Sanjay
346 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0 Nihar
347 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0 Nihar
348 2009/3/4 11:59:58.0 2009/3/4 11:59:59.0 Arindam
349 2009/3/4 11:59:59.0 2009/3/4 11:59:59.0 Kishor
350 2009/3/3 11:59:59.0 2009/3/3 11:59:59.0 Sanjay
351 2009/3/5 11:59:56.0 2009/3/5 11:59:59.0 Kishor
352
353 echo select f2,f3,f5,f6,f7,f8,f9,f4 from t1 order by f2,f3,f5,f6,f7,f8,f9 desc;
354 ---------------------------------------------------------
355 f2 f3 f5 f6 f7 f8 f9 f4
356 ---------------------------------------------------------
357 100 1000 1000.000000 100000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0 Bijay
358 100 1000 4000.000000 400000.000000 2009/3/1 11:59:55.0 2009/3/4 11:59:59.0 Praba
359 100 1000 9000.000000 900000.000000 2009/3/1 11:59:57.0 2009/3/1 11:59:59.0 Bijay
360 110 1100 1000.000000 100000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0 Jitendr
361 110 1100 2000.000000 200000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0 Jitendr
362 110 1100 5000.000000 500000.000000 2009/3/2 11:59:56.0 2009/3/1 11:59:59.0 Sanjit
363 120 1000 2000.000000 200000.000000 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0 Nihar
364 120 1000 3000.000000 300000.000000 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0 Nihar
365 100 1000 5000.000000 500000.000000 2009/3/1 11:59:58.0 2009/3/1 11:59:59.0 Praba
366 120 1000 6000.000000 600000.000000 2009/3/3 11:59:55.0 2009/3/3 11:59:59.0 Sanjay
367 130 1100 3000.000000 300000.000000 2009/3/5 11:59:56.0 2009/3/5 11:59:59.0 Kishor
368 130 1100 4000.000000 400000.000000 2009/3/4 11:59:59.0 2009/3/4 11:59:59.0 Kishor
369 110 1100 6000.000000 600000.000000 2009/3/2 11:59:57.0 2009/3/2 11:59:59.0 Sanjit
370 120 1000 7000.000000 700000.000000 2009/3/3 11:59:59.0 2009/3/3 11:59:59.0 Sanjay
371 130 1100 7000.000000 700000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0 Arindam
372 130 1100 8000.000000 800000.000000 2009/3/4 11:59:58.0 2009/3/4 11:59:59.0 Arindam
373
374 Statement Executed
Main memory database SQL engine (cvs import)