Changeset: 79b78df6bac0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/79b78df6bac0 Removed Files: sql/test/parser/Tests/All sql/test/parser/Tests/huge_where.test Branch: reducedstack Log Message:
Removes tests as it's similar with Bug-7092 diffs (truncated from 37307 to 300 lines): diff --git a/sql/test/parser/Tests/All b/sql/test/parser/Tests/All deleted file mode 100644 --- a/sql/test/parser/Tests/All +++ /dev/null @@ -1,1 +0,0 @@ -huge_where diff --git a/sql/test/parser/Tests/huge_where.test b/sql/test/parser/Tests/huge_where.test deleted file mode 100644 --- a/sql/test/parser/Tests/huge_where.test +++ /dev/null @@ -1,37296 +0,0 @@ -statement ok -create table if not exists foo ( col_a int, col_0 int, col_1 int, col_2 int, col_3 int, col_4 int, col_5 int, key int) - -statement ok -create table if not exists bar (FLG int, key int) - -query I nosort -SELECT - COUNT(DISTINCT foo.key) -FROM - foo, bar -WHERE ((foo.col_5 = 9488896) - AND (NOT foo.col_a IS NULL) - AND (((foo.col_2 = 59753052) - AND (foo.col_1 = 7897375) - AND (foo.col_3 = 478082192) - AND (foo.col_4 = 481724421)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7897375) - AND (foo.col_3 = 478057266) - AND (foo.col_4 = 676589)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885925) - AND (foo.col_3 = 59779251) - AND (foo.col_4 = 6947111)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885925) - AND (foo.col_3 = 59783217) - AND (foo.col_4 = 9492360)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885925) - AND (foo.col_3 = 59779674) - AND (foo.col_4 = 719394)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885925) - AND (foo.col_3 = 59782757) - AND (foo.col_4 = 10968081)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885925) - AND (foo.col_3 = 59782757) - AND (foo.col_4 = 10967678)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885924) - AND (foo.col_3 = 92184566) - AND (foo.col_4 = 81418805)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885924) - AND (foo.col_3 = 440429329) - AND (foo.col_4 = 436756504)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885924) - AND (foo.col_3 = 59779447) - AND (foo.col_4 = 10571654)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885924) - AND (foo.col_3 = 107525329) - AND (foo.col_4 = 689588)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885928) - AND (foo.col_3 = 59779377) - AND (foo.col_4 = 7585953)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885928) - AND (foo.col_3 = 59783275) - AND (foo.col_4 = 68735682)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885923) - AND (foo.col_3 = 134089659) - AND (foo.col_4 = 4497056)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885920) - AND (foo.col_3 = 59782751) - AND (foo.col_4 = 2710097)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 107525306) - AND (foo.col_4 = 36824241)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 59785926) - AND (foo.col_4 = 57489351)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 59781283) - AND (foo.col_4 = 36254910)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 59781012) - AND (foo.col_4 = 712559)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 101751965) - AND (foo.col_4 = 97295278)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 59782086) - AND (foo.col_4 = 57489070)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 59780413) - AND (foo.col_4 = 57488291)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 93030393) - AND (foo.col_4 = 92624555)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 59781854) - AND (foo.col_4 = 59829138)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 59780549) - AND (foo.col_4 = 685381)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 59780707) - AND (foo.col_4 = 731718)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885918) - AND (foo.col_3 = 59779936) - AND (foo.col_4 = 57489594)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885926) - AND (foo.col_3 = 59781401) - AND (foo.col_4 = 15687347)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885926) - AND (foo.col_3 = 222813061) - AND (foo.col_4 = 627904)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885926) - AND (foo.col_3 = 59781034) - AND (foo.col_4 = 38732591)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885926) - AND (foo.col_3 = 59781413) - AND (foo.col_4 = 7127004)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885926) - AND (foo.col_3 = 330679784) - AND (foo.col_4 = 301595750)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885926) - AND (foo.col_3 = 107525278) - AND (foo.col_4 = 22298753)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885926) - AND (foo.col_3 = 59779510) - AND (foo.col_4 = 15580739)) - OR ((foo.col_2 = 59753052) - AND (foo.col_1 = 7885926) - AND (foo.col_3 = 59779326) - AND (foo.col_4 = 59829119)) - OR (foo.col_a = 42175256) - OR (foo.col_a = 41733615) - OR (foo.col_a = 41740362) - OR (foo.col_a = 42852376) - OR (foo.col_a = 323536743) - OR (foo.col_a = 8499058) - OR (foo.col_a = 594102841) - OR (foo.col_a = 8504578) - OR (foo.col_a = 8384228) - OR (foo.col_a = 9660565) - OR (foo.col_a = 9625104) - OR (foo.col_a = 9632175) - OR (foo.col_a = 9716095) - OR (foo.col_a = 9631884) - OR (foo.col_a = 9634053) - OR (foo.col_a = 9614819) - OR (foo.col_a = 9622859) - OR (foo.col_a = 9622830) - OR (foo.col_a = 372539233) - OR (foo.col_a = 497916775) - OR (foo.col_a = 9701330) - OR (foo.col_a = 189654608) - OR (foo.col_a = 9643024) - OR (foo.col_a = 9660562) - OR (foo.col_a = 9622823) - OR (foo.col_a = 9632164) - OR (foo.col_a = 41776667) - OR (foo.col_a = 345349954) - OR (foo.col_a = 9728322) - OR (foo.col_a = 9634154) - OR (foo.col_a = 9639288) - OR (foo.col_a = 9631941) - OR (foo.col_a = 9614922) - OR (foo.col_a = 9622918) - OR (foo.col_a = 9641394) - OR (foo.col_a = 914529412) - OR (foo.col_a = 773570079) - OR (foo.col_a = 9387268) - OR (foo.col_a = 671526696) - OR (foo.col_a = 431887635) - OR (foo.col_a = 9892144) - OR (foo.col_a = 901832023) - OR (foo.col_a = 275597105) - OR (foo.col_a = 8663961) - OR (foo.col_a = 18180742) - OR (foo.col_a = 18180781) - OR (foo.col_a = 18182702) - OR (foo.col_a = 18177704) - OR (foo.col_a = 18183137) - OR (foo.col_a = 18183519) - OR (foo.col_a = 272736941) - OR (foo.col_a = 11060681) - OR (foo.col_a = 328608090) - OR (foo.col_a = 901832021) - OR (foo.col_a = 895033906) - OR (foo.col_a = 532146334) - OR (foo.col_a = 900547348) - OR (foo.col_a = 769781593) - OR (foo.col_a = 1052356394) - OR (foo.col_a = 1026063275) - OR (foo.col_a = 850565768) - OR (foo.col_a = 20183673) - OR (foo.col_a = 8413595) - OR (foo.col_a = 40960469) - OR (foo.col_a = 55850131) - OR (foo.col_a = 769781600) - OR (foo.col_a = 877848729) - OR (foo.col_a = 335748889) - OR (foo.col_a = 265445779) - OR (foo.col_a = 227470466) - OR (foo.col_a = 345390144) - OR (foo.col_a = 1044300328) - OR (foo.col_a = 21544124) - OR (foo.col_a = 190575324) - OR (foo.col_a = 909829440) - OR (foo.col_a = 928713089) - OR (foo.col_a = 168586745) - OR (foo.col_a = 197307915) - OR (foo.col_a = 358456610) - OR (foo.col_a = 190344025) - OR (foo.col_a = 940299443) - OR (foo.col_a = 8432673) - OR (foo.col_a = 211814347) - OR (foo.col_a = 125365676) - OR (foo.col_a = 198215193) - OR (foo.col_a = 197307916) - OR (foo.col_a = 562920256) - OR (foo.col_a = 1730158203) - OR (foo.col_a = 1659629676) - OR (foo.col_a = 9270145) - OR (foo.col_a = 9270270) - OR (foo.col_a = 9287406) - OR (foo.col_a = 9276794) - OR (foo.col_a = 9287314) - OR (foo.col_a = 9277396) - OR (foo.col_a = 11424298) - OR (foo.col_a = 44476816) - OR (foo.col_a = 199759971) - OR (foo.col_a = 387379550) - OR (foo.col_a = 2135370724) - OR (foo.col_a = 669259253) - OR (foo.col_a = 12086099) - OR (foo.col_a = 9333418) - OR (foo.col_a = 9344959) - OR (foo.col_a = 9347837) - OR (foo.col_a = 12105015) - OR (foo.col_a = 16185681) - OR (foo.col_a = 9354795) - OR (foo.col_a = 9334753) - OR (foo.col_a = 9348804) - OR (foo.col_a = 9346164) - OR (foo.col_a = 9354393) - OR (foo.col_a = 9334887) - OR (foo.col_a = 9332893) - OR (foo.col_a = 9351403) - OR (foo.col_a = 16188416) - OR (foo.col_a = 16184108) - OR (foo.col_a = 9332715) - OR (foo.col_a = 15224862) - OR (foo.col_a = 20184255) - OR (foo.col_a = 9333693) - OR (foo.col_a = 19558652) - OR (foo.col_a = 12111141) - OR (foo.col_a = 9327822) - OR (foo.col_a = 9333135) - OR (foo.col_a = 12060403) - OR (foo.col_a = 12085235) - OR (foo.col_a = 20184105) - OR (foo.col_a = 9345410) - OR (foo.col_a = 9345282) - OR (foo.col_a = 9345118) - OR (foo.col_a = 9348330) - OR (foo.col_a = 12102971) - OR (foo.col_a = 9327732) - OR (foo.col_a = 9339994) - OR (foo.col_a = 127098356) _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
