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