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