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