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