Annotation of embedaddon/sqlite3/test/tkt2927.test, revision 1.1.1.1
1.1 misho 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: #
14: # $Id: tkt2927.test,v 1.4 2008/08/04 03:51:24 danielk1977 Exp $
15: #
16:
17: set testdir [file dirname $argv0]
18: source $testdir/tester.tcl
19:
20: ifcapable !compound {
21: finish_test
22: return
23: }
24:
25: # Create a database.
26: #
27: do_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:
40: do_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}
47: do_test tkt2927-2.2 {
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}
55: do_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}
62: do_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}
69: do_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}
76: do_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}
83: do_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}
90: do_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}
97: do_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}
104: do_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}
111: do_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}
118: do_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}
125: do_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}
132: do_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}
139: do_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}
146: do_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:
155: do_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}
163: do_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}
171: do_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}
179: do_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}
187: do_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}
195: do_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}
203: do_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}
211: do_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}
219: do_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}
227: do_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}
235: do_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}
243: do_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}
251: do_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}
259: do_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}
267: do_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}
275: do_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:
285: do_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}
292: do_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}
299: do_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}
306: do_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}
313: do_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}
320: do_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}
327: do_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}
334: do_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}
341: do_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}
348: do_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}
355: do_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}
362: do_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}
369: do_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}
376: do_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}
383: do_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}
390: do_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:
399: do_test tkt2927-5.1 {
400: db eval {
401: SELECT a, b FROM t1
402: EXCEPT
403: SELECT a, b FROM t1
404: }
405: } {}
406: do_test tkt2927-5.2 {
407: db eval {
408: SELECT a, b FROM t1
409: EXCEPT
410: SELECT a, abs(b) FROM t1
411: }
412: } {}
413: do_test tkt2927-5.3 {
414: db eval {
415: SELECT a, b FROM t1
416: EXCEPT
417: SELECT abs(a), b FROM t1
418: }
419: } {}
420: do_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: } {}
427: do_test tkt2927-5.5 {
428: db eval {
429: SELECT a, abs(b) FROM t1
430: EXCEPT
431: SELECT a, b FROM t1
432: }
433: } {}
434: do_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: } {}
441: do_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: } {}
448: do_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: } {}
455: do_test tkt2927-5.9 {
456: db eval {
457: SELECT abs(a), b FROM t1
458: EXCEPT
459: SELECT a, b FROM t1
460: }
461: } {}
462: do_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: } {}
469: do_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: } {}
476: do_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: } {}
483: do_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: } {}
490: do_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: } {}
497: do_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: } {}
504: do_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:
513: do_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}
521: do_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}
529: do_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}
537: do_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}
545: do_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}
553: do_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}
561: do_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}
569: do_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}
577: do_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}
585: do_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}
593: do_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}
601: do_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}
609: do_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}
617: do_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}
625: do_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}
633: do_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:
642: # Ticket #3092 is the same bug. But another test case never hurts.
643: #
644: do_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}
668: do_test tkt2927-7.2 {
669: db eval {
670: SELECT * FROM consolemap1
671: }
672: } {aald04 aalp03 /dev/cuaD03 aald17 aalp01 /dev/cuaD0.0}
673:
674: finish_test
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to tkt2927.test CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test