?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
core reorg
[csql.git] / test / sql / Distinct / exp.test002.ksh
blob6f14d3052756c8b522bdf99f6d247b94cae39ffc
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 distinct f0 from t1;
39 ---------------------------------------------------------
40 f0
41 ---------------------------------------------------------
42 1
43 2
44 3
45 4
46 5
47 6
48 7
49
50 echo select distinct f1 from t1;
51 ---------------------------------------------------------
52 f1
53 ---------------------------------------------------------
54 10
55 11
56 12
57 13
58 14
59 15
60 16
61 17
62
63 echo select distinct f2 from t1;
64 ---------------------------------------------------------
65 f2
66 ---------------------------------------------------------
67 100
68 110
69 120
70 130
71
72 echo select distinct f3 from t1;
73 ---------------------------------------------------------
74 f3
75 ---------------------------------------------------------
76 1000
77 1100
78
79 echo select distinct f4 from t1;
80 ---------------------------------------------------------
81 f4
82 ---------------------------------------------------------
83 Bijay
84 Jitendr
85 Nihar
86 Kishor
87 Praba
88 Sanjit
89 Sanjay
90 Arindam
91
92 echo select distinct f5 from t1;
93 ---------------------------------------------------------
94 f5
95 ---------------------------------------------------------
96 1000.000000
97 2000.000000
98 3000.000000
99 4000.000000
100 5000.000000
101 6000.000000
102 7000.000000
103 8000.000000
104 9000.000000
105
106 echo select distinct f6 from t1;
107 ---------------------------------------------------------
108 f6
109 ---------------------------------------------------------
110 100000.000000
111 200000.000000
112 300000.000000
113 400000.000000
114 500000.000000
115 600000.000000
116 700000.000000
117 800000.000000
118 900000.000000
119
120 echo select distinct f7 from t1;
121 ---------------------------------------------------------
122 f7
123 ---------------------------------------------------------
124 2009/3/1
125 2009/3/2
126 2009/3/3
127 2009/3/4
128 2009/3/5
129
130 echo select distinct f8 from t1;
131 ---------------------------------------------------------
132 f8
133 ---------------------------------------------------------
134 11:59:59.0
135 11:59:58.0
136 11:59:57.0
137 11:59:56.0
138 11:59:55.0
139
140 echo select distinct f9 from t1;
141 ---------------------------------------------------------
142 f9
143 ---------------------------------------------------------
144 2009/3/1 11:59:59.0
145 2009/3/2 11:59:59.0
146 2009/3/3 11:59:59.0
147 2009/3/4 11:59:59.0
148 2009/3/5 11:59:59.0
149
150 echo select distinct f1,f2,f3 from t1;
151 ---------------------------------------------------------
152 f1 f2 f3
153 ---------------------------------------------------------
154 10 100 1000
155 11 110 1100
156 12 120 1000
157 13 130 1100
158 14 100 1000
159 15 110 1100
160 16 120 1000
161 17 130 1100
162
163 echo select distinct f0,f1,f2,f3 from t1;
164 ---------------------------------------------------------
165 f0 f1 f2 f3
166 ---------------------------------------------------------
167 1 10 100 1000
168 2 11 110 1100
169 3 12 120 1000
170 4 13 130 1100
171 5 14 100 1000
172 6 15 110 1100
173 7 16 120 1000
174 1 17 130 1100
175 2 10 100 1000
176 3 11 110 1100
177 4 12 120 1000
178 5 13 130 1100
179 6 14 100 1000
180 7 15 110 1100
181 1 16 120 1000
182 2 17 130 1100
183
184 echo select distinct f2,f3 from t1;
185 ---------------------------------------------------------
186 f2 f3
187 ---------------------------------------------------------
188 100 1000
189 110 1100
190 120 1000
191 130 1100
192
193 echo select distinct f2,f3,f4,f5 from t1;
194 ---------------------------------------------------------
195 f2 f3 f4 f5
196 ---------------------------------------------------------
197 100 1000 Bijay 1000.000000
198 110 1100 Jitendr 2000.000000
199 120 1000 Nihar 3000.000000
200 130 1100 Kishor 4000.000000
201 100 1000 Praba 5000.000000
202 110 1100 Sanjit 6000.000000
203 120 1000 Sanjay 7000.000000
204 130 1100 Arindam 8000.000000
205 100 1000 Bijay 9000.000000
206 110 1100 Jitendr 1000.000000
207 120 1000 Nihar 2000.000000
208 130 1100 Kishor 3000.000000
209 100 1000 Praba 4000.000000
210 110 1100 Sanjit 5000.000000
211 120 1000 Sanjay 6000.000000
212 130 1100 Arindam 7000.000000
213
214 echo select distinct f2,f3,f4,f5,f6 from t1;
215 ---------------------------------------------------------
216 f2 f3 f4 f5 f6
217 ---------------------------------------------------------
218 100 1000 Bijay 1000.000000 100000.000000
219 110 1100 Jitendr 2000.000000 200000.000000
220 120 1000 Nihar 3000.000000 300000.000000
221 130 1100 Kishor 4000.000000 400000.000000
222 100 1000 Praba 5000.000000 500000.000000
223 110 1100 Sanjit 6000.000000 600000.000000
224 120 1000 Sanjay 7000.000000 700000.000000
225 130 1100 Arindam 8000.000000 800000.000000
226 100 1000 Bijay 9000.000000 900000.000000
227 110 1100 Jitendr 1000.000000 100000.000000
228 120 1000 Nihar 2000.000000 200000.000000
229 130 1100 Kishor 3000.000000 300000.000000
230 100 1000 Praba 4000.000000 400000.000000
231 110 1100 Sanjit 5000.000000 500000.000000
232 120 1000 Sanjay 6000.000000 600000.000000
233 130 1100 Arindam 7000.000000 700000.000000
234
235 echo select distinct f4,f6,f2,f5,f3,f7,f8 from t1;
236 ---------------------------------------------------------
237 f4 f6 f2 f5 f3 f7 f8
238 ---------------------------------------------------------
239 Bijay 100000.000000 100 1000.000000 1000 2009/3/1 11:59:59.0
240 Jitendr 200000.000000 110 2000.000000 1100 2009/3/2 11:59:58.0
241 Nihar 300000.000000 120 3000.000000 1000 2009/3/3 11:59:57.0
242 Kishor 400000.000000 130 4000.000000 1100 2009/3/4 11:59:59.0
243 Praba 500000.000000 100 5000.000000 1000 2009/3/1 11:59:58.0
244 Sanjit 600000.000000 110 6000.000000 1100 2009/3/2 11:59:57.0
245 Sanjay 700000.000000 120 7000.000000 1000 2009/3/3 11:59:59.0
246 Arindam 800000.000000 130 8000.000000 1100 2009/3/4 11:59:58.0
247 Bijay 900000.000000 100 9000.000000 1000 2009/3/1 11:59:57.0
248 Jitendr 100000.000000 110 1000.000000 1100 2009/3/2 11:59:58.0
249 Nihar 200000.000000 120 2000.000000 1000 2009/3/3 11:59:57.0
250 Kishor 300000.000000 130 3000.000000 1100 2009/3/5 11:59:56.0
251 Praba 400000.000000 100 4000.000000 1000 2009/3/1 11:59:55.0
252 Sanjit 500000.000000 110 5000.000000 1100 2009/3/2 11:59:56.0
253 Sanjay 600000.000000 120 6000.000000 1000 2009/3/3 11:59:55.0
254 Arindam 700000.000000 130 7000.000000 1100 2009/3/1 11:59:59.0
255
256 echo select distinct f2,f3,f4,f5,f8,f7,f9,f6 from t1;
257 ---------------------------------------------------------
258 f2 f3 f4 f5 f8 f7 f9 f6
259 ---------------------------------------------------------
260 100 1000 Bijay 1000.000000 11:59:59.0 2009/3/1 2009/3/1 11:59:59.0 100000.000000
261 110 1100 Jitendr 2000.000000 11:59:58.0 2009/3/2 2009/3/2 11:59:59.0 200000.000000
262 120 1000 Nihar 3000.000000 11:59:57.0 2009/3/3 2009/3/3 11:59:59.0 300000.000000
263 130 1100 Kishor 4000.000000 11:59:59.0 2009/3/4 2009/3/4 11:59:59.0 400000.000000
264 100 1000 Praba 5000.000000 11:59:58.0 2009/3/1 2009/3/1 11:59:59.0 500000.000000
265 110 1100 Sanjit 6000.000000 11:59:57.0 2009/3/2 2009/3/2 11:59:59.0 600000.000000
266 120 1000 Sanjay 7000.000000 11:59:59.0 2009/3/3 2009/3/3 11:59:59.0 700000.000000
267 130 1100 Arindam 8000.000000 11:59:58.0 2009/3/4 2009/3/4 11:59:59.0 800000.000000
268 100 1000 Bijay 9000.000000 11:59:57.0 2009/3/1 2009/3/1 11:59:59.0 900000.000000
269 110 1100 Jitendr 1000.000000 11:59:58.0 2009/3/2 2009/3/2 11:59:59.0 100000.000000
270 120 1000 Nihar 2000.000000 11:59:57.0 2009/3/3 2009/3/3 11:59:59.0 200000.000000
271 130 1100 Kishor 3000.000000 11:59:56.0 2009/3/5 2009/3/5 11:59:59.0 300000.000000
272 100 1000 Praba 4000.000000 11:59:55.0 2009/3/1 2009/3/4 11:59:59.0 400000.000000
273 110 1100 Sanjit 5000.000000 11:59:56.0 2009/3/2 2009/3/1 11:59:59.0 500000.000000
274 120 1000 Sanjay 6000.000000 11:59:55.0 2009/3/3 2009/3/3 11:59:59.0 600000.000000
275 130 1100 Arindam 7000.000000 11:59:59.0 2009/3/1 2009/3/1 11:59:59.0 700000.000000
276
277 Statement Executed
Main memory database SQL engine (cvs import)