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 729
