Gitiles
Code Review Sign In
gerrit.openfyde.cn / chromium.googlesource.com / chromium / deps / sqlite / refs/heads/upstream/printf-sql-function / . / test / tkt2927.test
blob: fc89a415389e0153f882c89a6de83b534675a31f [file] [log] [blame]
drh1ece7322008-02-06 23:52:36 +0000[diff] [blame]1# 2008 Feb 6
2#
3# The author disclaims copyright to this source code. In place of
4# a legal notice, here is a blessing:
5#
6# May you do good and not evil.
7# May you find forgiveness for yourself and forgive others.
8# May you share freely, never taking more than you give.
9#
10#***********************************************************************
11#
12# This file is to test that ticket #2927 is fixed.
13#
danielk1977de3e41e2008-08-04 03:51:24 +0000[diff] [blame]14# $Id: tkt2927.test,v 1.4 2008/08/04 03:51:24 danielk1977 Exp $
drh1ece7322008-02-06 23:52:36 +0000[diff] [blame]15#
16
17set testdir [file dirname $argv0]
18source $testdir/tester.tcl
19
danielk1977de3e41e2008-08-04 03:51:24 +0000[diff] [blame]20ifcapable !compound {
21 finish_test
22 return
23}
24
drh1ece7322008-02-06 23:52:36 +0000[diff] [blame]25# Create a database.
26#
27do_test tkt2927-1.1 {
28 db eval {
29 CREATE TABLE t1(a, b);
30 INSERT INTO t1 VALUES(1,11);
31 INSERT INTO t1 VALUES(2,22);
32 INSERT INTO t1 VALUES(3,33);
33 INSERT INTO t1 VALUES(4,44);
34 INSERT INTO t1 VALUES(5,55);
35 SELECT * FROM t1;
36 }
37} {1 11 2 22 3 33 4 44 5 55}
38
39
40do_test tkt2927-2.1 {
41 db eval {
42 SELECT a, b FROM t1
43 UNION ALL
44 SELECT a, b FROM t1
45 }
46} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
47do_test tkt2927-2.2 {
drh1ece7322008-02-06 23:52:36 +0000[diff] [blame]48#set sqlite_addop_trace 1
49 db eval {
50 SELECT a, b FROM t1
51 UNION ALL
52 SELECT a, abs(b) FROM t1
53 }
54} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
55do_test tkt2927-2.3 {
56 db eval {
57 SELECT a, b FROM t1
58 UNION ALL
59 SELECT abs(a), b FROM t1
60 }
61} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
62do_test tkt2927-2.4 {
63 db eval {
64 SELECT a, b FROM t1
65 UNION ALL
66 SELECT abs(a), abs(b) FROM t1
67 }
68} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
69do_test tkt2927-2.5 {
70 db eval {
71 SELECT a, abs(b) FROM t1
72 UNION ALL
73 SELECT a, b FROM t1
74 }
75} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
76do_test tkt2927-2.6 {
77 db eval {
78 SELECT a, abs(b) FROM t1
79 UNION ALL
80 SELECT a, abs(b) FROM t1
81 }
82} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
83do_test tkt2927-2.7 {
84 db eval {
85 SELECT a, abs(b) FROM t1
86 UNION ALL
87 SELECT abs(a), b FROM t1
88 }
89} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
90do_test tkt2927-2.8 {
91 db eval {
92 SELECT a, abs(b) FROM t1
93 UNION ALL
94 SELECT abs(a), abs(b) FROM t1
95 }
96} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
97do_test tkt2927-2.9 {
98 db eval {
99 SELECT abs(a), b FROM t1
100 UNION ALL
101 SELECT a, b FROM t1
102 }
103} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
104do_test tkt2927-2.10 {
105 db eval {
106 SELECT abs(a), b FROM t1
107 UNION ALL
108 SELECT a, abs(b) FROM t1
109 }
110} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
111do_test tkt2927-2.11 {
112 db eval {
113 SELECT abs(a), b FROM t1
114 UNION ALL
115 SELECT abs(a), b FROM t1
116 }
117} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
118do_test tkt2927-2.12 {
119 db eval {
120 SELECT abs(a), b FROM t1
121 UNION ALL
122 SELECT abs(a), abs(b) FROM t1
123 }
124} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
125do_test tkt2927-2.13 {
126 db eval {
127 SELECT abs(a), abs(b) FROM t1
128 UNION ALL
129 SELECT a, b FROM t1
130 }
131} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
132do_test tkt2927-2.14 {
133 db eval {
134 SELECT abs(a), abs(b) FROM t1
135 UNION ALL
136 SELECT a, abs(b) FROM t1
137 }
138} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
139do_test tkt2927-2.15 {
140 db eval {
141 SELECT abs(a), abs(b) FROM t1
142 UNION ALL
143 SELECT abs(a), b FROM t1
144 }
145} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
146do_test tkt2927-2.16 {
147 db eval {
148 SELECT abs(a), abs(b) FROM t1
149 UNION ALL
150 SELECT abs(a), abs(b) FROM t1
151 }
152} {1 11 2 22 3 33 4 44 5 55 1 11 2 22 3 33 4 44 5 55}
153
154
155do_test tkt2927-3.1 {
156 db eval {
157 SELECT a, b FROM t1
158 UNION
159 SELECT a, b FROM t1
160 ORDER BY 1
161 }
162} {1 11 2 22 3 33 4 44 5 55}
163do_test tkt2927-3.2 {
164 db eval {
165 SELECT a, b FROM t1
166 UNION
167 SELECT a, abs(b) FROM t1
168 ORDER BY 1
169 }
170} {1 11 2 22 3 33 4 44 5 55}
171do_test tkt2927-3.3 {
172 db eval {
173 SELECT a, b FROM t1
174 UNION
175 SELECT abs(a), b FROM t1
176 ORDER BY 1
177 }
178} {1 11 2 22 3 33 4 44 5 55}
179do_test tkt2927-3.4 {
180 db eval {
181 SELECT a, b FROM t1
182 UNION
183 SELECT abs(a), abs(b) FROM t1
184 ORDER BY 1
185 }
186} {1 11 2 22 3 33 4 44 5 55}
187do_test tkt2927-3.5 {
188 db eval {
189 SELECT a, abs(b) FROM t1
190 UNION
191 SELECT a, b FROM t1
192 ORDER BY 1
193 }
194} {1 11 2 22 3 33 4 44 5 55}
195do_test tkt2927-3.6 {
196 db eval {
197 SELECT a, abs(b) FROM t1
198 UNION
199 SELECT a, abs(b) FROM t1
200 ORDER BY 1
201 }
202} {1 11 2 22 3 33 4 44 5 55}
203do_test tkt2927-3.7 {
204 db eval {
205 SELECT a, abs(b) FROM t1
206 UNION
207 SELECT abs(a), b FROM t1
208 ORDER BY 1
209 }
210} {1 11 2 22 3 33 4 44 5 55}
211do_test tkt2927-3.8 {
212 db eval {
213 SELECT a, abs(b) FROM t1
214 UNION
215 SELECT abs(a), abs(b) FROM t1
216 ORDER BY 1
217 }
218} {1 11 2 22 3 33 4 44 5 55}
219do_test tkt2927-3.9 {
220 db eval {
221 SELECT abs(a), b FROM t1
222 UNION
223 SELECT a, b FROM t1
224 ORDER BY 1
225 }
226} {1 11 2 22 3 33 4 44 5 55}
227do_test tkt2927-3.10 {
228 db eval {
229 SELECT abs(a), b FROM t1
230 UNION
231 SELECT a, abs(b) FROM t1
232 ORDER BY 1
233 }
234} {1 11 2 22 3 33 4 44 5 55}
235do_test tkt2927-3.11 {
236 db eval {
237 SELECT abs(a), b FROM t1
238 UNION
239 SELECT abs(a), b FROM t1
240 ORDER BY 1
241 }
242} {1 11 2 22 3 33 4 44 5 55}
243do_test tkt2927-3.12 {
244 db eval {
245 SELECT abs(a), b FROM t1
246 UNION
247 SELECT abs(a), abs(b) FROM t1
248 ORDER BY 1
249 }
250} {1 11 2 22 3 33 4 44 5 55}
251do_test tkt2927-3.13 {
252 db eval {
253 SELECT abs(a), abs(b) FROM t1
254 UNION
255 SELECT a, b FROM t1
256 ORDER BY 1
257 }
258} {1 11 2 22 3 33 4 44 5 55}
259do_test tkt2927-3.14 {
260 db eval {
261 SELECT abs(a), abs(b) FROM t1
262 UNION
263 SELECT a, abs(b) FROM t1
264 ORDER BY 1
265 }
266} {1 11 2 22 3 33 4 44 5 55}
267do_test tkt2927-3.15 {
268 db eval {
269 SELECT abs(a), abs(b) FROM t1
270 UNION
271 SELECT abs(a), b FROM t1
272 ORDER BY 1
273 }
274} {1 11 2 22 3 33 4 44 5 55}
275do_test tkt2927-3.16 {
276 db eval {
277 SELECT abs(a), abs(b) FROM t1
278 UNION
279 SELECT abs(a), abs(b) FROM t1
280 ORDER BY 1
281 }
282} {1 11 2 22 3 33 4 44 5 55}
283
284
285do_test tkt2927-4.1 {
286 db eval {
287 SELECT a+b, a-b, a, b FROM t1
288 UNION ALL
289 SELECT a+b, a-b, a, b FROM t1
290 }
291} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
292do_test tkt2927-4.2 {
293 db eval {
294 SELECT a+b, a-b, a, b FROM t1
295 UNION ALL
296 SELECT a+b, a-b, a, abs(b) FROM t1
297 }
298} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
299do_test tkt2927-4.3 {
300 db eval {
301 SELECT a+b, a-b, a, b FROM t1
302 UNION ALL
303 SELECT a+b, a-b, abs(a), b FROM t1
304 }
305} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
306do_test tkt2927-4.4 {
307 db eval {
308 SELECT a+b, a-b, a, b FROM t1
309 UNION ALL
310 SELECT a+b, a-b, abs(a), abs(b) FROM t1
311 }
312} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
313do_test tkt2927-4.5 {
314 db eval {
315 SELECT a+b, a-b, a, abs(b) FROM t1
316 UNION ALL
317 SELECT a+b, a-b, a, b FROM t1
318 }
319} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
320do_test tkt2927-4.6 {
321 db eval {
322 SELECT a+b, a-b, a, abs(b) FROM t1
323 UNION ALL
324 SELECT a+b, a-b, a, abs(b) FROM t1
325 }
326} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
327do_test tkt2927-4.7 {
328 db eval {
329 SELECT a+b, a-b, a, abs(b) FROM t1
330 UNION ALL
331 SELECT a+b, a-b, abs(a), b FROM t1
332 }
333} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
334do_test tkt2927-4.8 {
335 db eval {
336 SELECT a+b, a-b, a, abs(b) FROM t1
337 UNION ALL
338 SELECT a+b, a-b, abs(a), abs(b) FROM t1
339 }
340} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
341do_test tkt2927-4.9 {
342 db eval {
343 SELECT a+b, a-b, abs(a), b FROM t1
344 UNION ALL
345 SELECT a+b, a-b, a, b FROM t1
346 }
347} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
348do_test tkt2927-4.10 {
349 db eval {
350 SELECT a+b, a-b, abs(a), b FROM t1
351 UNION ALL
352 SELECT a+b, a-b, a, abs(b) FROM t1
353 }
354} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
355do_test tkt2927-4.11 {
356 db eval {
357 SELECT a+b, a-b, abs(a), b FROM t1
358 UNION ALL
359 SELECT a+b, a-b, abs(a), b FROM t1
360 }
361} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
362do_test tkt2927-4.12 {
363 db eval {
364 SELECT a+b, a-b, abs(a), b FROM t1
365 UNION ALL
366 SELECT a+b, a-b, abs(a), abs(b) FROM t1
367 }
368} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
369do_test tkt2927-4.13 {
370 db eval {
371 SELECT a+b, a-b, abs(a), abs(b) FROM t1
372 UNION ALL
373 SELECT a+b, a-b, a, b FROM t1
374 }
375} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
376do_test tkt2927-4.14 {
377 db eval {
378 SELECT a+b, a-b, abs(a), abs(b) FROM t1
379 UNION ALL
380 SELECT a+b, a-b, a, abs(b) FROM t1
381 }
382} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
383do_test tkt2927-4.15 {
384 db eval {
385 SELECT a+b, a-b, abs(a), abs(b) FROM t1
386 UNION ALL
387 SELECT a+b, a-b, abs(a), b FROM t1
388 }
389} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
390do_test tkt2927-4.16 {
391 db eval {
392 SELECT a+b, a-b, abs(a), abs(b) FROM t1
393 UNION ALL
394 SELECT a+b, a-b, abs(a), abs(b) FROM t1
395 }
396} {12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55 12 -10 1 11 24 -20 2 22 36 -30 3 33 48 -40 4 44 60 -50 5 55}
397
398
399do_test tkt2927-5.1 {
400 db eval {
401 SELECT a, b FROM t1
402 EXCEPT
403 SELECT a, b FROM t1
404 }
405} {}
406do_test tkt2927-5.2 {
407 db eval {
408 SELECT a, b FROM t1
409 EXCEPT
410 SELECT a, abs(b) FROM t1
411 }
412} {}
413do_test tkt2927-5.3 {
414 db eval {
415 SELECT a, b FROM t1
416 EXCEPT
417 SELECT abs(a), b FROM t1
418 }
419} {}
420do_test tkt2927-5.4 {
421 db eval {
422 SELECT a, b FROM t1
423 EXCEPT
424 SELECT abs(a), abs(b) FROM t1
425 }
426} {}
427do_test tkt2927-5.5 {
428 db eval {
429 SELECT a, abs(b) FROM t1
430 EXCEPT
431 SELECT a, b FROM t1
432 }
433} {}
434do_test tkt2927-5.6 {
435 db eval {
436 SELECT a, abs(b) FROM t1
437 EXCEPT
438 SELECT a, abs(b) FROM t1
439 }
440} {}
441do_test tkt2927-5.7 {
442 db eval {
443 SELECT a, abs(b) FROM t1
444 EXCEPT
445 SELECT abs(a), b FROM t1
446 }
447} {}
448do_test tkt2927-5.8 {
449 db eval {
450 SELECT a, abs(b) FROM t1
451 EXCEPT
452 SELECT abs(a), abs(b) FROM t1
453 }
454} {}
455do_test tkt2927-5.9 {
456 db eval {
457 SELECT abs(a), b FROM t1
458 EXCEPT
459 SELECT a, b FROM t1
460 }
461} {}
462do_test tkt2927-5.10 {
463 db eval {
464 SELECT abs(a), b FROM t1
465 EXCEPT
466 SELECT a, abs(b) FROM t1
467 }
468} {}
469do_test tkt2927-5.11 {
470 db eval {
471 SELECT abs(a), b FROM t1
472 EXCEPT
473 SELECT abs(a), b FROM t1
474 }
475} {}
476do_test tkt2927-5.12 {
477 db eval {
478 SELECT abs(a), b FROM t1
479 EXCEPT
480 SELECT abs(a), abs(b) FROM t1
481 }
482} {}
483do_test tkt2927-5.13 {
484 db eval {
485 SELECT abs(a), abs(b) FROM t1
486 EXCEPT
487 SELECT a, b FROM t1
488 }
489} {}
490do_test tkt2927-5.14 {
491 db eval {
492 SELECT abs(a), abs(b) FROM t1
493 EXCEPT
494 SELECT a, abs(b) FROM t1
495 }
496} {}
497do_test tkt2927-5.15 {
498 db eval {
499 SELECT abs(a), abs(b) FROM t1
500 EXCEPT
501 SELECT abs(a), b FROM t1
502 }
503} {}
504do_test tkt2927-5.16 {
505 db eval {
506 SELECT abs(a), abs(b) FROM t1
507 EXCEPT
508 SELECT abs(a), abs(b) FROM t1
509 }
510} {}
511
512
513do_test tkt2927-6.1 {
514 db eval {
515 SELECT a, b FROM t1
516 INTERSECT
517 SELECT a, b FROM t1
518 ORDER BY 1
519 }
520} {1 11 2 22 3 33 4 44 5 55}
521do_test tkt2927-6.2 {
522 db eval {
523 SELECT a, b FROM t1
524 INTERSECT
525 SELECT a, abs(b) FROM t1
526 ORDER BY 1
527 }
528} {1 11 2 22 3 33 4 44 5 55}
529do_test tkt2927-6.3 {
530 db eval {
531 SELECT a, b FROM t1
532 INTERSECT
533 SELECT abs(a), b FROM t1
534 ORDER BY 1
535 }
536} {1 11 2 22 3 33 4 44 5 55}
537do_test tkt2927-6.4 {
538 db eval {
539 SELECT a, b FROM t1
540 INTERSECT
541 SELECT abs(a), abs(b) FROM t1
542 ORDER BY 1
543 }
544} {1 11 2 22 3 33 4 44 5 55}
545do_test tkt2927-6.5 {
546 db eval {
547 SELECT a, abs(b) FROM t1
548 INTERSECT
549 SELECT a, b FROM t1
550 ORDER BY 1
551 }
552} {1 11 2 22 3 33 4 44 5 55}
553do_test tkt2927-6.6 {
554 db eval {
555 SELECT a, abs(b) FROM t1
556 INTERSECT
557 SELECT a, abs(b) FROM t1
558 ORDER BY 1
559 }
560} {1 11 2 22 3 33 4 44 5 55}
561do_test tkt2927-6.7 {
562 db eval {
563 SELECT a, abs(b) FROM t1
564 INTERSECT
565 SELECT abs(a), b FROM t1
566 ORDER BY 1
567 }
568} {1 11 2 22 3 33 4 44 5 55}
569do_test tkt2927-6.8 {
570 db eval {
571 SELECT a, abs(b) FROM t1
572 INTERSECT
573 SELECT abs(a), abs(b) FROM t1
574 ORDER BY 1
575 }
576} {1 11 2 22 3 33 4 44 5 55}
577do_test tkt2927-6.9 {
578 db eval {
579 SELECT abs(a), b FROM t1
580 INTERSECT
581 SELECT a, b FROM t1
582 ORDER BY 1
583 }
584} {1 11 2 22 3 33 4 44 5 55}
585do_test tkt2927-6.10 {
586 db eval {
587 SELECT abs(a), b FROM t1
588 INTERSECT
589 SELECT a, abs(b) FROM t1
590 ORDER BY 1
591 }
592} {1 11 2 22 3 33 4 44 5 55}
593do_test tkt2927-6.11 {
594 db eval {
595 SELECT abs(a), b FROM t1
596 INTERSECT
597 SELECT abs(a), b FROM t1
598 ORDER BY 1
599 }
600} {1 11 2 22 3 33 4 44 5 55}
601do_test tkt2927-6.12 {
602 db eval {
603 SELECT abs(a), b FROM t1
604 INTERSECT
605 SELECT abs(a), abs(b) FROM t1
606 ORDER BY 1
607 }
608} {1 11 2 22 3 33 4 44 5 55}
609do_test tkt2927-6.13 {
610 db eval {
611 SELECT abs(a), abs(b) FROM t1
612 INTERSECT
613 SELECT a, b FROM t1
614 ORDER BY 1
615 }
616} {1 11 2 22 3 33 4 44 5 55}
617do_test tkt2927-6.14 {
618 db eval {
619 SELECT abs(a), abs(b) FROM t1
620 INTERSECT
621 SELECT a, abs(b) FROM t1
622 ORDER BY 1
623 }
624} {1 11 2 22 3 33 4 44 5 55}
625do_test tkt2927-6.15 {
626 db eval {
627 SELECT abs(a), abs(b) FROM t1
628 INTERSECT
629 SELECT abs(a), b FROM t1
630 ORDER BY 1
631 }
632} {1 11 2 22 3 33 4 44 5 55}
633do_test tkt2927-6.16 {
634 db eval {
635 SELECT abs(a), abs(b) FROM t1
636 INTERSECT
637 SELECT abs(a), abs(b) FROM t1
638 ORDER BY 1
639 }
640} {1 11 2 22 3 33 4 44 5 55}
641
drh71c9cb72008-05-02 02:00:54 +0000[diff] [blame]642# Ticket #3092 is the same bug. But another test case never hurts.
643#
644do_test tkt2927-7.1 {
645 db eval {
646 CREATE TABLE host (
647 hostname text not null primary key,
648 consoleHost text,
649 consolePort text
650 );
651 INSERT INTO "host" VALUES('aald04','aalp03','4');
652 INSERT INTO "host" VALUES('aald17','aalp01','1');
653 CREATE VIEW consolemap1a as
654 select hostname, consolehost, '/dev/cuaD0.' || (consoleport-1) consoleport
655 from host where consolehost='aalp01';
656 CREATE VIEW consolemap1b as
657 select hostname hostname, consolehost consolehost, '/dev/cuaD' ||
658 substr('01',1+((consoleport-1)/16),1) ||
659 substr('0123456789abcdef',1+((consoleport-1)%16),1) consoleport
660 from host where consolehost='aalp03';
661 CREATE VIEW consolemap1 as
662 select * from consolemap1a
663 union
664 select * from consolemap1b;
665 SELECT * from consolemap1b;
666 }
667} {aald04 aalp03 /dev/cuaD03}
668do_test tkt2927-7.2 {
669 db eval {
670 SELECT * FROM consolemap1
671 }
672} {aald04 aalp03 /dev/cuaD03 aald17 aalp01 /dev/cuaD0.0}
673
drh1ece7322008-02-06 23:52:36 +0000[diff] [blame]674finish_test