wasCSharpSQLite – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 office 1 # 2005 September 19
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 # This file implements regression tests for SQLite library.
12 #
13 # This file implements tests to verify that ticket #1473 has been
14 # fixed.
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 do_test tkt1473-1.1 {
26 execsql {
27 CREATE TABLE t1(a,b);
28 INSERT INTO t1 VALUES(1,2);
29 INSERT INTO t1 VALUES(3,4);
30 SELECT * FROM t1
31 }
32 } {1 2 3 4}
33  
34 do_test tkt1473-1.2 {
35 execsql {
36 SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=0
37 }
38 } {1}
39 do_test tkt1473-1.3 {
40 execsql {
41 SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=0
42 }
43 } {1}
44 do_test tkt1473-1.4 {
45 execsql {
46 SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=4
47 }
48 } {1 2}
49 do_test tkt1473-1.5 {
50 execsql {
51 SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=4
52 }
53 } {1 2}
54 do_test tkt1473-1.6 {
55 execsql {
56 SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=4
57 }
58 } {2}
59 do_test tkt1473-1.7 {
60 execsql {
61 SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=4
62 }
63 } {2}
64 do_test tkt1473-1.8 {
65 execsql {
66 SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=0
67 }
68 } {}
69 do_test tkt1473-1.9 {
70 execsql {
71 SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=0
72 }
73 } {}
74  
75 # Everything from this point on depends on sub-queries. So skip it
76 # if sub-queries are not available.
77 ifcapable !subquery {
78 finish_test
79 return
80 }
81  
82 do_test tkt1473-2.2 {
83 execsql {
84 SELECT (SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=0)
85 }
86 } {1}
87 do_test tkt1473-2.3 {
88 execsql {
89 SELECT (SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=0)
90 }
91 } {1}
92 do_test tkt1473-2.4 {
93 execsql {
94 SELECT (SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=4)
95 }
96 } {1}
97 do_test tkt1473-2.5 {
98 execsql {
99 SELECT (SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=4)
100 }
101 } {1}
102 do_test tkt1473-2.6 {
103 execsql {
104 SELECT (SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=4)
105 }
106 } {2}
107 do_test tkt1473-2.7 {
108 execsql {
109 SELECT (SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=4)
110 }
111 } {2}
112 do_test tkt1473-2.8 {
113 execsql {
114 SELECT (SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=0)
115 }
116 } {{}}
117 do_test tkt1473-2.9 {
118 execsql {
119 SELECT (SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=0)
120 }
121 } {{}}
122  
123 do_test tkt1473-3.2 {
124 execsql {
125 SELECT EXISTS
126 (SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=0)
127 }
128 } {1}
129 do_test tkt1473-3.3 {
130 execsql {
131 SELECT EXISTS
132 (SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=0)
133 }
134 } {1}
135 do_test tkt1473-3.4 {
136 execsql {
137 SELECT EXISTS
138 (SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=4)
139 }
140 } {1}
141 do_test tkt1473-3.5 {
142 execsql {
143 SELECT EXISTS
144 (SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=4)
145 }
146 } {1}
147 do_test tkt1473-3.6 {
148 execsql {
149 SELECT EXISTS
150 (SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=4)
151 }
152 } {1}
153 do_test tkt1473-3.7 {
154 execsql {
155 SELECT EXISTS
156 (SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=4)
157 }
158 } {1}
159 do_test tkt1473-3.8 {
160 execsql {
161 SELECT EXISTS
162 (SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=0)
163 }
164 } {0}
165 do_test tkt1473-3.9 {
166 execsql {
167 SELECT EXISTS
168 (SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=0)
169 }
170 } {0}
171  
172 do_test tkt1473-4.1 {
173 execsql {
174 CREATE TABLE t2(x,y);
175 INSERT INTO t2 VALUES(1,2);
176 INSERT INTO t2 SELECT x+2, y+2 FROM t2;
177 INSERT INTO t2 SELECT x+4, y+4 FROM t2;
178 INSERT INTO t2 SELECT x+8, y+8 FROM t2;
179 INSERT INTO t2 SELECT x+16, y+16 FROM t2;
180 INSERT INTO t2 SELECT x+32, y+32 FROM t2;
181 INSERT INTO t2 SELECT x+64, y+64 FROM t2;
182 SELECT count(*), sum(x), sum(y) FROM t2;
183 }
184 } {64 4096 4160}
185 do_test tkt1473-4.2 {
186 execsql {
187 SELECT 1 FROM t2 WHERE x=0
188 UNION ALL
189 SELECT 2 FROM t2 WHERE x=1
190 UNION ALL
191 SELECT 3 FROM t2 WHERE x=2
192 UNION ALL
193 SELECT 4 FROM t2 WHERE x=3
194 UNION ALL
195 SELECT 5 FROM t2 WHERE x=4
196 UNION ALL
197 SELECT 6 FROM t2 WHERE y=0
198 UNION ALL
199 SELECT 7 FROM t2 WHERE y=1
200 UNION ALL
201 SELECT 8 FROM t2 WHERE y=2
202 UNION ALL
203 SELECT 9 FROM t2 WHERE y=3
204 UNION ALL
205 SELECT 10 FROM t2 WHERE y=4
206 }
207 } {2 4 8 10}
208 do_test tkt1473-4.3 {
209 execsql {
210 SELECT (
211 SELECT 1 FROM t2 WHERE x=0
212 UNION ALL
213 SELECT 2 FROM t2 WHERE x=1
214 UNION ALL
215 SELECT 3 FROM t2 WHERE x=2
216 UNION ALL
217 SELECT 4 FROM t2 WHERE x=3
218 UNION ALL
219 SELECT 5 FROM t2 WHERE x=4
220 UNION ALL
221 SELECT 6 FROM t2 WHERE y=0
222 UNION ALL
223 SELECT 7 FROM t2 WHERE y=1
224 UNION ALL
225 SELECT 8 FROM t2 WHERE y=2
226 UNION ALL
227 SELECT 9 FROM t2 WHERE y=3
228 UNION ALL
229 SELECT 10 FROM t2 WHERE y=4
230 )
231 }
232 } {2}
233 do_test tkt1473-4.4 {
234 execsql {
235 SELECT (
236 SELECT 1 FROM t2 WHERE x=0
237 UNION ALL
238 SELECT 2 FROM t2 WHERE x=-1
239 UNION ALL
240 SELECT 3 FROM t2 WHERE x=2
241 UNION ALL
242 SELECT 4 FROM t2 WHERE x=3
243 UNION ALL
244 SELECT 5 FROM t2 WHERE x=4
245 UNION ALL
246 SELECT 6 FROM t2 WHERE y=0
247 UNION ALL
248 SELECT 7 FROM t2 WHERE y=1
249 UNION ALL
250 SELECT 8 FROM t2 WHERE y=2
251 UNION ALL
252 SELECT 9 FROM t2 WHERE y=3
253 UNION ALL
254 SELECT 10 FROM t2 WHERE y=4
255 )
256 }
257 } {4}
258 do_test tkt1473-4.5 {
259 execsql {
260 SELECT (
261 SELECT 1 FROM t2 WHERE x=0
262 UNION ALL
263 SELECT 2 FROM t2 WHERE x=-1
264 UNION ALL
265 SELECT 3 FROM t2 WHERE x=2
266 UNION ALL
267 SELECT 4 FROM t2 WHERE x=-1
268 UNION ALL
269 SELECT 5 FROM t2 WHERE x=4
270 UNION ALL
271 SELECT 6 FROM t2 WHERE y=0
272 UNION ALL
273 SELECT 7 FROM t2 WHERE y=1
274 UNION ALL
275 SELECT 8 FROM t2 WHERE y=2
276 UNION ALL
277 SELECT 9 FROM t2 WHERE y=3
278 UNION ALL
279 SELECT 10 FROM t2 WHERE y=-4
280 )
281 }
282 } {8}
283 do_test tkt1473-4.6 {
284 execsql {
285 SELECT (
286 SELECT 1 FROM t2 WHERE x=0
287 UNION ALL
288 SELECT 2 FROM t2 WHERE x=-1
289 UNION ALL
290 SELECT 3 FROM t2 WHERE x=2
291 UNION ALL
292 SELECT 4 FROM t2 WHERE x=-2
293 UNION ALL
294 SELECT 5 FROM t2 WHERE x=4
295 UNION ALL
296 SELECT 6 FROM t2 WHERE y=0
297 UNION ALL
298 SELECT 7 FROM t2 WHERE y=1
299 UNION ALL
300 SELECT 8 FROM t2 WHERE y=-3
301 UNION ALL
302 SELECT 9 FROM t2 WHERE y=3
303 UNION ALL
304 SELECT 10 FROM t2 WHERE y=4
305 )
306 }
307 } {10}
308 do_test tkt1473-4.7 {
309 execsql {
310 SELECT (
311 SELECT 1 FROM t2 WHERE x=0
312 UNION ALL
313 SELECT 2 FROM t2 WHERE x=-1
314 UNION ALL
315 SELECT 3 FROM t2 WHERE x=2
316 UNION ALL
317 SELECT 4 FROM t2 WHERE x=-2
318 UNION ALL
319 SELECT 5 FROM t2 WHERE x=4
320 UNION ALL
321 SELECT 6 FROM t2 WHERE y=0
322 UNION ALL
323 SELECT 7 FROM t2 WHERE y=1
324 UNION ALL
325 SELECT 8 FROM t2 WHERE y=-3
326 UNION ALL
327 SELECT 9 FROM t2 WHERE y=3
328 UNION ALL
329 SELECT 10 FROM t2 WHERE y=-4
330 )
331 }
332 } {{}}
333  
334 do_test tkt1473-5.3 {
335 execsql {
336 SELECT EXISTS (
337 SELECT 1 FROM t2 WHERE x=0
338 UNION ALL
339 SELECT 2 FROM t2 WHERE x=1
340 UNION ALL
341 SELECT 3 FROM t2 WHERE x=2
342 UNION ALL
343 SELECT 4 FROM t2 WHERE x=3
344 UNION ALL
345 SELECT 5 FROM t2 WHERE x=4
346 UNION ALL
347 SELECT 6 FROM t2 WHERE y=0
348 UNION ALL
349 SELECT 7 FROM t2 WHERE y=1
350 UNION ALL
351 SELECT 8 FROM t2 WHERE y=2
352 UNION ALL
353 SELECT 9 FROM t2 WHERE y=3
354 UNION ALL
355 SELECT 10 FROM t2 WHERE y=4
356 )
357 }
358 } {1}
359 do_test tkt1473-5.4 {
360 execsql {
361 SELECT EXISTS (
362 SELECT 1 FROM t2 WHERE x=0
363 UNION ALL
364 SELECT 2 FROM t2 WHERE x=-1
365 UNION ALL
366 SELECT 3 FROM t2 WHERE x=2
367 UNION ALL
368 SELECT 4 FROM t2 WHERE x=3
369 UNION ALL
370 SELECT 5 FROM t2 WHERE x=4
371 UNION ALL
372 SELECT 6 FROM t2 WHERE y=0
373 UNION ALL
374 SELECT 7 FROM t2 WHERE y=1
375 UNION ALL
376 SELECT 8 FROM t2 WHERE y=2
377 UNION ALL
378 SELECT 9 FROM t2 WHERE y=3
379 UNION ALL
380 SELECT 10 FROM t2 WHERE y=4
381 )
382 }
383 } {1}
384  
385 do_test tkt1473-5.5 {
386 execsql {
387 SELECT EXISTS (
388 SELECT 1 FROM t2 WHERE x=0
389 UNION ALL
390 SELECT 2 FROM t2 WHERE x=-1
391 UNION ALL
392 SELECT 3 FROM t2 WHERE x=2
393 UNION ALL
394 SELECT 4 FROM t2 WHERE x=-1
395 UNION ALL
396 SELECT 5 FROM t2 WHERE x=4
397 UNION ALL
398 SELECT 6 FROM t2 WHERE y=0
399 UNION ALL
400 SELECT 7 FROM t2 WHERE y=1
401 UNION ALL
402 SELECT 8 FROM t2 WHERE y=2
403 UNION ALL
404 SELECT 9 FROM t2 WHERE y=3
405 UNION ALL
406 SELECT 10 FROM t2 WHERE y=-4
407 )
408 }
409 } {1}
410 do_test tkt1473-5.6 {
411 execsql {
412 SELECT EXISTS (
413 SELECT 1 FROM t2 WHERE x=0
414 UNION ALL
415 SELECT 2 FROM t2 WHERE x=-1
416 UNION ALL
417 SELECT 3 FROM t2 WHERE x=2
418 UNION ALL
419 SELECT 4 FROM t2 WHERE x=-2
420 UNION ALL
421 SELECT 5 FROM t2 WHERE x=4
422 UNION ALL
423 SELECT 6 FROM t2 WHERE y=0
424 UNION ALL
425 SELECT 7 FROM t2 WHERE y=1
426 UNION ALL
427 SELECT 8 FROM t2 WHERE y=-3
428 UNION ALL
429 SELECT 9 FROM t2 WHERE y=3
430 UNION ALL
431 SELECT 10 FROM t2 WHERE y=4
432 )
433 }
434 } {1}
435 do_test tkt1473-5.7 {
436 execsql {
437 SELECT EXISTS (
438 SELECT 1 FROM t2 WHERE x=0
439 UNION ALL
440 SELECT 2 FROM t2 WHERE x=-1
441 UNION ALL
442 SELECT 3 FROM t2 WHERE x=2
443 UNION ALL
444 SELECT 4 FROM t2 WHERE x=-2
445 UNION ALL
446 SELECT 5 FROM t2 WHERE x=4
447 UNION ALL
448 SELECT 6 FROM t2 WHERE y=0
449 UNION ALL
450 SELECT 7 FROM t2 WHERE y=1
451 UNION ALL
452 SELECT 8 FROM t2 WHERE y=-3
453 UNION ALL
454 SELECT 9 FROM t2 WHERE y=3
455 UNION ALL
456 SELECT 10 FROM t2 WHERE y=-4
457 )
458 }
459 } {0}
460  
461 do_test tkt1473-6.3 {
462 execsql {
463 SELECT EXISTS (
464 SELECT 1 FROM t2 WHERE x=0
465 UNION
466 SELECT 2 FROM t2 WHERE x=1
467 UNION
468 SELECT 3 FROM t2 WHERE x=2
469 UNION
470 SELECT 4 FROM t2 WHERE x=3
471 UNION
472 SELECT 5 FROM t2 WHERE x=4
473 UNION
474 SELECT 6 FROM t2 WHERE y=0
475 UNION
476 SELECT 7 FROM t2 WHERE y=1
477 UNION
478 SELECT 8 FROM t2 WHERE y=2
479 UNION
480 SELECT 9 FROM t2 WHERE y=3
481 UNION
482 SELECT 10 FROM t2 WHERE y=4
483 )
484 }
485 } {1}
486 do_test tkt1473-6.4 {
487 execsql {
488 SELECT EXISTS (
489 SELECT 1 FROM t2 WHERE x=0
490 UNION
491 SELECT 2 FROM t2 WHERE x=-1
492 UNION
493 SELECT 3 FROM t2 WHERE x=2
494 UNION
495 SELECT 4 FROM t2 WHERE x=3
496 UNION
497 SELECT 5 FROM t2 WHERE x=4
498 UNION
499 SELECT 6 FROM t2 WHERE y=0
500 UNION
501 SELECT 7 FROM t2 WHERE y=1
502 UNION
503 SELECT 8 FROM t2 WHERE y=2
504 UNION
505 SELECT 9 FROM t2 WHERE y=3
506 UNION
507 SELECT 10 FROM t2 WHERE y=4
508 )
509 }
510 } {1}
511  
512 do_test tkt1473-6.5 {
513 execsql {
514 SELECT EXISTS (
515 SELECT 1 FROM t2 WHERE x=0
516 UNION
517 SELECT 2 FROM t2 WHERE x=-1
518 UNION
519 SELECT 3 FROM t2 WHERE x=2
520 UNION
521 SELECT 4 FROM t2 WHERE x=-1
522 UNION
523 SELECT 5 FROM t2 WHERE x=4
524 UNION
525 SELECT 6 FROM t2 WHERE y=0
526 UNION
527 SELECT 7 FROM t2 WHERE y=1
528 UNION
529 SELECT 8 FROM t2 WHERE y=2
530 UNION
531 SELECT 9 FROM t2 WHERE y=3
532 UNION
533 SELECT 10 FROM t2 WHERE y=-4
534 )
535 }
536 } {1}
537 do_test tkt1473-6.6 {
538 execsql {
539 SELECT EXISTS (
540 SELECT 1 FROM t2 WHERE x=0
541 UNION
542 SELECT 2 FROM t2 WHERE x=-1
543 UNION
544 SELECT 3 FROM t2 WHERE x=2
545 UNION
546 SELECT 4 FROM t2 WHERE x=-2
547 UNION
548 SELECT 5 FROM t2 WHERE x=4
549 UNION
550 SELECT 6 FROM t2 WHERE y=0
551 UNION
552 SELECT 7 FROM t2 WHERE y=1
553 UNION
554 SELECT 8 FROM t2 WHERE y=-3
555 UNION
556 SELECT 9 FROM t2 WHERE y=3
557 UNION
558 SELECT 10 FROM t2 WHERE y=4
559 )
560 }
561 } {1}
562 do_test tkt1473-6.7 {
563 execsql {
564 SELECT EXISTS (
565 SELECT 1 FROM t2 WHERE x=0
566 UNION
567 SELECT 2 FROM t2 WHERE x=-1
568 UNION
569 SELECT 3 FROM t2 WHERE x=2
570 UNION
571 SELECT 4 FROM t2 WHERE x=-2
572 UNION
573 SELECT 5 FROM t2 WHERE x=4
574 UNION
575 SELECT 6 FROM t2 WHERE y=0
576 UNION
577 SELECT 7 FROM t2 WHERE y=1
578 UNION
579 SELECT 8 FROM t2 WHERE y=-3
580 UNION
581 SELECT 9 FROM t2 WHERE y=3
582 UNION
583 SELECT 10 FROM t2 WHERE y=-4
584 )
585 }
586 } {0}
587 do_test tkt1473-6.8 {
588 execsql {
589 SELECT EXISTS (
590 SELECT 1 FROM t2 WHERE x=0
591 UNION
592 SELECT 2 FROM t2 WHERE x=-1
593 UNION
594 SELECT 3 FROM t2 WHERE x=2
595 UNION
596 SELECT 4 FROM t2 WHERE x=-2
597 UNION
598 SELECT 5 FROM t2 WHERE x=4
599 UNION ALL
600 SELECT 6 FROM t2 WHERE y=0
601 UNION
602 SELECT 7 FROM t2 WHERE y=1
603 UNION
604 SELECT 8 FROM t2 WHERE y=-3
605 UNION
606 SELECT 9 FROM t2 WHERE y=3
607 UNION
608 SELECT 10 FROM t2 WHERE y=4
609 )
610 }
611 } {1}
612 do_test tkt1473-6.9 {
613 execsql {
614 SELECT EXISTS (
615 SELECT 1 FROM t2 WHERE x=0
616 UNION
617 SELECT 2 FROM t2 WHERE x=-1
618 UNION
619 SELECT 3 FROM t2 WHERE x=2
620 UNION
621 SELECT 4 FROM t2 WHERE x=-2
622 UNION
623 SELECT 5 FROM t2 WHERE x=4
624 UNION ALL
625 SELECT 6 FROM t2 WHERE y=0
626 UNION
627 SELECT 7 FROM t2 WHERE y=1
628 UNION
629 SELECT 8 FROM t2 WHERE y=-3
630 UNION
631 SELECT 9 FROM t2 WHERE y=3
632 UNION
633 SELECT 10 FROM t2 WHERE y=-4
634 )
635 }
636 } {0}
637  
638 do_test tkt1473-7.1 {
639 execsql {
640 SELECT 1 FROM t2 WHERE x=1 EXCEPT SELECT 2 FROM t2 WHERE y=2
641 }
642 } {1}
643 do_test tkt1473-7.2 {
644 execsql {
645 SELECT (
646 SELECT 1 FROM t2 WHERE x=1 EXCEPT SELECT 2 FROM t2 WHERE y=2
647 )
648 }
649 } {1}
650 do_test tkt1473-7.3 {
651 execsql {
652 SELECT EXISTS (
653 SELECT 1 FROM t2 WHERE x=1 EXCEPT SELECT 2 FROM t2 WHERE y=2
654 )
655 }
656 } {1}
657 do_test tkt1473-7.4 {
658 execsql {
659 SELECT (
660 SELECT 1 FROM t2 WHERE x=0 EXCEPT SELECT 2 FROM t2 WHERE y=2
661 )
662 }
663 } {{}}
664 do_test tkt1473-7.5 {
665 execsql {
666 SELECT EXISTS (
667 SELECT 1 FROM t2 WHERE x=0 EXCEPT SELECT 2 FROM t2 WHERE y=2
668 )
669 }
670 } {0}
671  
672 do_test tkt1473-8.1 {
673 execsql {
674 SELECT 1 FROM t2 WHERE x=1 INTERSECT SELECT 2 FROM t2 WHERE y=2
675 }
676 } {}
677 do_test tkt1473-8.1 {
678 execsql {
679 SELECT 1 FROM t2 WHERE x=1 INTERSECT SELECT 1 FROM t2 WHERE y=2
680 }
681 } {1}
682 do_test tkt1473-8.3 {
683 execsql {
684 SELECT (
685 SELECT 1 FROM t2 WHERE x=1 INTERSECT SELECT 2 FROM t2 WHERE y=2
686 )
687 }
688 } {{}}
689 do_test tkt1473-8.4 {
690 execsql {
691 SELECT (
692 SELECT 1 FROM t2 WHERE x=1 INTERSECT SELECT 1 FROM t2 WHERE y=2
693 )
694 }
695 } {1}
696 do_test tkt1473-8.5 {
697 execsql {
698 SELECT EXISTS (
699 SELECT 1 FROM t2 WHERE x=1 INTERSECT SELECT 2 FROM t2 WHERE y=2
700 )
701 }
702 } {0}
703 do_test tkt1473-8.6 {
704 execsql {
705 SELECT EXISTS (
706 SELECT 1 FROM t2 WHERE x=1 INTERSECT SELECT 1 FROM t2 WHERE y=2
707 )
708 }
709 } {1}
710 do_test tkt1473-8.7 {
711 execsql {
712 SELECT (
713 SELECT 1 FROM t2 WHERE x=0 INTERSECT SELECT 1 FROM t2 WHERE y=2
714 )
715 }
716 } {{}}
717 do_test tkt1473-8.8 {
718 execsql {
719 SELECT EXISTS (
720 SELECT 1 FROM t2 WHERE x=1 INTERSECT SELECT 1 FROM t2 WHERE y=0
721 )
722 }
723 } {0}
724  
725  
726  
727  
728 finish_test