?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
adding test scripts
[csql.git] / test / sql / Order / exp.test008.ksh
blob644bb5409151985554660e954707c842c32dd93f
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
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 Statement Executed: Rows Affected = 1
20 Statement Executed: Rows Affected = 1
21 Statement Executed: Rows Affected = 1
22 Statement Executed: Rows Affected = 1
23 Statement Executed: Rows Affected = 1
24 Statement Executed: Rows Affected = 1
25 Statement Executed
26 Statement Executed: Rows Affected = 1
27 Statement Executed: Rows Affected = 1
28 Statement Executed: Rows Affected = 1
29 Statement Executed: Rows Affected = 1
30 Statement Executed: Rows Affected = 1
31 Statement Executed: Rows Affected = 1
32 Statement Executed: Rows Affected = 1
33 Statement Executed: Rows Affected = 1
34 Statement Executed: Rows Affected = 1
35 Statement Executed: Rows Affected = 1
36 Statement Executed: Rows Affected = 1
37 echo SELECT * FROM t1;
38 ---------------------------------------------------------
39 t1.f1 t1.f2 t1.f3 t1.f4
40 ---------------------------------------------------------
41 3 AAA 2.500000 2008/7/1
42 2 AAA 2.500000 2008/7/2
43 4 GGG 4.500000 2008/7/3
44 1 DEF 1.500000 2008/7/1
45 6 CCC 6.500000 2008/7/2
46 5 HHH 5.500000 2008/7/3
47 2 AAA 2.500000 2008/7/1
48 6 CCC 6.500000 2008/7/4
49 3 ABB 2.600000 2008/7/5
50 2 BBB 1.600000 2008/7/4
51 1 DDD 1.600000 2008/7/1
52
53 echo SELECT * FROM t2;
54 ---------------------------------------------------------
55 t2.f1 t2.f2 t2.f3 t2.f4
56 ---------------------------------------------------------
57 1 DEF 1.500000 2008/7/1
58 9 QQQ 9.500000 2008/7/2
59 3 MMM 2.500000 2008/7/3
60 4 GGG 4.600000 2008/7/1
61 7 PPP 7.500000 2008/7/2
62 8 NNN 8.500000 2008/7/3
63 9 QQQ 9.500000 2008/7/1
64 8 AAA 8.500000 2008/7/4
65 7 AAA 7.500000 2008/7/5
66 9 BBB 9.800000 2008/7/4
67 8 EEE 8.800000 2008/7/1
68
69 echo SELECT * FROM t3;
70 ---------------------------------------------------------
71 t3.f1 t3.f2 t3.f3 t3.f4
72 ---------------------------------------------------------
73 1 DEF 1.500000 2008/7/1
74 2 AAA 2.500000 2008/7/2
75 7 PPP 7.500000 2008/7/3
76 8 NNN 8.500000 2008/7/4
77 9 QQQ 9.500000 2008/7/1
78 10 NNN 10.500000 2008/7/2
79 1 DEF 1.500000 2008/7/3
80 2 AAA 2.500000 2008/7/4
81 7 PPP 7.500000 2008/7/1
82 8 NNN 8.500000 2008/7/2
83 10 NNN 10.500000 2008/7/4
84
85 echo SELECT * FROM t1 INNER JOIN t2 ON t1.f1 = t2.f1 ORDER BY t1.f1;
86 ---------------------------------------------------------
87 t1.f1 t1.f2 t1.f3 t1.f4 t2.f1 t2.f2 t2.f3 t2.f4
88 ---------------------------------------------------------
89 1 DDD 1.600000 2008/7/1 1 DEF 1.500000 2008/7/1
90 1 DEF 1.500000 2008/7/1 1 DEF 1.500000 2008/7/1
91 3 ABB 2.600000 2008/7/5 3 MMM 2.500000 2008/7/3
92 3 AAA 2.500000 2008/7/1 3 MMM 2.500000 2008/7/3
93 4 GGG 4.500000 2008/7/3 4 GGG 4.600000 2008/7/1
94
95 echo SELECT t1.f1, t2.f1, t3.f1 FROM t1 INNER JOIN t2 ON t1.f1 = t2.f1 INNER JOIN t3 ON t2.f1 = t3.f1 ORDER BY t1.f1;
96 ---------------------------------------------------------
97 t1.f1 t2.f1 t3.f1
98 ---------------------------------------------------------
99 1 1 1
100 1 1 1
101 1 1 1
102 1 1 1
103
104 echo SELECT * FROM t1 INNER JOIN t2 ON t1.f1 = t2.f1 ORDER BY t1.f1,t2.f1;
105 ---------------------------------------------------------
106 t1.f1 t1.f2 t1.f3 t1.f4 t2.f1 t2.f2 t2.f3 t2.f4
107 ---------------------------------------------------------
108 1 DDD 1.600000 2008/7/1 1 DEF 1.500000 2008/7/1
109 1 DEF 1.500000 2008/7/1 1 DEF 1.500000 2008/7/1
110 3 ABB 2.600000 2008/7/5 3 MMM 2.500000 2008/7/3
111 3 AAA 2.500000 2008/7/1 3 MMM 2.500000 2008/7/3
112 4 GGG 4.500000 2008/7/3 4 GGG 4.600000 2008/7/1
113
114 echo SELECT t1.f1, t3.f1, t2.f1 FROM t1 INNER JOIN t2 ON t1.f1 = t2.f1 INNER JOIN t3 ON t3.f1 = t1.f1 ORDER BY t1.f1,t3.f1,t2.f1;
115 ---------------------------------------------------------
116 t1.f1 t3.f1 t2.f1
117 ---------------------------------------------------------
118 1 1 1
119 1 1 1
120 1 1 1
121 1 1 1
122
123 echo SELECT t1.f1, t3.f1, t2.f1 FROM t1 INNER JOIN t2 ON t1.f1 = t2.f1 INNER JOIN t3 ON t3.f1 = t1.f1 ORDER BY t1.f1 DESC,t3.f1 DESC,t2.f1 DESC;
124 ---------------------------------------------------------
125 t1.f1 t3.f1 t2.f1
126 ---------------------------------------------------------
127 1 1 1
128 1 1 1
129 1 1 1
130 1 1 1
131
132 echo SELECT t1.f1, t2.f1, t1.f4, t2.f4 FROM t1 INNER JOIN t2 ON t1.f1 < 2 OR t1.f3 < 2.5 ORDER BY t1.f4, t2.f4;
133 ---------------------------------------------------------
134 t1.f1 t2.f1 t1.f4 t2.f4
135 ---------------------------------------------------------
136 1 8 2008/7/1 2008/7/1
137 1 9 2008/7/1 2008/7/1
138 1 4 2008/7/1 2008/7/1
139 1 1 2008/7/1 2008/7/1
140 1 8 2008/7/1 2008/7/1
141 1 9 2008/7/1 2008/7/1
142 1 4 2008/7/1 2008/7/1
143 1 1 2008/7/1 2008/7/1
144 1 7 2008/7/1 2008/7/2
145 1 9 2008/7/1 2008/7/2
146 1 7 2008/7/1 2008/7/2
147 1 9 2008/7/1 2008/7/2
148 1 8 2008/7/1 2008/7/3
149 1 3 2008/7/1 2008/7/3
150 1 8 2008/7/1 2008/7/3
151 1 3 2008/7/1 2008/7/3
152 1 9 2008/7/1 2008/7/4
153 1 8 2008/7/1 2008/7/4
154 1 9 2008/7/1 2008/7/4
155 1 8 2008/7/1 2008/7/4
156 1 7 2008/7/1 2008/7/5
157 1 7 2008/7/1 2008/7/5
158 2 8 2008/7/4 2008/7/1
159 2 9 2008/7/4 2008/7/1
160 2 4 2008/7/4 2008/7/1
161 2 1 2008/7/4 2008/7/1
162 2 7 2008/7/4 2008/7/2
163 2 9 2008/7/4 2008/7/2
164 2 8 2008/7/4 2008/7/3
165 2 3 2008/7/4 2008/7/3
166 2 9 2008/7/4 2008/7/4
167 2 8 2008/7/4 2008/7/4
168 2 7 2008/7/4 2008/7/5
169
170 echo SELECT t1.f1, t2.f1, t1.f4, t2.f4 FROM t1 INNER JOIN t2 ON t1.f1 < 2 OR t1.f3 < 2.5 ORDER BY t1.f1, t1.f4 DESC ;
171 ---------------------------------------------------------
172 t1.f1 t2.f1 t1.f4 t2.f4
173 ---------------------------------------------------------
174 1 8 2008/7/1 2008/7/1
175 1 9 2008/7/1 2008/7/4
176 1 7 2008/7/1 2008/7/5
177 1 8 2008/7/1 2008/7/4
178 1 9 2008/7/1 2008/7/1
179 1 8 2008/7/1 2008/7/3
180 1 7 2008/7/1 2008/7/2
181 1 4 2008/7/1 2008/7/1
182 1 3 2008/7/1 2008/7/3
183 1 9 2008/7/1 2008/7/2
184 1 1 2008/7/1 2008/7/1
185 1 8 2008/7/1 2008/7/1
186 1 9 2008/7/1 2008/7/4
187 1 7 2008/7/1 2008/7/5
188 1 8 2008/7/1 2008/7/4
189 1 9 2008/7/1 2008/7/1
190 1 8 2008/7/1 2008/7/3
191 1 7 2008/7/1 2008/7/2
192 1 4 2008/7/1 2008/7/1
193 1 3 2008/7/1 2008/7/3
194 1 9 2008/7/1 2008/7/2
195 1 1 2008/7/1 2008/7/1
196 2 8 2008/7/4 2008/7/1
197 2 9 2008/7/4 2008/7/4
198 2 7 2008/7/4 2008/7/5
199 2 8 2008/7/4 2008/7/4
200 2 9 2008/7/4 2008/7/1
201 2 8 2008/7/4 2008/7/3
202 2 7 2008/7/4 2008/7/2
203 2 4 2008/7/4 2008/7/1
204 2 3 2008/7/4 2008/7/3
205 2 9 2008/7/4 2008/7/2
206 2 1 2008/7/4 2008/7/1
207
208 echo SELECT t1.f1, t2.f4, t2.f1 FROM t1 INNER JOIN t2 ON t1.f1 < 2 OR t2.f1 < 2 ORDER BY t1.f1, t2.f4 ;
209 ---------------------------------------------------------
210 t1.f1 t2.f4 t2.f1
211 ---------------------------------------------------------
212 1 2008/7/1 8
213 1 2008/7/1 9
214 1 2008/7/1 4
215 1 2008/7/1 1
216 1 2008/7/1 8
217 1 2008/7/1 9
218 1 2008/7/1 4
219 1 2008/7/1 1
220 1 2008/7/2 7
221 1 2008/7/2 9
222 1 2008/7/2 7
223 1 2008/7/2 9
224 1 2008/7/3 8
225 1 2008/7/3 3
226 1 2008/7/3 8
227 1 2008/7/3 3
228 1 2008/7/4 9
229 1 2008/7/4 8
230 1 2008/7/4 9
231 1 2008/7/4 8
232 1 2008/7/5 7
233 1 2008/7/5 7
234 2 2008/7/1 1
235 2 2008/7/1 1
236 2 2008/7/1 1
237 3 2008/7/1 1
238 3 2008/7/1 1
239 4 2008/7/1 1
240 5 2008/7/1 1
241 6 2008/7/1 1
242 6 2008/7/1 1
243
244 echo SELECT t1.f1, t2.f4, t2.f1 FROM t1 INNER JOIN t2 ON t1.f1 < 2 OR t2.f1 < 2 ORDER BY t1.f1 DESC, t2.f4 ;
245 ---------------------------------------------------------
246 t1.f1 t2.f4 t2.f1
247 ---------------------------------------------------------
248 6 2008/7/1 1
249 6 2008/7/1 1
250 5 2008/7/1 1
251 4 2008/7/1 1
252 3 2008/7/1 1
253 3 2008/7/1 1
254 2 2008/7/1 1
255 2 2008/7/1 1
256 2 2008/7/1 1
257 1 2008/7/1 8
258 1 2008/7/1 9
259 1 2008/7/1 4
260 1 2008/7/1 1
261 1 2008/7/1 8
262 1 2008/7/1 9
263 1 2008/7/1 4
264 1 2008/7/1 1
265 1 2008/7/2 7
266 1 2008/7/2 9
267 1 2008/7/2 7
268 1 2008/7/2 9
269 1 2008/7/3 8
270 1 2008/7/3 3
271 1 2008/7/3 8
272 1 2008/7/3 3
273 1 2008/7/4 9
274 1 2008/7/4 8
275 1 2008/7/4 9
276 1 2008/7/4 8
277 1 2008/7/5 7
278 1 2008/7/5 7
279
280 Statement Executed
281 Statement Executed
282 Statement Executed
Main memory database SQL engine (cvs import)