MySQL Lists: commits: bzr commit into mysql-6.0-falcon branch (klewis:2741)

List:	Commits	« Previous Message Next Message »
From:	Kevin Lewis	Date:	July 9 2008 11:33pm
Subject:	bzr commit into mysql-6.0-falcon branch (klewis:2741)
View as plain text
#At file:///C:/Work/bzr/Merge/mysql-6.0-falcon/

 2741 Kevin Lewis	2008-07-09 [merge]
      merge
added:
  mysql-test/suite/falcon/r/falcon_bug_37344_A.result
  mysql-test/suite/falcon/t/falcon_bug_37344_A.test
modified:
  storage/falcon/IndexWalker.cpp

=== added file 'mysql-test/suite/falcon/r/falcon_bug_37344_A.result'
--- a/mysql-test/suite/falcon/r/falcon_bug_37344_A.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/r/falcon_bug_37344_A.result	2008-07-08 15:10:55 +0000
@@ -0,0 +1,1258 @@
+*** Bug #37344 ***
+SET @@storage_engine = 'Falcon';
+set autocommit=1;
+DROP TABLE IF EXISTS A;
+Warnings:
+Note	1051	Unknown table 'a'
+CREATE TABLE A ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+DROP TABLE IF EXISTS B;
+Warnings:
+Note	1051	Unknown table 'b'
+CREATE TABLE B ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+INSERT INTO B ( int_nokey, int_key ) VALUES (0, 0);
+DROP TABLE IF EXISTS C;
+Warnings:
+Note	1051	Unknown table 'c'
+CREATE TABLE C ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+INSERT INTO C ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO C ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO C ( int_nokey, int_key ) VALUES (3, 3);
+INSERT INTO C ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO C ( int_nokey, int_key ) VALUES (4, 4);
+INSERT INTO C ( int_nokey, int_key ) VALUES (9, 9);
+INSERT INTO C ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO C ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO C ( int_nokey, int_key ) VALUES (0, 0);
+INSERT INTO C ( int_nokey, int_key ) VALUES (6, 6);
+DROP TABLE IF EXISTS D;
+Warnings:
+Note	1051	Unknown table 'd'
+CREATE TABLE D ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+INSERT INTO D ( int_nokey, int_key ) VALUES (37, 37);
+INSERT INTO D ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO D ( int_nokey, int_key ) VALUES (45, 45);
+INSERT INTO D ( int_nokey, int_key ) VALUES (78, 78);
+INSERT INTO D ( int_nokey, int_key ) VALUES (8, 8);
+INSERT INTO D ( int_nokey, int_key ) VALUES (52, 52);
+INSERT INTO D ( int_nokey, int_key ) VALUES (57, 57);
+INSERT INTO D ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO D ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67);
+INSERT INTO D ( int_nokey, int_key ) VALUES (18, 18);
+INSERT INTO D ( int_nokey, int_key ) VALUES (98, 98);
+INSERT INTO D ( int_nokey, int_key ) VALUES (85, 85);
+INSERT INTO D ( int_nokey, int_key ) VALUES (72, 72);
+INSERT INTO D ( int_nokey, int_key ) VALUES (79, 79);
+INSERT INTO D ( int_nokey, int_key ) VALUES (4, 4);
+INSERT INTO D ( int_nokey, int_key ) VALUES (21, 21);
+INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67);
+INSERT INTO D ( int_nokey, int_key ) VALUES (81, 81);
+INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43);
+INSERT INTO D ( int_nokey, int_key ) VALUES (74, 74);
+INSERT INTO D ( int_nokey, int_key ) VALUES (61, 61);
+INSERT INTO D ( int_nokey, int_key ) VALUES (56, 56);
+INSERT INTO D ( int_nokey, int_key ) VALUES (23, 23);
+INSERT INTO D ( int_nokey, int_key ) VALUES (81, 81);
+INSERT INTO D ( int_nokey, int_key ) VALUES (2, 2);
+INSERT INTO D ( int_nokey, int_key ) VALUES (58, 58);
+INSERT INTO D ( int_nokey, int_key ) VALUES (48, 48);
+INSERT INTO D ( int_nokey, int_key ) VALUES (73, 73);
+INSERT INTO D ( int_nokey, int_key ) VALUES (62, 62);
+INSERT INTO D ( int_nokey, int_key ) VALUES (10, 10);
+INSERT INTO D ( int_nokey, int_key ) VALUES (50, 50);
+INSERT INTO D ( int_nokey, int_key ) VALUES (11, 11);
+INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67);
+INSERT INTO D ( int_nokey, int_key ) VALUES (76, 76);
+INSERT INTO D ( int_nokey, int_key ) VALUES (42, 42);
+INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43);
+INSERT INTO D ( int_nokey, int_key ) VALUES (39, 39);
+INSERT INTO D ( int_nokey, int_key ) VALUES (55, 55);
+INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO D ( int_nokey, int_key ) VALUES (76, 76);
+INSERT INTO D ( int_nokey, int_key ) VALUES (40, 40);
+INSERT INTO D ( int_nokey, int_key ) VALUES (88, 88);
+INSERT INTO D ( int_nokey, int_key ) VALUES (51, 51);
+INSERT INTO D ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO D ( int_nokey, int_key ) VALUES (74, 74);
+INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO D ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43);
+INSERT INTO D ( int_nokey, int_key ) VALUES (48, 48);
+INSERT INTO D ( int_nokey, int_key ) VALUES (99, 99);
+INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO D ( int_nokey, int_key ) VALUES (62, 62);
+INSERT INTO D ( int_nokey, int_key ) VALUES (53, 53);
+INSERT INTO D ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO D ( int_nokey, int_key ) VALUES (55, 55);
+INSERT INTO D ( int_nokey, int_key ) VALUES (9, 9);
+INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67);
+INSERT INTO D ( int_nokey, int_key ) VALUES (98, 98);
+INSERT INTO D ( int_nokey, int_key ) VALUES (34, 34);
+INSERT INTO D ( int_nokey, int_key ) VALUES (51, 51);
+INSERT INTO D ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO D ( int_nokey, int_key ) VALUES (64, 64);
+INSERT INTO D ( int_nokey, int_key ) VALUES (36, 36);
+INSERT INTO D ( int_nokey, int_key ) VALUES (37, 37);
+INSERT INTO D ( int_nokey, int_key ) VALUES (66, 66);
+INSERT INTO D ( int_nokey, int_key ) VALUES (86, 86);
+INSERT INTO D ( int_nokey, int_key ) VALUES (11, 11);
+INSERT INTO D ( int_nokey, int_key ) VALUES (3, 3);
+INSERT INTO D ( int_nokey, int_key ) VALUES (12, 12);
+INSERT INTO D ( int_nokey, int_key ) VALUES (35, 35);
+INSERT INTO D ( int_nokey, int_key ) VALUES (79, 79);
+INSERT INTO D ( int_nokey, int_key ) VALUES (87, 87);
+INSERT INTO D ( int_nokey, int_key ) VALUES (41, 41);
+INSERT INTO D ( int_nokey, int_key ) VALUES (97, 97);
+INSERT INTO D ( int_nokey, int_key ) VALUES (81, 81);
+INSERT INTO D ( int_nokey, int_key ) VALUES (87, 87);
+INSERT INTO D ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO D ( int_nokey, int_key ) VALUES (29, 29);
+INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO D ( int_nokey, int_key ) VALUES (19, 19);
+INSERT INTO D ( int_nokey, int_key ) VALUES (28, 28);
+INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43);
+INSERT INTO D ( int_nokey, int_key ) VALUES (75, 75);
+INSERT INTO D ( int_nokey, int_key ) VALUES (77, 77);
+INSERT INTO D ( int_nokey, int_key ) VALUES (6, 6);
+INSERT INTO D ( int_nokey, int_key ) VALUES (56, 56);
+INSERT INTO D ( int_nokey, int_key ) VALUES (85, 85);
+INSERT INTO D ( int_nokey, int_key ) VALUES (65, 65);
+INSERT INTO D ( int_nokey, int_key ) VALUES (92, 92);
+INSERT INTO D ( int_nokey, int_key ) VALUES (73, 73);
+INSERT INTO D ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO D ( int_nokey, int_key ) VALUES (45, 45);
+INSERT INTO D ( int_nokey, int_key ) VALUES (98, 98);
+INSERT INTO D ( int_nokey, int_key ) VALUES (57, 57);
+INSERT INTO D ( int_nokey, int_key ) VALUES (48, 48);
+INSERT INTO D ( int_nokey, int_key ) VALUES (86, 86);
+INSERT INTO D ( int_nokey, int_key ) VALUES (15, 15);
+INSERT INTO D ( int_nokey, int_key ) VALUES (39, 39);
+INSERT INTO D ( int_nokey, int_key ) VALUES (85, 85);
+DROP TABLE IF EXISTS E;
+Warnings:
+Note	1051	Unknown table 'e'
+CREATE TABLE E ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO E ( int_nokey, int_key ) VALUES (595, 595);
+INSERT INTO E ( int_nokey, int_key ) VALUES (552, 552);
+INSERT INTO E ( int_nokey, int_key ) VALUES (46, 46);
+INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93);
+INSERT INTO E ( int_nokey, int_key ) VALUES (939, 939);
+INSERT INTO E ( int_nokey, int_key ) VALUES (507, 507);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (35, 35);
+INSERT INTO E ( int_nokey, int_key ) VALUES (727, 727);
+INSERT INTO E ( int_nokey, int_key ) VALUES (317, 317);
+INSERT INTO E ( int_nokey, int_key ) VALUES (225, 225);
+INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204);
+INSERT INTO E ( int_nokey, int_key ) VALUES (751, 751);
+INSERT INTO E ( int_nokey, int_key ) VALUES (955, 955);
+INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543);
+INSERT INTO E ( int_nokey, int_key ) VALUES (530, 530);
+INSERT INTO E ( int_nokey, int_key ) VALUES (395, 395);
+INSERT INTO E ( int_nokey, int_key ) VALUES (296, 296);
+INSERT INTO E ( int_nokey, int_key ) VALUES (831, 831);
+INSERT INTO E ( int_nokey, int_key ) VALUES (363, 363);
+INSERT INTO E ( int_nokey, int_key ) VALUES (144, 144);
+INSERT INTO E ( int_nokey, int_key ) VALUES (260, 260);
+INSERT INTO E ( int_nokey, int_key ) VALUES (117, 117);
+INSERT INTO E ( int_nokey, int_key ) VALUES (142, 142);
+INSERT INTO E ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO E ( int_nokey, int_key ) VALUES (560, 560);
+INSERT INTO E ( int_nokey, int_key ) VALUES (175, 175);
+INSERT INTO E ( int_nokey, int_key ) VALUES (675, 675);
+INSERT INTO E ( int_nokey, int_key ) VALUES (489, 489);
+INSERT INTO E ( int_nokey, int_key ) VALUES (564, 564);
+INSERT INTO E ( int_nokey, int_key ) VALUES (82, 82);
+INSERT INTO E ( int_nokey, int_key ) VALUES (75, 75);
+INSERT INTO E ( int_nokey, int_key ) VALUES (921, 921);
+INSERT INTO E ( int_nokey, int_key ) VALUES (495, 495);
+INSERT INTO E ( int_nokey, int_key ) VALUES (533, 533);
+INSERT INTO E ( int_nokey, int_key ) VALUES (673, 673);
+INSERT INTO E ( int_nokey, int_key ) VALUES (49, 49);
+INSERT INTO E ( int_nokey, int_key ) VALUES (168, 168);
+INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371);
+INSERT INTO E ( int_nokey, int_key ) VALUES (534, 534);
+INSERT INTO E ( int_nokey, int_key ) VALUES (437, 437);
+INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591);
+INSERT INTO E ( int_nokey, int_key ) VALUES (208, 208);
+INSERT INTO E ( int_nokey, int_key ) VALUES (622, 622);
+INSERT INTO E ( int_nokey, int_key ) VALUES (956, 956);
+INSERT INTO E ( int_nokey, int_key ) VALUES (652, 652);
+INSERT INTO E ( int_nokey, int_key ) VALUES (391, 391);
+INSERT INTO E ( int_nokey, int_key ) VALUES (875, 875);
+INSERT INTO E ( int_nokey, int_key ) VALUES (743, 743);
+INSERT INTO E ( int_nokey, int_key ) VALUES (347, 347);
+INSERT INTO E ( int_nokey, int_key ) VALUES (395, 395);
+INSERT INTO E ( int_nokey, int_key ) VALUES (956, 956);
+INSERT INTO E ( int_nokey, int_key ) VALUES (623, 623);
+INSERT INTO E ( int_nokey, int_key ) VALUES (525, 525);
+INSERT INTO E ( int_nokey, int_key ) VALUES (140, 140);
+INSERT INTO E ( int_nokey, int_key ) VALUES (119, 119);
+INSERT INTO E ( int_nokey, int_key ) VALUES (136, 136);
+INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94);
+INSERT INTO E ( int_nokey, int_key ) VALUES (857, 857);
+INSERT INTO E ( int_nokey, int_key ) VALUES (20, 20);
+INSERT INTO E ( int_nokey, int_key ) VALUES (77, 77);
+INSERT INTO E ( int_nokey, int_key ) VALUES (58, 58);
+INSERT INTO E ( int_nokey, int_key ) VALUES (243, 243);
+INSERT INTO E ( int_nokey, int_key ) VALUES (21, 21);
+INSERT INTO E ( int_nokey, int_key ) VALUES (879, 879);
+INSERT INTO E ( int_nokey, int_key ) VALUES (999, 999);
+INSERT INTO E ( int_nokey, int_key ) VALUES (678, 678);
+INSERT INTO E ( int_nokey, int_key ) VALUES (986, 986);
+INSERT INTO E ( int_nokey, int_key ) VALUES (521, 521);
+INSERT INTO E ( int_nokey, int_key ) VALUES (259, 259);
+INSERT INTO E ( int_nokey, int_key ) VALUES (711, 711);
+INSERT INTO E ( int_nokey, int_key ) VALUES (458, 458);
+INSERT INTO E ( int_nokey, int_key ) VALUES (235, 235);
+INSERT INTO E ( int_nokey, int_key ) VALUES (230, 230);
+INSERT INTO E ( int_nokey, int_key ) VALUES (145, 145);
+INSERT INTO E ( int_nokey, int_key ) VALUES (506, 506);
+INSERT INTO E ( int_nokey, int_key ) VALUES (734, 734);
+INSERT INTO E ( int_nokey, int_key ) VALUES (873, 873);
+INSERT INTO E ( int_nokey, int_key ) VALUES (920, 920);
+INSERT INTO E ( int_nokey, int_key ) VALUES (753, 753);
+INSERT INTO E ( int_nokey, int_key ) VALUES (941, 941);
+INSERT INTO E ( int_nokey, int_key ) VALUES (792, 792);
+INSERT INTO E ( int_nokey, int_key ) VALUES (587, 587);
+INSERT INTO E ( int_nokey, int_key ) VALUES (420, 420);
+INSERT INTO E ( int_nokey, int_key ) VALUES (799, 799);
+INSERT INTO E ( int_nokey, int_key ) VALUES (944, 944);
+INSERT INTO E ( int_nokey, int_key ) VALUES (597, 597);
+INSERT INTO E ( int_nokey, int_key ) VALUES (397, 397);
+INSERT INTO E ( int_nokey, int_key ) VALUES (939, 939);
+INSERT INTO E ( int_nokey, int_key ) VALUES (996, 996);
+INSERT INTO E ( int_nokey, int_key ) VALUES (328, 328);
+INSERT INTO E ( int_nokey, int_key ) VALUES (579, 579);
+INSERT INTO E ( int_nokey, int_key ) VALUES (64, 64);
+INSERT INTO E ( int_nokey, int_key ) VALUES (622, 622);
+INSERT INTO E ( int_nokey, int_key ) VALUES (982, 982);
+INSERT INTO E ( int_nokey, int_key ) VALUES (108, 108);
+INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378);
+INSERT INTO E ( int_nokey, int_key ) VALUES (995, 995);
+INSERT INTO E ( int_nokey, int_key ) VALUES (99, 99);
+INSERT INTO E ( int_nokey, int_key ) VALUES (842, 842);
+INSERT INTO E ( int_nokey, int_key ) VALUES (433, 433);
+INSERT INTO E ( int_nokey, int_key ) VALUES (663, 663);
+INSERT INTO E ( int_nokey, int_key ) VALUES (762, 762);
+INSERT INTO E ( int_nokey, int_key ) VALUES (921, 921);
+INSERT INTO E ( int_nokey, int_key ) VALUES (9, 9);
+INSERT INTO E ( int_nokey, int_key ) VALUES (895, 895);
+INSERT INTO E ( int_nokey, int_key ) VALUES (2, 2);
+INSERT INTO E ( int_nokey, int_key ) VALUES (653, 653);
+INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184);
+INSERT INTO E ( int_nokey, int_key ) VALUES (905, 905);
+INSERT INTO E ( int_nokey, int_key ) VALUES (809, 809);
+INSERT INTO E ( int_nokey, int_key ) VALUES (124, 124);
+INSERT INTO E ( int_nokey, int_key ) VALUES (446, 446);
+INSERT INTO E ( int_nokey, int_key ) VALUES (777, 777);
+INSERT INTO E ( int_nokey, int_key ) VALUES (501, 501);
+INSERT INTO E ( int_nokey, int_key ) VALUES (810, 810);
+INSERT INTO E ( int_nokey, int_key ) VALUES (381, 381);
+INSERT INTO E ( int_nokey, int_key ) VALUES (970, 970);
+INSERT INTO E ( int_nokey, int_key ) VALUES (224, 224);
+INSERT INTO E ( int_nokey, int_key ) VALUES (435, 435);
+INSERT INTO E ( int_nokey, int_key ) VALUES (401, 401);
+INSERT INTO E ( int_nokey, int_key ) VALUES (360, 360);
+INSERT INTO E ( int_nokey, int_key ) VALUES (757, 757);
+INSERT INTO E ( int_nokey, int_key ) VALUES (167, 167);
+INSERT INTO E ( int_nokey, int_key ) VALUES (609, 609);
+INSERT INTO E ( int_nokey, int_key ) VALUES (607, 607);
+INSERT INTO E ( int_nokey, int_key ) VALUES (728, 728);
+INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745);
+INSERT INTO E ( int_nokey, int_key ) VALUES (929, 929);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (31, 31);
+INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO E ( int_nokey, int_key ) VALUES (190, 190);
+INSERT INTO E ( int_nokey, int_key ) VALUES (339, 339);
+INSERT INTO E ( int_nokey, int_key ) VALUES (940, 940);
+INSERT INTO E ( int_nokey, int_key ) VALUES (141, 141);
+INSERT INTO E ( int_nokey, int_key ) VALUES (928, 928);
+INSERT INTO E ( int_nokey, int_key ) VALUES (642, 642);
+INSERT INTO E ( int_nokey, int_key ) VALUES (814, 814);
+INSERT INTO E ( int_nokey, int_key ) VALUES (182, 182);
+INSERT INTO E ( int_nokey, int_key ) VALUES (283, 283);
+INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591);
+INSERT INTO E ( int_nokey, int_key ) VALUES (696, 696);
+INSERT INTO E ( int_nokey, int_key ) VALUES (679, 679);
+INSERT INTO E ( int_nokey, int_key ) VALUES (612, 612);
+INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (469, 469);
+INSERT INTO E ( int_nokey, int_key ) VALUES (231, 231);
+INSERT INTO E ( int_nokey, int_key ) VALUES (9, 9);
+INSERT INTO E ( int_nokey, int_key ) VALUES (115, 115);
+INSERT INTO E ( int_nokey, int_key ) VALUES (552, 552);
+INSERT INTO E ( int_nokey, int_key ) VALUES (455, 455);
+INSERT INTO E ( int_nokey, int_key ) VALUES (463, 463);
+INSERT INTO E ( int_nokey, int_key ) VALUES (831, 831);
+INSERT INTO E ( int_nokey, int_key ) VALUES (338, 338);
+INSERT INTO E ( int_nokey, int_key ) VALUES (338, 338);
+INSERT INTO E ( int_nokey, int_key ) VALUES (513, 513);
+INSERT INTO E ( int_nokey, int_key ) VALUES (819, 819);
+INSERT INTO E ( int_nokey, int_key ) VALUES (900, 900);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (481, 481);
+INSERT INTO E ( int_nokey, int_key ) VALUES (369, 369);
+INSERT INTO E ( int_nokey, int_key ) VALUES (267, 267);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (493, 493);
+INSERT INTO E ( int_nokey, int_key ) VALUES (299, 299);
+INSERT INTO E ( int_nokey, int_key ) VALUES (460, 460);
+INSERT INTO E ( int_nokey, int_key ) VALUES (426, 426);
+INSERT INTO E ( int_nokey, int_key ) VALUES (54, 54);
+INSERT INTO E ( int_nokey, int_key ) VALUES (332, 332);
+INSERT INTO E ( int_nokey, int_key ) VALUES (260, 260);
+INSERT INTO E ( int_nokey, int_key ) VALUES (900, 900);
+INSERT INTO E ( int_nokey, int_key ) VALUES (656, 656);
+INSERT INTO E ( int_nokey, int_key ) VALUES (192, 192);
+INSERT INTO E ( int_nokey, int_key ) VALUES (708, 708);
+INSERT INTO E ( int_nokey, int_key ) VALUES (254, 254);
+INSERT INTO E ( int_nokey, int_key ) VALUES (82, 82);
+INSERT INTO E ( int_nokey, int_key ) VALUES (424, 424);
+INSERT INTO E ( int_nokey, int_key ) VALUES (246, 246);
+INSERT INTO E ( int_nokey, int_key ) VALUES (565, 565);
+INSERT INTO E ( int_nokey, int_key ) VALUES (274, 274);
+INSERT INTO E ( int_nokey, int_key ) VALUES (909, 909);
+INSERT INTO E ( int_nokey, int_key ) VALUES (883, 883);
+INSERT INTO E ( int_nokey, int_key ) VALUES (751, 751);
+INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378);
+INSERT INTO E ( int_nokey, int_key ) VALUES (436, 436);
+INSERT INTO E ( int_nokey, int_key ) VALUES (807, 807);
+INSERT INTO E ( int_nokey, int_key ) VALUES (571, 571);
+INSERT INTO E ( int_nokey, int_key ) VALUES (930, 930);
+INSERT INTO E ( int_nokey, int_key ) VALUES (824, 824);
+INSERT INTO E ( int_nokey, int_key ) VALUES (532, 532);
+INSERT INTO E ( int_nokey, int_key ) VALUES (368, 368);
+INSERT INTO E ( int_nokey, int_key ) VALUES (278, 278);
+INSERT INTO E ( int_nokey, int_key ) VALUES (549, 549);
+INSERT INTO E ( int_nokey, int_key ) VALUES (940, 940);
+INSERT INTO E ( int_nokey, int_key ) VALUES (11, 11);
+INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457);
+INSERT INTO E ( int_nokey, int_key ) VALUES (56, 56);
+INSERT INTO E ( int_nokey, int_key ) VALUES (825, 825);
+INSERT INTO E ( int_nokey, int_key ) VALUES (350, 350);
+INSERT INTO E ( int_nokey, int_key ) VALUES (637, 637);
+INSERT INTO E ( int_nokey, int_key ) VALUES (843, 843);
+INSERT INTO E ( int_nokey, int_key ) VALUES (747, 747);
+INSERT INTO E ( int_nokey, int_key ) VALUES (415, 415);
+INSERT INTO E ( int_nokey, int_key ) VALUES (425, 425);
+INSERT INTO E ( int_nokey, int_key ) VALUES (642, 642);
+INSERT INTO E ( int_nokey, int_key ) VALUES (889, 889);
+INSERT INTO E ( int_nokey, int_key ) VALUES (196, 196);
+INSERT INTO E ( int_nokey, int_key ) VALUES (40, 40);
+INSERT INTO E ( int_nokey, int_key ) VALUES (988, 988);
+INSERT INTO E ( int_nokey, int_key ) VALUES (22, 22);
+INSERT INTO E ( int_nokey, int_key ) VALUES (989, 989);
+INSERT INTO E ( int_nokey, int_key ) VALUES (393, 393);
+INSERT INTO E ( int_nokey, int_key ) VALUES (801, 801);
+INSERT INTO E ( int_nokey, int_key ) VALUES (865, 865);
+INSERT INTO E ( int_nokey, int_key ) VALUES (868, 868);
+INSERT INTO E ( int_nokey, int_key ) VALUES (397, 397);
+INSERT INTO E ( int_nokey, int_key ) VALUES (251, 251);
+INSERT INTO E ( int_nokey, int_key ) VALUES (750, 750);
+INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543);
+INSERT INTO E ( int_nokey, int_key ) VALUES (180, 180);
+INSERT INTO E ( int_nokey, int_key ) VALUES (846, 846);
+INSERT INTO E ( int_nokey, int_key ) VALUES (193, 193);
+INSERT INTO E ( int_nokey, int_key ) VALUES (808, 808);
+INSERT INTO E ( int_nokey, int_key ) VALUES (12, 12);
+INSERT INTO E ( int_nokey, int_key ) VALUES (818, 818);
+INSERT INTO E ( int_nokey, int_key ) VALUES (407, 407);
+INSERT INTO E ( int_nokey, int_key ) VALUES (459, 459);
+INSERT INTO E ( int_nokey, int_key ) VALUES (547, 547);
+INSERT INTO E ( int_nokey, int_key ) VALUES (220, 220);
+INSERT INTO E ( int_nokey, int_key ) VALUES (907, 907);
+INSERT INTO E ( int_nokey, int_key ) VALUES (372, 372);
+INSERT INTO E ( int_nokey, int_key ) VALUES (893, 893);
+INSERT INTO E ( int_nokey, int_key ) VALUES (660, 660);
+INSERT INTO E ( int_nokey, int_key ) VALUES (788, 788);
+INSERT INTO E ( int_nokey, int_key ) VALUES (667, 667);
+INSERT INTO E ( int_nokey, int_key ) VALUES (31, 31);
+INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94);
+INSERT INTO E ( int_nokey, int_key ) VALUES (326, 326);
+INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184);
+INSERT INTO E ( int_nokey, int_key ) VALUES (281, 281);
+INSERT INTO E ( int_nokey, int_key ) VALUES (58, 58);
+INSERT INTO E ( int_nokey, int_key ) VALUES (801, 801);
+INSERT INTO E ( int_nokey, int_key ) VALUES (970, 970);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (910, 910);
+INSERT INTO E ( int_nokey, int_key ) VALUES (619, 619);
+INSERT INTO E ( int_nokey, int_key ) VALUES (37, 37);
+INSERT INTO E ( int_nokey, int_key ) VALUES (380, 380);
+INSERT INTO E ( int_nokey, int_key ) VALUES (247, 247);
+INSERT INTO E ( int_nokey, int_key ) VALUES (320, 320);
+INSERT INTO E ( int_nokey, int_key ) VALUES (190, 190);
+INSERT INTO E ( int_nokey, int_key ) VALUES (716, 716);
+INSERT INTO E ( int_nokey, int_key ) VALUES (298, 298);
+INSERT INTO E ( int_nokey, int_key ) VALUES (146, 146);
+INSERT INTO E ( int_nokey, int_key ) VALUES (376, 376);
+INSERT INTO E ( int_nokey, int_key ) VALUES (808, 808);
+INSERT INTO E ( int_nokey, int_key ) VALUES (544, 544);
+INSERT INTO E ( int_nokey, int_key ) VALUES (675, 675);
+INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591);
+INSERT INTO E ( int_nokey, int_key ) VALUES (272, 272);
+INSERT INTO E ( int_nokey, int_key ) VALUES (811, 811);
+INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371);
+INSERT INTO E ( int_nokey, int_key ) VALUES (141, 141);
+INSERT INTO E ( int_nokey, int_key ) VALUES (570, 570);
+INSERT INTO E ( int_nokey, int_key ) VALUES (758, 758);
+INSERT INTO E ( int_nokey, int_key ) VALUES (871, 871);
+INSERT INTO E ( int_nokey, int_key ) VALUES (707, 707);
+INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611);
+INSERT INTO E ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO E ( int_nokey, int_key ) VALUES (374, 374);
+INSERT INTO E ( int_nokey, int_key ) VALUES (697, 697);
+INSERT INTO E ( int_nokey, int_key ) VALUES (227, 227);
+INSERT INTO E ( int_nokey, int_key ) VALUES (636, 636);
+INSERT INTO E ( int_nokey, int_key ) VALUES (907, 907);
+INSERT INTO E ( int_nokey, int_key ) VALUES (249, 249);
+INSERT INTO E ( int_nokey, int_key ) VALUES (724, 724);
+INSERT INTO E ( int_nokey, int_key ) VALUES (480, 480);
+INSERT INTO E ( int_nokey, int_key ) VALUES (727, 727);
+INSERT INTO E ( int_nokey, int_key ) VALUES (862, 862);
+INSERT INTO E ( int_nokey, int_key ) VALUES (530, 530);
+INSERT INTO E ( int_nokey, int_key ) VALUES (601, 601);
+INSERT INTO E ( int_nokey, int_key ) VALUES (866, 866);
+INSERT INTO E ( int_nokey, int_key ) VALUES (0, 0);
+INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745);
+INSERT INTO E ( int_nokey, int_key ) VALUES (652, 652);
+INSERT INTO E ( int_nokey, int_key ) VALUES (509, 509);
+INSERT INTO E ( int_nokey, int_key ) VALUES (592, 592);
+INSERT INTO E ( int_nokey, int_key ) VALUES (969, 969);
+INSERT INTO E ( int_nokey, int_key ) VALUES (58, 58);
+INSERT INTO E ( int_nokey, int_key ) VALUES (592, 592);
+INSERT INTO E ( int_nokey, int_key ) VALUES (717, 717);
+INSERT INTO E ( int_nokey, int_key ) VALUES (415, 415);
+INSERT INTO E ( int_nokey, int_key ) VALUES (181, 181);
+INSERT INTO E ( int_nokey, int_key ) VALUES (783, 783);
+INSERT INTO E ( int_nokey, int_key ) VALUES (702, 702);
+INSERT INTO E ( int_nokey, int_key ) VALUES (587, 587);
+INSERT INTO E ( int_nokey, int_key ) VALUES (88, 88);
+INSERT INTO E ( int_nokey, int_key ) VALUES (836, 836);
+INSERT INTO E ( int_nokey, int_key ) VALUES (872, 872);
+INSERT INTO E ( int_nokey, int_key ) VALUES (996, 996);
+INSERT INTO E ( int_nokey, int_key ) VALUES (162, 162);
+INSERT INTO E ( int_nokey, int_key ) VALUES (725, 725);
+INSERT INTO E ( int_nokey, int_key ) VALUES (116, 116);
+INSERT INTO E ( int_nokey, int_key ) VALUES (916, 916);
+INSERT INTO E ( int_nokey, int_key ) VALUES (466, 466);
+INSERT INTO E ( int_nokey, int_key ) VALUES (737, 737);
+INSERT INTO E ( int_nokey, int_key ) VALUES (702, 702);
+INSERT INTO E ( int_nokey, int_key ) VALUES (325, 325);
+INSERT INTO E ( int_nokey, int_key ) VALUES (441, 441);
+INSERT INTO E ( int_nokey, int_key ) VALUES (904, 904);
+INSERT INTO E ( int_nokey, int_key ) VALUES (546, 546);
+INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93);
+INSERT INTO E ( int_nokey, int_key ) VALUES (519, 519);
+INSERT INTO E ( int_nokey, int_key ) VALUES (360, 360);
+INSERT INTO E ( int_nokey, int_key ) VALUES (435, 435);
+INSERT INTO E ( int_nokey, int_key ) VALUES (598, 598);
+INSERT INTO E ( int_nokey, int_key ) VALUES (663, 663);
+INSERT INTO E ( int_nokey, int_key ) VALUES (910, 910);
+INSERT INTO E ( int_nokey, int_key ) VALUES (147, 147);
+INSERT INTO E ( int_nokey, int_key ) VALUES (47, 47);
+INSERT INTO E ( int_nokey, int_key ) VALUES (529, 529);
+INSERT INTO E ( int_nokey, int_key ) VALUES (845, 845);
+INSERT INTO E ( int_nokey, int_key ) VALUES (779, 779);
+INSERT INTO E ( int_nokey, int_key ) VALUES (479, 479);
+INSERT INTO E ( int_nokey, int_key ) VALUES (931, 931);
+INSERT INTO E ( int_nokey, int_key ) VALUES (669, 669);
+INSERT INTO E ( int_nokey, int_key ) VALUES (657, 657);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (37, 37);
+INSERT INTO E ( int_nokey, int_key ) VALUES (347, 347);
+INSERT INTO E ( int_nokey, int_key ) VALUES (676, 676);
+INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378);
+INSERT INTO E ( int_nokey, int_key ) VALUES (323, 323);
+INSERT INTO E ( int_nokey, int_key ) VALUES (266, 266);
+INSERT INTO E ( int_nokey, int_key ) VALUES (790, 790);
+INSERT INTO E ( int_nokey, int_key ) VALUES (780, 780);
+INSERT INTO E ( int_nokey, int_key ) VALUES (616, 616);
+INSERT INTO E ( int_nokey, int_key ) VALUES (619, 619);
+INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130);
+INSERT INTO E ( int_nokey, int_key ) VALUES (69, 69);
+INSERT INTO E ( int_nokey, int_key ) VALUES (812, 812);
+INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO E ( int_nokey, int_key ) VALUES (128, 128);
+INSERT INTO E ( int_nokey, int_key ) VALUES (484, 484);
+INSERT INTO E ( int_nokey, int_key ) VALUES (465, 465);
+INSERT INTO E ( int_nokey, int_key ) VALUES (534, 534);
+INSERT INTO E ( int_nokey, int_key ) VALUES (417, 417);
+INSERT INTO E ( int_nokey, int_key ) VALUES (333, 333);
+INSERT INTO E ( int_nokey, int_key ) VALUES (555, 555);
+INSERT INTO E ( int_nokey, int_key ) VALUES (172, 172);
+INSERT INTO E ( int_nokey, int_key ) VALUES (586, 586);
+INSERT INTO E ( int_nokey, int_key ) VALUES (965, 965);
+INSERT INTO E ( int_nokey, int_key ) VALUES (383, 383);
+INSERT INTO E ( int_nokey, int_key ) VALUES (283, 283);
+INSERT INTO E ( int_nokey, int_key ) VALUES (305, 305);
+INSERT INTO E ( int_nokey, int_key ) VALUES (984, 984);
+INSERT INTO E ( int_nokey, int_key ) VALUES (925, 925);
+INSERT INTO E ( int_nokey, int_key ) VALUES (213, 213);
+INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591);
+INSERT INTO E ( int_nokey, int_key ) VALUES (445, 445);
+INSERT INTO E ( int_nokey, int_key ) VALUES (550, 550);
+INSERT INTO E ( int_nokey, int_key ) VALUES (309, 309);
+INSERT INTO E ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO E ( int_nokey, int_key ) VALUES (477, 477);
+INSERT INTO E ( int_nokey, int_key ) VALUES (92, 92);
+INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204);
+INSERT INTO E ( int_nokey, int_key ) VALUES (471, 471);
+INSERT INTO E ( int_nokey, int_key ) VALUES (739, 739);
+INSERT INTO E ( int_nokey, int_key ) VALUES (847, 847);
+INSERT INTO E ( int_nokey, int_key ) VALUES (239, 239);
+INSERT INTO E ( int_nokey, int_key ) VALUES (502, 502);
+INSERT INTO E ( int_nokey, int_key ) VALUES (245, 245);
+INSERT INTO E ( int_nokey, int_key ) VALUES (449, 449);
+INSERT INTO E ( int_nokey, int_key ) VALUES (263, 263);
+INSERT INTO E ( int_nokey, int_key ) VALUES (210, 210);
+INSERT INTO E ( int_nokey, int_key ) VALUES (336, 336);
+INSERT INTO E ( int_nokey, int_key ) VALUES (309, 309);
+INSERT INTO E ( int_nokey, int_key ) VALUES (216, 216);
+INSERT INTO E ( int_nokey, int_key ) VALUES (375, 375);
+INSERT INTO E ( int_nokey, int_key ) VALUES (78, 78);
+INSERT INTO E ( int_nokey, int_key ) VALUES (697, 697);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625);
+INSERT INTO E ( int_nokey, int_key ) VALUES (696, 696);
+INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745);
+INSERT INTO E ( int_nokey, int_key ) VALUES (78, 78);
+INSERT INTO E ( int_nokey, int_key ) VALUES (56, 56);
+INSERT INTO E ( int_nokey, int_key ) VALUES (144, 144);
+INSERT INTO E ( int_nokey, int_key ) VALUES (907, 907);
+INSERT INTO E ( int_nokey, int_key ) VALUES (103, 103);
+INSERT INTO E ( int_nokey, int_key ) VALUES (242, 242);
+INSERT INTO E ( int_nokey, int_key ) VALUES (764, 764);
+INSERT INTO E ( int_nokey, int_key ) VALUES (425, 425);
+INSERT INTO E ( int_nokey, int_key ) VALUES (760, 760);
+INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184);
+INSERT INTO E ( int_nokey, int_key ) VALUES (689, 689);
+INSERT INTO E ( int_nokey, int_key ) VALUES (502, 502);
+INSERT INTO E ( int_nokey, int_key ) VALUES (965, 965);
+INSERT INTO E ( int_nokey, int_key ) VALUES (630, 630);
+INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO E ( int_nokey, int_key ) VALUES (263, 263);
+INSERT INTO E ( int_nokey, int_key ) VALUES (151, 151);
+INSERT INTO E ( int_nokey, int_key ) VALUES (136, 136);
+INSERT INTO E ( int_nokey, int_key ) VALUES (83, 83);
+INSERT INTO E ( int_nokey, int_key ) VALUES (651, 651);
+INSERT INTO E ( int_nokey, int_key ) VALUES (91, 91);
+INSERT INTO E ( int_nokey, int_key ) VALUES (704, 704);
+INSERT INTO E ( int_nokey, int_key ) VALUES (986, 986);
+INSERT INTO E ( int_nokey, int_key ) VALUES (875, 875);
+INSERT INTO E ( int_nokey, int_key ) VALUES (382, 382);
+INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371);
+INSERT INTO E ( int_nokey, int_key ) VALUES (616, 616);
+INSERT INTO E ( int_nokey, int_key ) VALUES (235, 235);
+INSERT INTO E ( int_nokey, int_key ) VALUES (753, 753);
+INSERT INTO E ( int_nokey, int_key ) VALUES (592, 592);
+INSERT INTO E ( int_nokey, int_key ) VALUES (982, 982);
+INSERT INTO E ( int_nokey, int_key ) VALUES (428, 428);
+INSERT INTO E ( int_nokey, int_key ) VALUES (214, 214);
+INSERT INTO E ( int_nokey, int_key ) VALUES (864, 864);
+INSERT INTO E ( int_nokey, int_key ) VALUES (394, 394);
+INSERT INTO E ( int_nokey, int_key ) VALUES (206, 206);
+INSERT INTO E ( int_nokey, int_key ) VALUES (19, 19);
+INSERT INTO E ( int_nokey, int_key ) VALUES (934, 934);
+INSERT INTO E ( int_nokey, int_key ) VALUES (954, 954);
+INSERT INTO E ( int_nokey, int_key ) VALUES (246, 246);
+INSERT INTO E ( int_nokey, int_key ) VALUES (704, 704);
+INSERT INTO E ( int_nokey, int_key ) VALUES (235, 235);
+INSERT INTO E ( int_nokey, int_key ) VALUES (723, 723);
+INSERT INTO E ( int_nokey, int_key ) VALUES (834, 834);
+INSERT INTO E ( int_nokey, int_key ) VALUES (356, 356);
+INSERT INTO E ( int_nokey, int_key ) VALUES (149, 149);
+INSERT INTO E ( int_nokey, int_key ) VALUES (664, 664);
+INSERT INTO E ( int_nokey, int_key ) VALUES (754, 754);
+INSERT INTO E ( int_nokey, int_key ) VALUES (872, 872);
+INSERT INTO E ( int_nokey, int_key ) VALUES (317, 317);
+INSERT INTO E ( int_nokey, int_key ) VALUES (657, 657);
+INSERT INTO E ( int_nokey, int_key ) VALUES (98, 98);
+INSERT INTO E ( int_nokey, int_key ) VALUES (883, 883);
+INSERT INTO E ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO E ( int_nokey, int_key ) VALUES (867, 867);
+INSERT INTO E ( int_nokey, int_key ) VALUES (406, 406);
+INSERT INTO E ( int_nokey, int_key ) VALUES (413, 413);
+INSERT INTO E ( int_nokey, int_key ) VALUES (778, 778);
+INSERT INTO E ( int_nokey, int_key ) VALUES (703, 703);
+INSERT INTO E ( int_nokey, int_key ) VALUES (208, 208);
+INSERT INTO E ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO E ( int_nokey, int_key ) VALUES (501, 501);
+INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611);
+INSERT INTO E ( int_nokey, int_key ) VALUES (946, 946);
+INSERT INTO E ( int_nokey, int_key ) VALUES (811, 811);
+INSERT INTO E ( int_nokey, int_key ) VALUES (161, 161);
+INSERT INTO E ( int_nokey, int_key ) VALUES (286, 286);
+INSERT INTO E ( int_nokey, int_key ) VALUES (48, 48);
+INSERT INTO E ( int_nokey, int_key ) VALUES (268, 268);
+INSERT INTO E ( int_nokey, int_key ) VALUES (753, 753);
+INSERT INTO E ( int_nokey, int_key ) VALUES (315, 315);
+INSERT INTO E ( int_nokey, int_key ) VALUES (500, 500);
+INSERT INTO E ( int_nokey, int_key ) VALUES (407, 407);
+INSERT INTO E ( int_nokey, int_key ) VALUES (112, 112);
+INSERT INTO E ( int_nokey, int_key ) VALUES (231, 231);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (505, 505);
+INSERT INTO E ( int_nokey, int_key ) VALUES (903, 903);
+INSERT INTO E ( int_nokey, int_key ) VALUES (874, 874);
+INSERT INTO E ( int_nokey, int_key ) VALUES (719, 719);
+INSERT INTO E ( int_nokey, int_key ) VALUES (61, 61);
+INSERT INTO E ( int_nokey, int_key ) VALUES (861, 861);
+INSERT INTO E ( int_nokey, int_key ) VALUES (400, 400);
+INSERT INTO E ( int_nokey, int_key ) VALUES (655, 655);
+INSERT INTO E ( int_nokey, int_key ) VALUES (382, 382);
+INSERT INTO E ( int_nokey, int_key ) VALUES (563, 563);
+INSERT INTO E ( int_nokey, int_key ) VALUES (348, 348);
+INSERT INTO E ( int_nokey, int_key ) VALUES (437, 437);
+INSERT INTO E ( int_nokey, int_key ) VALUES (50, 50);
+INSERT INTO E ( int_nokey, int_key ) VALUES (36, 36);
+INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625);
+INSERT INTO E ( int_nokey, int_key ) VALUES (632, 632);
+INSERT INTO E ( int_nokey, int_key ) VALUES (743, 743);
+INSERT INTO E ( int_nokey, int_key ) VALUES (251, 251);
+INSERT INTO E ( int_nokey, int_key ) VALUES (746, 746);
+INSERT INTO E ( int_nokey, int_key ) VALUES (74, 74);
+INSERT INTO E ( int_nokey, int_key ) VALUES (777, 777);
+INSERT INTO E ( int_nokey, int_key ) VALUES (704, 704);
+INSERT INTO E ( int_nokey, int_key ) VALUES (250, 250);
+INSERT INTO E ( int_nokey, int_key ) VALUES (960, 960);
+INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO E ( int_nokey, int_key ) VALUES (993, 993);
+INSERT INTO E ( int_nokey, int_key ) VALUES (57, 57);
+INSERT INTO E ( int_nokey, int_key ) VALUES (333, 333);
+INSERT INTO E ( int_nokey, int_key ) VALUES (656, 656);
+INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130);
+INSERT INTO E ( int_nokey, int_key ) VALUES (919, 919);
+INSERT INTO E ( int_nokey, int_key ) VALUES (45, 45);
+INSERT INTO E ( int_nokey, int_key ) VALUES (65, 65);
+INSERT INTO E ( int_nokey, int_key ) VALUES (703, 703);
+INSERT INTO E ( int_nokey, int_key ) VALUES (949, 949);
+INSERT INTO E ( int_nokey, int_key ) VALUES (570, 570);
+INSERT INTO E ( int_nokey, int_key ) VALUES (273, 273);
+INSERT INTO E ( int_nokey, int_key ) VALUES (118, 118);
+INSERT INTO E ( int_nokey, int_key ) VALUES (728, 728);
+INSERT INTO E ( int_nokey, int_key ) VALUES (506, 506);
+INSERT INTO E ( int_nokey, int_key ) VALUES (271, 271);
+INSERT INTO E ( int_nokey, int_key ) VALUES (987, 987);
+INSERT INTO E ( int_nokey, int_key ) VALUES (483, 483);
+INSERT INTO E ( int_nokey, int_key ) VALUES (577, 577);
+INSERT INTO E ( int_nokey, int_key ) VALUES (572, 572);
+INSERT INTO E ( int_nokey, int_key ) VALUES (965, 965);
+INSERT INTO E ( int_nokey, int_key ) VALUES (495, 495);
+INSERT INTO E ( int_nokey, int_key ) VALUES (54, 54);
+INSERT INTO E ( int_nokey, int_key ) VALUES (438, 438);
+INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457);
+INSERT INTO E ( int_nokey, int_key ) VALUES (798, 798);
+INSERT INTO E ( int_nokey, int_key ) VALUES (431, 431);
+INSERT INTO E ( int_nokey, int_key ) VALUES (300, 300);
+INSERT INTO E ( int_nokey, int_key ) VALUES (982, 982);
+INSERT INTO E ( int_nokey, int_key ) VALUES (712, 712);
+INSERT INTO E ( int_nokey, int_key ) VALUES (776, 776);
+INSERT INTO E ( int_nokey, int_key ) VALUES (934, 934);
+INSERT INTO E ( int_nokey, int_key ) VALUES (335, 335);
+INSERT INTO E ( int_nokey, int_key ) VALUES (958, 958);
+INSERT INTO E ( int_nokey, int_key ) VALUES (483, 483);
+INSERT INTO E ( int_nokey, int_key ) VALUES (462, 462);
+INSERT INTO E ( int_nokey, int_key ) VALUES (268, 268);
+INSERT INTO E ( int_nokey, int_key ) VALUES (654, 654);
+INSERT INTO E ( int_nokey, int_key ) VALUES (145, 145);
+INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184);
+INSERT INTO E ( int_nokey, int_key ) VALUES (135, 135);
+INSERT INTO E ( int_nokey, int_key ) VALUES (46, 46);
+INSERT INTO E ( int_nokey, int_key ) VALUES (532, 532);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (923, 923);
+INSERT INTO E ( int_nokey, int_key ) VALUES (284, 284);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (107, 107);
+INSERT INTO E ( int_nokey, int_key ) VALUES (446, 446);
+INSERT INTO E ( int_nokey, int_key ) VALUES (191, 191);
+INSERT INTO E ( int_nokey, int_key ) VALUES (705, 705);
+INSERT INTO E ( int_nokey, int_key ) VALUES (666, 666);
+INSERT INTO E ( int_nokey, int_key ) VALUES (156, 156);
+INSERT INTO E ( int_nokey, int_key ) VALUES (791, 791);
+INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO E ( int_nokey, int_key ) VALUES (499, 499);
+INSERT INTO E ( int_nokey, int_key ) VALUES (407, 407);
+INSERT INTO E ( int_nokey, int_key ) VALUES (359, 359);
+INSERT INTO E ( int_nokey, int_key ) VALUES (608, 608);
+INSERT INTO E ( int_nokey, int_key ) VALUES (661, 661);
+INSERT INTO E ( int_nokey, int_key ) VALUES (821, 821);
+INSERT INTO E ( int_nokey, int_key ) VALUES (80, 80);
+INSERT INTO E ( int_nokey, int_key ) VALUES (733, 733);
+INSERT INTO E ( int_nokey, int_key ) VALUES (823, 823);
+INSERT INTO E ( int_nokey, int_key ) VALUES (300, 300);
+INSERT INTO E ( int_nokey, int_key ) VALUES (693, 693);
+INSERT INTO E ( int_nokey, int_key ) VALUES (863, 863);
+INSERT INTO E ( int_nokey, int_key ) VALUES (734, 734);
+INSERT INTO E ( int_nokey, int_key ) VALUES (768, 768);
+INSERT INTO E ( int_nokey, int_key ) VALUES (52, 52);
+INSERT INTO E ( int_nokey, int_key ) VALUES (793, 793);
+INSERT INTO E ( int_nokey, int_key ) VALUES (756, 756);
+INSERT INTO E ( int_nokey, int_key ) VALUES (770, 770);
+INSERT INTO E ( int_nokey, int_key ) VALUES (644, 644);
+INSERT INTO E ( int_nokey, int_key ) VALUES (220, 220);
+INSERT INTO E ( int_nokey, int_key ) VALUES (109, 109);
+INSERT INTO E ( int_nokey, int_key ) VALUES (976, 976);
+INSERT INTO E ( int_nokey, int_key ) VALUES (291, 291);
+INSERT INTO E ( int_nokey, int_key ) VALUES (729, 729);
+INSERT INTO E ( int_nokey, int_key ) VALUES (151, 151);
+INSERT INTO E ( int_nokey, int_key ) VALUES (604, 604);
+INSERT INTO E ( int_nokey, int_key ) VALUES (367, 367);
+INSERT INTO E ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO E ( int_nokey, int_key ) VALUES (515, 515);
+INSERT INTO E ( int_nokey, int_key ) VALUES (912, 912);
+INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625);
+INSERT INTO E ( int_nokey, int_key ) VALUES (402, 402);
+INSERT INTO E ( int_nokey, int_key ) VALUES (768, 768);
+INSERT INTO E ( int_nokey, int_key ) VALUES (654, 654);
+INSERT INTO E ( int_nokey, int_key ) VALUES (675, 675);
+INSERT INTO E ( int_nokey, int_key ) VALUES (326, 326);
+INSERT INTO E ( int_nokey, int_key ) VALUES (888, 888);
+INSERT INTO E ( int_nokey, int_key ) VALUES (683, 683);
+INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94);
+INSERT INTO E ( int_nokey, int_key ) VALUES (175, 175);
+INSERT INTO E ( int_nokey, int_key ) VALUES (265, 265);
+INSERT INTO E ( int_nokey, int_key ) VALUES (443, 443);
+INSERT INTO E ( int_nokey, int_key ) VALUES (345, 345);
+INSERT INTO E ( int_nokey, int_key ) VALUES (306, 306);
+INSERT INTO E ( int_nokey, int_key ) VALUES (399, 399);
+INSERT INTO E ( int_nokey, int_key ) VALUES (557, 557);
+INSERT INTO E ( int_nokey, int_key ) VALUES (59, 59);
+INSERT INTO E ( int_nokey, int_key ) VALUES (484, 484);
+INSERT INTO E ( int_nokey, int_key ) VALUES (429, 429);
+INSERT INTO E ( int_nokey, int_key ) VALUES (249, 249);
+INSERT INTO E ( int_nokey, int_key ) VALUES (728, 728);
+INSERT INTO E ( int_nokey, int_key ) VALUES (501, 501);
+INSERT INTO E ( int_nokey, int_key ) VALUES (307, 307);
+INSERT INTO E ( int_nokey, int_key ) VALUES (173, 173);
+INSERT INTO E ( int_nokey, int_key ) VALUES (520, 520);
+INSERT INTO E ( int_nokey, int_key ) VALUES (229, 229);
+INSERT INTO E ( int_nokey, int_key ) VALUES (583, 583);
+INSERT INTO E ( int_nokey, int_key ) VALUES (950, 950);
+INSERT INTO E ( int_nokey, int_key ) VALUES (412, 412);
+INSERT INTO E ( int_nokey, int_key ) VALUES (810, 810);
+INSERT INTO E ( int_nokey, int_key ) VALUES (586, 586);
+INSERT INTO E ( int_nokey, int_key ) VALUES (276, 276);
+INSERT INTO E ( int_nokey, int_key ) VALUES (256, 256);
+INSERT INTO E ( int_nokey, int_key ) VALUES (722, 722);
+INSERT INTO E ( int_nokey, int_key ) VALUES (419, 419);
+INSERT INTO E ( int_nokey, int_key ) VALUES (727, 727);
+INSERT INTO E ( int_nokey, int_key ) VALUES (180, 180);
+INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130);
+INSERT INTO E ( int_nokey, int_key ) VALUES (738, 738);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (38, 38);
+INSERT INTO E ( int_nokey, int_key ) VALUES (346, 346);
+INSERT INTO E ( int_nokey, int_key ) VALUES (263, 263);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (584, 584);
+INSERT INTO E ( int_nokey, int_key ) VALUES (972, 972);
+INSERT INTO E ( int_nokey, int_key ) VALUES (485, 485);
+INSERT INTO E ( int_nokey, int_key ) VALUES (989, 989);
+INSERT INTO E ( int_nokey, int_key ) VALUES (22, 22);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (891, 891);
+INSERT INTO E ( int_nokey, int_key ) VALUES (756, 756);
+INSERT INTO E ( int_nokey, int_key ) VALUES (284, 284);
+INSERT INTO E ( int_nokey, int_key ) VALUES (146, 146);
+INSERT INTO E ( int_nokey, int_key ) VALUES (270, 270);
+INSERT INTO E ( int_nokey, int_key ) VALUES (379, 379);
+INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371);
+INSERT INTO E ( int_nokey, int_key ) VALUES (997, 997);
+INSERT INTO E ( int_nokey, int_key ) VALUES (624, 624);
+INSERT INTO E ( int_nokey, int_key ) VALUES (559, 559);
+INSERT INTO E ( int_nokey, int_key ) VALUES (690, 690);
+INSERT INTO E ( int_nokey, int_key ) VALUES (369, 369);
+INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625);
+INSERT INTO E ( int_nokey, int_key ) VALUES (604, 604);
+INSERT INTO E ( int_nokey, int_key ) VALUES (340, 340);
+INSERT INTO E ( int_nokey, int_key ) VALUES (253, 253);
+INSERT INTO E ( int_nokey, int_key ) VALUES (316, 316);
+INSERT INTO E ( int_nokey, int_key ) VALUES (481, 481);
+INSERT INTO E ( int_nokey, int_key ) VALUES (572, 572);
+INSERT INTO E ( int_nokey, int_key ) VALUES (117, 117);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94);
+INSERT INTO E ( int_nokey, int_key ) VALUES (311, 311);
+INSERT INTO E ( int_nokey, int_key ) VALUES (788, 788);
+INSERT INTO E ( int_nokey, int_key ) VALUES (281, 281);
+INSERT INTO E ( int_nokey, int_key ) VALUES (118, 118);
+INSERT INTO E ( int_nokey, int_key ) VALUES (26, 26);
+INSERT INTO E ( int_nokey, int_key ) VALUES (918, 918);
+INSERT INTO E ( int_nokey, int_key ) VALUES (660, 660);
+INSERT INTO E ( int_nokey, int_key ) VALUES (394, 394);
+INSERT INTO E ( int_nokey, int_key ) VALUES (739, 739);
+INSERT INTO E ( int_nokey, int_key ) VALUES (342, 342);
+INSERT INTO E ( int_nokey, int_key ) VALUES (921, 921);
+INSERT INTO E ( int_nokey, int_key ) VALUES (365, 365);
+INSERT INTO E ( int_nokey, int_key ) VALUES (594, 594);
+INSERT INTO E ( int_nokey, int_key ) VALUES (764, 764);
+INSERT INTO E ( int_nokey, int_key ) VALUES (788, 788);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (563, 563);
+INSERT INTO E ( int_nokey, int_key ) VALUES (131, 131);
+INSERT INTO E ( int_nokey, int_key ) VALUES (44, 44);
+INSERT INTO E ( int_nokey, int_key ) VALUES (868, 868);
+INSERT INTO E ( int_nokey, int_key ) VALUES (415, 415);
+INSERT INTO E ( int_nokey, int_key ) VALUES (335, 335);
+INSERT INTO E ( int_nokey, int_key ) VALUES (367, 367);
+INSERT INTO E ( int_nokey, int_key ) VALUES (221, 221);
+INSERT INTO E ( int_nokey, int_key ) VALUES (418, 418);
+INSERT INTO E ( int_nokey, int_key ) VALUES (108, 108);
+INSERT INTO E ( int_nokey, int_key ) VALUES (384, 384);
+INSERT INTO E ( int_nokey, int_key ) VALUES (569, 569);
+INSERT INTO E ( int_nokey, int_key ) VALUES (951, 951);
+INSERT INTO E ( int_nokey, int_key ) VALUES (206, 206);
+INSERT INTO E ( int_nokey, int_key ) VALUES (203, 203);
+INSERT INTO E ( int_nokey, int_key ) VALUES (68, 68);
+INSERT INTO E ( int_nokey, int_key ) VALUES (869, 869);
+INSERT INTO E ( int_nokey, int_key ) VALUES (827, 827);
+INSERT INTO E ( int_nokey, int_key ) VALUES (893, 893);
+INSERT INTO E ( int_nokey, int_key ) VALUES (271, 271);
+INSERT INTO E ( int_nokey, int_key ) VALUES (268, 268);
+INSERT INTO E ( int_nokey, int_key ) VALUES (319, 319);
+INSERT INTO E ( int_nokey, int_key ) VALUES (725, 725);
+INSERT INTO E ( int_nokey, int_key ) VALUES (948, 948);
+INSERT INTO E ( int_nokey, int_key ) VALUES (10, 10);
+INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204);
+INSERT INTO E ( int_nokey, int_key ) VALUES (714, 714);
+INSERT INTO E ( int_nokey, int_key ) VALUES (764, 764);
+INSERT INTO E ( int_nokey, int_key ) VALUES (828, 828);
+INSERT INTO E ( int_nokey, int_key ) VALUES (524, 524);
+INSERT INTO E ( int_nokey, int_key ) VALUES (324, 324);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (950, 950);
+INSERT INTO E ( int_nokey, int_key ) VALUES (201, 201);
+INSERT INTO E ( int_nokey, int_key ) VALUES (568, 568);
+INSERT INTO E ( int_nokey, int_key ) VALUES (946, 946);
+INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457);
+INSERT INTO E ( int_nokey, int_key ) VALUES (185, 185);
+INSERT INTO E ( int_nokey, int_key ) VALUES (445, 445);
+INSERT INTO E ( int_nokey, int_key ) VALUES (634, 634);
+INSERT INTO E ( int_nokey, int_key ) VALUES (141, 141);
+INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204);
+INSERT INTO E ( int_nokey, int_key ) VALUES (505, 505);
+INSERT INTO E ( int_nokey, int_key ) VALUES (546, 546);
+INSERT INTO E ( int_nokey, int_key ) VALUES (491, 491);
+INSERT INTO E ( int_nokey, int_key ) VALUES (432, 432);
+INSERT INTO E ( int_nokey, int_key ) VALUES (471, 471);
+INSERT INTO E ( int_nokey, int_key ) VALUES (341, 341);
+INSERT INTO E ( int_nokey, int_key ) VALUES (24, 24);
+INSERT INTO E ( int_nokey, int_key ) VALUES (666, 666);
+INSERT INTO E ( int_nokey, int_key ) VALUES (574, 574);
+INSERT INTO E ( int_nokey, int_key ) VALUES (515, 515);
+INSERT INTO E ( int_nokey, int_key ) VALUES (100, 100);
+INSERT INTO E ( int_nokey, int_key ) VALUES (857, 857);
+INSERT INTO E ( int_nokey, int_key ) VALUES (571, 571);
+INSERT INTO E ( int_nokey, int_key ) VALUES (366, 366);
+INSERT INTO E ( int_nokey, int_key ) VALUES (166, 166);
+INSERT INTO E ( int_nokey, int_key ) VALUES (411, 411);
+INSERT INTO E ( int_nokey, int_key ) VALUES (969, 969);
+INSERT INTO E ( int_nokey, int_key ) VALUES (862, 862);
+INSERT INTO E ( int_nokey, int_key ) VALUES (438, 438);
+INSERT INTO E ( int_nokey, int_key ) VALUES (153, 153);
+INSERT INTO E ( int_nokey, int_key ) VALUES (839, 839);
+INSERT INTO E ( int_nokey, int_key ) VALUES (690, 690);
+INSERT INTO E ( int_nokey, int_key ) VALUES (931, 931);
+INSERT INTO E ( int_nokey, int_key ) VALUES (834, 834);
+INSERT INTO E ( int_nokey, int_key ) VALUES (674, 674);
+INSERT INTO E ( int_nokey, int_key ) VALUES (773, 773);
+INSERT INTO E ( int_nokey, int_key ) VALUES (581, 581);
+INSERT INTO E ( int_nokey, int_key ) VALUES (438, 438);
+INSERT INTO E ( int_nokey, int_key ) VALUES (6, 6);
+INSERT INTO E ( int_nokey, int_key ) VALUES (818, 818);
+INSERT INTO E ( int_nokey, int_key ) VALUES (737, 737);
+INSERT INTO E ( int_nokey, int_key ) VALUES (127, 127);
+INSERT INTO E ( int_nokey, int_key ) VALUES (436, 436);
+INSERT INTO E ( int_nokey, int_key ) VALUES (101, 101);
+INSERT INTO E ( int_nokey, int_key ) VALUES (181, 181);
+INSERT INTO E ( int_nokey, int_key ) VALUES (783, 783);
+INSERT INTO E ( int_nokey, int_key ) VALUES (959, 959);
+INSERT INTO E ( int_nokey, int_key ) VALUES (170, 170);
+INSERT INTO E ( int_nokey, int_key ) VALUES (111, 111);
+INSERT INTO E ( int_nokey, int_key ) VALUES (574, 574);
+INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130);
+INSERT INTO E ( int_nokey, int_key ) VALUES (935, 935);
+INSERT INTO E ( int_nokey, int_key ) VALUES (388, 388);
+INSERT INTO E ( int_nokey, int_key ) VALUES (771, 771);
+INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO E ( int_nokey, int_key ) VALUES (898, 898);
+INSERT INTO E ( int_nokey, int_key ) VALUES (91, 91);
+INSERT INTO E ( int_nokey, int_key ) VALUES (896, 896);
+INSERT INTO E ( int_nokey, int_key ) VALUES (252, 252);
+INSERT INTO E ( int_nokey, int_key ) VALUES (773, 773);
+INSERT INTO E ( int_nokey, int_key ) VALUES (855, 855);
+INSERT INTO E ( int_nokey, int_key ) VALUES (735, 735);
+INSERT INTO E ( int_nokey, int_key ) VALUES (215, 215);
+INSERT INTO E ( int_nokey, int_key ) VALUES (544, 544);
+INSERT INTO E ( int_nokey, int_key ) VALUES (991, 991);
+INSERT INTO E ( int_nokey, int_key ) VALUES (626, 626);
+INSERT INTO E ( int_nokey, int_key ) VALUES (290, 290);
+INSERT INTO E ( int_nokey, int_key ) VALUES (24, 24);
+INSERT INTO E ( int_nokey, int_key ) VALUES (605, 605);
+INSERT INTO E ( int_nokey, int_key ) VALUES (718, 718);
+INSERT INTO E ( int_nokey, int_key ) VALUES (542, 542);
+INSERT INTO E ( int_nokey, int_key ) VALUES (61, 61);
+INSERT INTO E ( int_nokey, int_key ) VALUES (209, 209);
+INSERT INTO E ( int_nokey, int_key ) VALUES (467, 467);
+INSERT INTO E ( int_nokey, int_key ) VALUES (234, 234);
+INSERT INTO E ( int_nokey, int_key ) VALUES (919, 919);
+INSERT INTO E ( int_nokey, int_key ) VALUES (105, 105);
+INSERT INTO E ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO E ( int_nokey, int_key ) VALUES (432, 432);
+INSERT INTO E ( int_nokey, int_key ) VALUES (731, 731);
+INSERT INTO E ( int_nokey, int_key ) VALUES (514, 514);
+INSERT INTO E ( int_nokey, int_key ) VALUES (665, 665);
+INSERT INTO E ( int_nokey, int_key ) VALUES (280, 280);
+INSERT INTO E ( int_nokey, int_key ) VALUES (670, 670);
+INSERT INTO E ( int_nokey, int_key ) VALUES (136, 136);
+INSERT INTO E ( int_nokey, int_key ) VALUES (59, 59);
+INSERT INTO E ( int_nokey, int_key ) VALUES (516, 516);
+INSERT INTO E ( int_nokey, int_key ) VALUES (154, 154);
+INSERT INTO E ( int_nokey, int_key ) VALUES (232, 232);
+INSERT INTO E ( int_nokey, int_key ) VALUES (478, 478);
+INSERT INTO E ( int_nokey, int_key ) VALUES (127, 127);
+INSERT INTO E ( int_nokey, int_key ) VALUES (679, 679);
+INSERT INTO E ( int_nokey, int_key ) VALUES (983, 983);
+INSERT INTO E ( int_nokey, int_key ) VALUES (781, 781);
+INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745);
+INSERT INTO E ( int_nokey, int_key ) VALUES (55, 55);
+INSERT INTO E ( int_nokey, int_key ) VALUES (849, 849);
+INSERT INTO E ( int_nokey, int_key ) VALUES (924, 924);
+INSERT INTO E ( int_nokey, int_key ) VALUES (882, 882);
+INSERT INTO E ( int_nokey, int_key ) VALUES (854, 854);
+INSERT INTO E ( int_nokey, int_key ) VALUES (992, 992);
+INSERT INTO E ( int_nokey, int_key ) VALUES (232, 232);
+INSERT INTO E ( int_nokey, int_key ) VALUES (416, 416);
+INSERT INTO E ( int_nokey, int_key ) VALUES (881, 881);
+INSERT INTO E ( int_nokey, int_key ) VALUES (784, 784);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (718, 718);
+INSERT INTO E ( int_nokey, int_key ) VALUES (668, 668);
+INSERT INTO E ( int_nokey, int_key ) VALUES (776, 776);
+INSERT INTO E ( int_nokey, int_key ) VALUES (337, 337);
+INSERT INTO E ( int_nokey, int_key ) VALUES (257, 257);
+INSERT INTO E ( int_nokey, int_key ) VALUES (261, 261);
+INSERT INTO E ( int_nokey, int_key ) VALUES (557, 557);
+INSERT INTO E ( int_nokey, int_key ) VALUES (786, 786);
+INSERT INTO E ( int_nokey, int_key ) VALUES (879, 879);
+INSERT INTO E ( int_nokey, int_key ) VALUES (392, 392);
+INSERT INTO E ( int_nokey, int_key ) VALUES (227, 227);
+INSERT INTO E ( int_nokey, int_key ) VALUES (347, 347);
+INSERT INTO E ( int_nokey, int_key ) VALUES (802, 802);
+INSERT INTO E ( int_nokey, int_key ) VALUES (236, 236);
+INSERT INTO E ( int_nokey, int_key ) VALUES (97, 97);
+INSERT INTO E ( int_nokey, int_key ) VALUES (343, 343);
+INSERT INTO E ( int_nokey, int_key ) VALUES (556, 556);
+INSERT INTO E ( int_nokey, int_key ) VALUES (72, 72);
+INSERT INTO E ( int_nokey, int_key ) VALUES (2, 2);
+INSERT INTO E ( int_nokey, int_key ) VALUES (87, 87);
+INSERT INTO E ( int_nokey, int_key ) VALUES (216, 216);
+INSERT INTO E ( int_nokey, int_key ) VALUES (769, 769);
+INSERT INTO E ( int_nokey, int_key ) VALUES (711, 711);
+INSERT INTO E ( int_nokey, int_key ) VALUES (937, 937);
+INSERT INTO E ( int_nokey, int_key ) VALUES (434, 434);
+INSERT INTO E ( int_nokey, int_key ) VALUES (186, 186);
+INSERT INTO E ( int_nokey, int_key ) VALUES (355, 355);
+INSERT INTO E ( int_nokey, int_key ) VALUES (153, 153);
+INSERT INTO E ( int_nokey, int_key ) VALUES (609, 609);
+INSERT INTO E ( int_nokey, int_key ) VALUES (507, 507);
+INSERT INTO E ( int_nokey, int_key ) VALUES (83, 83);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (435, 435);
+INSERT INTO E ( int_nokey, int_key ) VALUES (623, 623);
+INSERT INTO E ( int_nokey, int_key ) VALUES (19, 19);
+INSERT INTO E ( int_nokey, int_key ) VALUES (292, 292);
+INSERT INTO E ( int_nokey, int_key ) VALUES (702, 702);
+INSERT INTO E ( int_nokey, int_key ) VALUES (884, 884);
+INSERT INTO E ( int_nokey, int_key ) VALUES (761, 761);
+INSERT INTO E ( int_nokey, int_key ) VALUES (993, 993);
+INSERT INTO E ( int_nokey, int_key ) VALUES (287, 287);
+INSERT INTO E ( int_nokey, int_key ) VALUES (531, 531);
+INSERT INTO E ( int_nokey, int_key ) VALUES (329, 329);
+INSERT INTO E ( int_nokey, int_key ) VALUES (919, 919);
+INSERT INTO E ( int_nokey, int_key ) VALUES (351, 351);
+INSERT INTO E ( int_nokey, int_key ) VALUES (692, 692);
+INSERT INTO E ( int_nokey, int_key ) VALUES (739, 739);
+INSERT INTO E ( int_nokey, int_key ) VALUES (254, 254);
+INSERT INTO E ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO E ( int_nokey, int_key ) VALUES (873, 873);
+INSERT INTO E ( int_nokey, int_key ) VALUES (956, 956);
+INSERT INTO E ( int_nokey, int_key ) VALUES (888, 888);
+INSERT INTO E ( int_nokey, int_key ) VALUES (64, 64);
+INSERT INTO E ( int_nokey, int_key ) VALUES (945, 945);
+INSERT INTO E ( int_nokey, int_key ) VALUES (150, 150);
+INSERT INTO E ( int_nokey, int_key ) VALUES (705, 705);
+INSERT INTO E ( int_nokey, int_key ) VALUES (832, 832);
+INSERT INTO E ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO E ( int_nokey, int_key ) VALUES (405, 405);
+INSERT INTO E ( int_nokey, int_key ) VALUES (411, 411);
+INSERT INTO E ( int_nokey, int_key ) VALUES (160, 160);
+INSERT INTO E ( int_nokey, int_key ) VALUES (429, 429);
+INSERT INTO E ( int_nokey, int_key ) VALUES (546, 546);
+INSERT INTO E ( int_nokey, int_key ) VALUES (332, 332);
+INSERT INTO E ( int_nokey, int_key ) VALUES (656, 656);
+INSERT INTO E ( int_nokey, int_key ) VALUES (410, 410);
+INSERT INTO E ( int_nokey, int_key ) VALUES (913, 913);
+INSERT INTO E ( int_nokey, int_key ) VALUES (289, 289);
+INSERT INTO E ( int_nokey, int_key ) VALUES (584, 584);
+INSERT INTO E ( int_nokey, int_key ) VALUES (624, 624);
+INSERT INTO E ( int_nokey, int_key ) VALUES (959, 959);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378);
+INSERT INTO E ( int_nokey, int_key ) VALUES (758, 758);
+INSERT INTO E ( int_nokey, int_key ) VALUES (493, 493);
+INSERT INTO E ( int_nokey, int_key ) VALUES (401, 401);
+INSERT INTO E ( int_nokey, int_key ) VALUES (772, 772);
+INSERT INTO E ( int_nokey, int_key ) VALUES (787, 787);
+INSERT INTO E ( int_nokey, int_key ) VALUES (733, 733);
+INSERT INTO E ( int_nokey, int_key ) VALUES (981, 981);
+INSERT INTO E ( int_nokey, int_key ) VALUES (207, 207);
+INSERT INTO E ( int_nokey, int_key ) VALUES (937, 937);
+INSERT INTO E ( int_nokey, int_key ) VALUES (660, 660);
+INSERT INTO E ( int_nokey, int_key ) VALUES (779, 779);
+INSERT INTO E ( int_nokey, int_key ) VALUES (124, 124);
+INSERT INTO E ( int_nokey, int_key ) VALUES (857, 857);
+INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93);
+INSERT INTO E ( int_nokey, int_key ) VALUES (414, 414);
+INSERT INTO E ( int_nokey, int_key ) VALUES (129, 129);
+INSERT INTO E ( int_nokey, int_key ) VALUES (165, 165);
+INSERT INTO E ( int_nokey, int_key ) VALUES (807, 807);
+INSERT INTO E ( int_nokey, int_key ) VALUES (408, 408);
+INSERT INTO E ( int_nokey, int_key ) VALUES (823, 823);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (583, 583);
+INSERT INTO E ( int_nokey, int_key ) VALUES (687, 687);
+INSERT INTO E ( int_nokey, int_key ) VALUES (886, 886);
+INSERT INTO E ( int_nokey, int_key ) VALUES (382, 382);
+INSERT INTO E ( int_nokey, int_key ) VALUES (270, 270);
+INSERT INTO E ( int_nokey, int_key ) VALUES (339, 339);
+INSERT INTO E ( int_nokey, int_key ) VALUES (732, 732);
+INSERT INTO E ( int_nokey, int_key ) VALUES (121, 121);
+INSERT INTO E ( int_nokey, int_key ) VALUES (781, 781);
+INSERT INTO E ( int_nokey, int_key ) VALUES (11, 11);
+INSERT INTO E ( int_nokey, int_key ) VALUES (703, 703);
+INSERT INTO E ( int_nokey, int_key ) VALUES (227, 227);
+INSERT INTO E ( int_nokey, int_key ) VALUES (910, 910);
+INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611);
+INSERT INTO E ( int_nokey, int_key ) VALUES (77, 77);
+INSERT INTO E ( int_nokey, int_key ) VALUES (585, 585);
+INSERT INTO E ( int_nokey, int_key ) VALUES (137, 137);
+INSERT INTO E ( int_nokey, int_key ) VALUES (452, 452);
+INSERT INTO E ( int_nokey, int_key ) VALUES (719, 719);
+INSERT INTO E ( int_nokey, int_key ) VALUES (425, 425);
+INSERT INTO E ( int_nokey, int_key ) VALUES (398, 398);
+INSERT INTO E ( int_nokey, int_key ) VALUES (939, 939);
+INSERT INTO E ( int_nokey, int_key ) VALUES (448, 448);
+INSERT INTO E ( int_nokey, int_key ) VALUES (38, 38);
+INSERT INTO E ( int_nokey, int_key ) VALUES (416, 416);
+INSERT INTO E ( int_nokey, int_key ) VALUES (556, 556);
+INSERT INTO E ( int_nokey, int_key ) VALUES (220, 220);
+INSERT INTO E ( int_nokey, int_key ) VALUES (169, 169);
+INSERT INTO E ( int_nokey, int_key ) VALUES (476, 476);
+INSERT INTO E ( int_nokey, int_key ) VALUES (122, 122);
+INSERT INTO E ( int_nokey, int_key ) VALUES (430, 430);
+INSERT INTO E ( int_nokey, int_key ) VALUES (175, 175);
+INSERT INTO E ( int_nokey, int_key ) VALUES (973, 973);
+INSERT INTO E ( int_nokey, int_key ) VALUES (436, 436);
+INSERT INTO E ( int_nokey, int_key ) VALUES (394, 394);
+INSERT INTO E ( int_nokey, int_key ) VALUES (129, 129);
+INSERT INTO E ( int_nokey, int_key ) VALUES (177, 177);
+INSERT INTO E ( int_nokey, int_key ) VALUES (654, 654);
+INSERT INTO E ( int_nokey, int_key ) VALUES (798, 798);
+INSERT INTO E ( int_nokey, int_key ) VALUES (525, 525);
+INSERT INTO E ( int_nokey, int_key ) VALUES (992, 992);
+INSERT INTO E ( int_nokey, int_key ) VALUES (676, 676);
+INSERT INTO E ( int_nokey, int_key ) VALUES (286, 286);
+INSERT INTO E ( int_nokey, int_key ) VALUES (61, 61);
+INSERT INTO E ( int_nokey, int_key ) VALUES (357, 357);
+INSERT INTO E ( int_nokey, int_key ) VALUES (65, 65);
+INSERT INTO E ( int_nokey, int_key ) VALUES (830, 830);
+INSERT INTO E ( int_nokey, int_key ) VALUES (351, 351);
+INSERT INTO E ( int_nokey, int_key ) VALUES (941, 941);
+INSERT INTO E ( int_nokey, int_key ) VALUES (131, 131);
+INSERT INTO E ( int_nokey, int_key ) VALUES (54, 54);
+INSERT INTO E ( int_nokey, int_key ) VALUES (567, 567);
+INSERT INTO E ( int_nokey, int_key ) VALUES (918, 918);
+INSERT INTO E ( int_nokey, int_key ) VALUES (126, 126);
+INSERT INTO E ( int_nokey, int_key ) VALUES (716, 716);
+INSERT INTO E ( int_nokey, int_key ) VALUES (960, 960);
+INSERT INTO E ( int_nokey, int_key ) VALUES (665, 665);
+INSERT INTO E ( int_nokey, int_key ) VALUES (439, 439);
+INSERT INTO E ( int_nokey, int_key ) VALUES (396, 396);
+INSERT INTO E ( int_nokey, int_key ) VALUES (496, 496);
+INSERT INTO E ( int_nokey, int_key ) VALUES (789, 789);
+INSERT INTO E ( int_nokey, int_key ) VALUES (142, 142);
+INSERT INTO E ( int_nokey, int_key ) VALUES (452, 452);
+INSERT INTO E ( int_nokey, int_key ) VALUES (139, 139);
+INSERT INTO E ( int_nokey, int_key ) VALUES (992, 992);
+INSERT INTO E ( int_nokey, int_key ) VALUES (784, 784);
+INSERT INTO E ( int_nokey, int_key ) VALUES (267, 267);
+INSERT INTO E ( int_nokey, int_key ) VALUES (610, 610);
+INSERT INTO E ( int_nokey, int_key ) VALUES (83, 83);
+INSERT INTO E ( int_nokey, int_key ) VALUES (228, 228);
+INSERT INTO E ( int_nokey, int_key ) VALUES (884, 884);
+INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93);
+INSERT INTO E ( int_nokey, int_key ) VALUES (207, 207);
+INSERT INTO E ( int_nokey, int_key ) VALUES (278, 278);
+INSERT INTO E ( int_nokey, int_key ) VALUES (575, 575);
+INSERT INTO E ( int_nokey, int_key ) VALUES (599, 599);
+INSERT INTO E ( int_nokey, int_key ) VALUES (811, 811);
+INSERT INTO E ( int_nokey, int_key ) VALUES (646, 646);
+INSERT INTO E ( int_nokey, int_key ) VALUES (756, 756);
+INSERT INTO E ( int_nokey, int_key ) VALUES (772, 772);
+INSERT INTO E ( int_nokey, int_key ) VALUES (511, 511);
+INSERT INTO E ( int_nokey, int_key ) VALUES (115, 115);
+INSERT INTO E ( int_nokey, int_key ) VALUES (603, 603);
+INSERT INTO E ( int_nokey, int_key ) VALUES (294, 294);
+INSERT INTO E ( int_nokey, int_key ) VALUES (238, 238);
+INSERT INTO E ( int_nokey, int_key ) VALUES (966, 966);
+INSERT INTO E ( int_nokey, int_key ) VALUES (721, 721);
+INSERT INTO E ( int_nokey, int_key ) VALUES (665, 665);
+INSERT INTO E ( int_nokey, int_key ) VALUES (376, 376);
+INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543);
+INSERT INTO E ( int_nokey, int_key ) VALUES (305, 305);
+INSERT INTO E ( int_nokey, int_key ) VALUES (903, 903);
+INSERT INTO E ( int_nokey, int_key ) VALUES (232, 232);
+INSERT INTO E ( int_nokey, int_key ) VALUES (95, 95);
+INSERT INTO E ( int_nokey, int_key ) VALUES (282, 282);
+INSERT INTO E ( int_nokey, int_key ) VALUES (242, 242);
+INSERT INTO E ( int_nokey, int_key ) VALUES (785, 785);
+INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543);
+INSERT INTO E ( int_nokey, int_key ) VALUES (478, 478);
+INSERT INTO E ( int_nokey, int_key ) VALUES (413, 413);
+INSERT INTO E ( int_nokey, int_key ) VALUES (937, 937);
+INSERT INTO E ( int_nokey, int_key ) VALUES (955, 955);
+INSERT INTO E ( int_nokey, int_key ) VALUES (517, 517);
+INSERT INTO E ( int_nokey, int_key ) VALUES (972, 972);
+INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457);
+;
+ERROR 42000: Query was empty
+set autocommit=1;
+SET AUTOCOMMIT=0;
+UPDATE C AS X SET pk = 9 , filler = REPEAT ( ' X ' , ( SELECT 90 FROM ( SELECT COUNT( pk
) FROM C AS X WHERE X . int_nokey < 92 LIMIT 20 ) AS X WHERE X . int_nokey < 76
LIMIT 1 ) ) WHERE X . pk < 58 ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Duplicate entry '9' for key 'PRIMARY'
+INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT int_nokey FROM E AS X WHERE X .
int_nokey < 93 LIMIT 1 ) , 16 );
+START TRANSACTION;
+INSERT INTO D ( int_key , int_nokey ) VALUES ( 42 , ( SELECT AVG( int_key ) FROM E AS X
WHERE X . int_key < 56 GROUP BY int_key LIMIT 1 ) );
+INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT int_nokey FROM D AS X LEFT JOIN E
AS Y ON ( X . int_nokey = Y . pk ) WHERE X . pk < 40 LIMIT 1 ) , 61 );
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_key ) FROM A AS X LEFT
JOIN D AS Y ON ( X . int_key = Y . int_nokey ) WHERE X . pk < 33 GROUP BY int_nokey
LIMIT 1 ) , ( SELECT int_key FROM E AS X LEFT JOIN B AS Y ON ( X . pk = Y . int_key )
WHERE X . pk < 42 GROUP BY int_key LIMIT 1 ) );
+ERROR 23000: Column 'int_key' in field list is ambiguous
+UPDATE E AS X SET int_nokey = ( SELECT AVG( int_key ) FROM E AS X WHERE X . pk < 38
GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( pk ) FROM C AS X LEFT
JOIN A AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 46 GROUP BY pk LIMIT 1 )
) WHERE X . int_nokey < 49 ORDER BY RAND ( ) LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+INSERT INTO E ( int_key , int_nokey ) VALUES ( 19 , 73 );
+START TRANSACTION;
+INSERT INTO D ( int_key , int_nokey ) VALUES ( ( SELECT int_key FROM B AS X LEFT JOIN D
AS Y ON ( X . int_key = Y . int_nokey ) WHERE X . pk < 54 LIMIT 1 ) , ( SELECT COUNT(
int_key ) FROM B AS X LEFT JOIN D AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk
< 14 LIMIT 1 ) );
+ERROR 23000: Column 'int_key' in field list is ambiguous
+INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT 84 FROM C AS X LEFT JOIN D AS Y
ON ( X . pk = Y . pk ) WHERE X . pk < 52 GROUP BY int_nokey LIMIT 1 ) , 88 );
+ERROR 23000: Column 'int_nokey' in group statement is ambiguous
+INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT 55 FROM A AS X LEFT JOIN A AS Y
ON ( X . pk = Y . pk ) WHERE X . int_nokey < 10 GROUP BY int_nokey LIMIT 1 ) , (
SELECT 63 FROM ( SELECT AVG( pk ) FROM ( SELECT ( SELECT int_nokey FROM D AS X LEFT JOIN
C AS Y ON ( X . pk = Y . int_nokey ) WHERE X . int_nokey < 98 GROUP BY pk LIMIT 1 )
FROM B AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . pk < 74
LIMIT 20 ) AS X WHERE X . pk < 91 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk <
54 LIMIT 1 ) );
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+UPDATE A AS X SET int_nokey = 85 , filler = REPEAT ( ' X ' , 15 ) WHERE X . int_key <
17 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET int_key = 97 , filler = REPEAT ( ' X ' , ( SELECT 84 FROM B AS X WHERE
X . pk < 62 LIMIT 1 ) ) WHERE X . int_nokey < 38 ORDER BY RAND ( ) LIMIT 20;
+UPDATE B AS X SET pk = 72 , filler = REPEAT ( ' X ' , 69 ) WHERE X . int_key < 46
ORDER BY RAND ( ) LIMIT 20;
+UPDATE A AS X SET int_key = ( SELECT AVG( int_nokey ) FROM ( SELECT AVG( pk ) FROM E AS X
WHERE X . int_key < 87 LIMIT 20 ) AS X WHERE X . pk < 14 LIMIT 1 ) , filler = REPEAT
( ' X ' , ( SELECT int_key FROM A AS X WHERE X . int_nokey < 66 LIMIT 1 ) ) WHERE X .
int_nokey < 24 ORDER BY RAND ( ) LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+UPDATE C AS X SET int_nokey = ( SELECT AVG( int_nokey ) FROM B AS X WHERE X . pk < 83
GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM A
AS X WHERE X . pk < 58 LIMIT 1 ) ) WHERE X . int_nokey < 23 ORDER BY RAND ( ) LIMIT
20;
+UPDATE B AS X SET int_key = ( SELECT COUNT( pk ) FROM D AS X WHERE X . int_nokey < 79
GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( int_key ) FROM D
AS X LEFT JOIN A AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . pk < 7 GROUP BY
pk LIMIT 1 ) ) WHERE X . int_nokey < 82 ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Column 'int_key' in field list is ambiguous
+UPDATE B AS X SET int_nokey = 8 , filler = REPEAT ( ' X ' , 91 ) WHERE X . pk < 40
ORDER BY RAND ( ) LIMIT 20;
+UPDATE B AS X SET int_nokey = ( SELECT AVG( pk ) FROM E AS X LEFT JOIN B AS Y ON ( X .
int_nokey = Y . int_nokey ) WHERE X . int_key < 21 LIMIT 1 ) , filler = REPEAT ( ' X '
, ( SELECT AVG( pk ) FROM A AS X LEFT JOIN A AS Y ON ( X . int_key = Y . int_key ) WHERE X
. int_key < 89 LIMIT 1 ) ) WHERE X . int_nokey < 68 ORDER BY RAND ( ) LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+UPDATE A AS X SET pk = ( SELECT AVG( int_key ) FROM E AS X LEFT JOIN D AS Y ON ( X .
int_nokey = Y . pk ) WHERE X . pk < 34 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT
int_key FROM ( SELECT COUNT( int_key ) FROM C AS X LEFT JOIN B AS Y ON ( X . pk = Y . pk
) WHERE X . pk < 36 LIMIT 20 ) AS X WHERE X . int_key < 89 LIMIT 1 ) ) WHERE X .
int_key < 87 ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Column 'int_key' in field list is ambiguous
+UPDATE D AS X SET int_key = ( SELECT 24 FROM D AS X LEFT JOIN D AS Y ON ( X . int_key = Y
. pk ) WHERE X . int_key < 3 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT COUNT(
int_nokey ) FROM E AS X LEFT JOIN D AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk
< 61 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 22 ORDER BY RAND ( )
LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+INSERT INTO A ( int_key , int_nokey ) VALUES ( 74 , ( SELECT COUNT( int_nokey ) FROM D AS
X LEFT JOIN C AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 86 GROUP BY
int_nokey LIMIT 1 ) );
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+INSERT INTO A ( int_key , int_nokey ) VALUES ( 80 , ( SELECT ( SELECT AVG( pk ) FROM E AS
X LEFT JOIN D AS Y ON ( X . int_nokey = Y . pk ) WHERE X . int_key < 44 LIMIT 1 ) FROM
( SELECT COUNT( int_key ) FROM E AS X WHERE X . pk < 85 GROUP BY int_nokey LIMIT 20 )
AS X WHERE X . pk < 24 LIMIT 1 ) );
+ERROR 23000: Column 'pk' in field list is ambiguous
+UPDATE C AS X SET pk = 79 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_key ) FROM B AS X
WHERE X . int_nokey < 97 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . pk < 85 ORDER BY
RAND ( ) LIMIT 20;
+ERROR 23000: Duplicate entry '79' for key 'PRIMARY'
+INSERT INTO E ( int_key , int_nokey ) VALUES ( ( SELECT int_key FROM D AS X LEFT JOIN C
AS Y ON ( X . pk = Y . pk ) WHERE X . pk < 35 GROUP BY pk LIMIT 1 ) , ( SELECT AVG(
int_nokey ) FROM C AS X WHERE X . int_key < 27 LIMIT 1 ) );
+ERROR 23000: Column 'int_key' in field list is ambiguous
+UPDATE C AS X SET int_key = 49 , filler = REPEAT ( ' X ' , 8 ) WHERE X . pk < 29 ORDER
BY RAND ( ) LIMIT 20;
+UPDATE B AS X SET int_key = 46 , filler = REPEAT ( ' X ' , ( SELECT int_key FROM B AS X
WHERE X . int_key < 97 LIMIT 1 ) ) WHERE X . int_key < 90 ORDER BY RAND ( ) LIMIT
20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+INSERT INTO D ( int_key , int_nokey ) VALUES ( 98 , 25 );
+INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( pk ) FROM E AS X LEFT JOIN
C AS Y ON ( X . int_key = Y . int_key ) WHERE X . int_nokey < 1 LIMIT 1 ) , 35 );
+ERROR 23000: Column 'pk' in field list is ambiguous
+UPDATE A AS X SET int_nokey = ( SELECT AVG( pk ) FROM ( SELECT pk FROM C AS X LEFT JOIN D
AS Y ON ( X . pk = Y . int_key ) WHERE X . int_nokey < 23 GROUP BY int_key LIMIT 20 )
AS X WHERE X . int_nokey < 56 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG(
int_key ) FROM ( SELECT AVG( int_key ) FROM C AS X LEFT JOIN B AS Y ON ( X . int_key = Y
. int_key ) WHERE X . pk < 7 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey <
92 LIMIT 1 ) ) WHERE X . int_nokey < 22 ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Column 'int_key' in field list is ambiguous
+INSERT INTO B ( int_key , int_nokey ) VALUES ( 23 , ( SELECT AVG( int_nokey ) FROM E AS X
LEFT JOIN A AS Y ON ( X . pk = Y . int_key ) WHERE X . pk < 88 LIMIT 1 ) );
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+INSERT INTO E ( int_key , int_nokey ) VALUES ( 43 , 42 );
+ROLLBACK;
+UPDATE E AS X SET int_nokey = ( SELECT 98 FROM A AS X LEFT JOIN B AS Y ON ( X . pk = Y .
int_key ) WHERE X . pk < 60 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 52
) WHERE X . int_nokey < 57 ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Column 'int_key' in group statement is ambiguous
+INSERT INTO B ( int_key , int_nokey ) VALUES ( 97 , ( SELECT AVG( int_key ) FROM ( SELECT
COUNT( int_key ) FROM A AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_key ) WHERE X . pk
< 9 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 5 GROUP BY pk LIMIT 1 )
);
+ERROR 23000: Column 'int_key' in field list is ambiguous
+UPDATE C AS X SET int_nokey = 33 , filler = REPEAT ( ' X ' , ( SELECT ( SELECT AVG( pk )
FROM C AS X LEFT JOIN B AS Y ON ( X . int_nokey = Y . pk ) WHERE X . int_nokey < 82
GROUP BY pk LIMIT 1 ) FROM C AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X
. pk < 3 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 85 ORDER BY RAND ( )
LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_nokey ) FROM B AS X
LEFT JOIN A AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 60 LIMIT 1
) , ( SELECT 92 FROM C AS X LEFT JOIN C AS Y ON ( X . int_key = Y . int_nokey ) WHERE X .
int_key < 1 LIMIT 1 ) );
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+UPDATE A AS X SET pk = 84 , filler = REPEAT ( ' X ' , 59 ) WHERE X . int_key < 36
ORDER BY RAND ( ) LIMIT 20;
+UPDATE D AS X SET pk = 80 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM B AS
X WHERE X . int_key < 82 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_key < 70 ORDER
BY RAND ( ) LIMIT 20;
+ERROR 23000: Duplicate entry '80' for key 'PRIMARY'
+COMMIT;
+START TRANSACTION;
+UPDATE B AS X SET int_key = 0 , filler = REPEAT ( ' X ' , 69 ) WHERE X . int_nokey < 2
ORDER BY RAND ( ) LIMIT 20;
+UPDATE D AS X SET pk = ( SELECT COUNT( pk ) FROM D AS X LEFT JOIN A AS Y ON ( X .
int_nokey = Y . int_nokey ) WHERE X . pk < 71 GROUP BY pk LIMIT 1 ) , filler = REPEAT
( ' X ' , 50 ) WHERE X . int_nokey < 96 ORDER BY RAND ( ) LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+UPDATE A AS X SET pk = 38 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_nokey ) FROM (
SELECT COUNT( int_key ) FROM E AS X WHERE X . int_key < 98 LIMIT 20 ) AS X WHERE X .
int_nokey < 58 LIMIT 1 ) ) WHERE X . pk < 28 ORDER BY RAND ( ) LIMIT 20;
+UPDATE A AS X SET pk = 87 , filler = REPEAT ( ' X ' , 66 ) WHERE X . pk < 40 ORDER BY
RAND ( ) LIMIT 20;
+UPDATE C AS X SET int_key = ( SELECT pk FROM D AS X LEFT JOIN C AS Y ON ( X . int_key = Y
. pk ) WHERE X . int_nokey < 90 GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X '
, 90 ) WHERE X . int_nokey < 51 ORDER BY RAND ( ) LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+UPDATE E AS X SET int_key = 41 , filler = REPEAT ( ' X ' , 49 ) WHERE X . int_nokey <
38 ORDER BY RAND ( ) LIMIT 20;
+UPDATE D AS X SET pk = 84 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM A AS
X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 60 LIMIT
1 ) ) WHERE X . int_key < 94 ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+UPDATE A AS X SET int_key = ( SELECT int_nokey FROM A AS X LEFT JOIN D AS Y ON ( X . pk =
Y . pk ) WHERE X . int_nokey < 47 GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , (
SELECT AVG( int_key ) FROM A AS X WHERE X . pk < 85 GROUP BY int_key LIMIT 1 ) ) WHERE
X . int_nokey < 79 ORDER BY RAND ( ) LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+UPDATE D AS X SET pk = ( SELECT COUNT( int_key ) FROM B AS X LEFT JOIN C AS Y ON ( X . pk
= Y . int_key ) WHERE X . int_nokey < 64 LIMIT 1 ) , filler = REPEAT ( ' X ' , 0 )
WHERE X . pk < 74 ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Column 'int_key' in field list is ambiguous
+INSERT INTO E ( int_key , int_nokey ) VALUES ( ( SELECT AVG( int_nokey ) FROM B AS X
WHERE X . pk < 97 GROUP BY int_nokey LIMIT 1 ) , ( SELECT ( SELECT COUNT( int_key )
FROM D AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X . int_key < 83
GROUP BY pk LIMIT 1 ) FROM B AS X WHERE X . pk < 69 LIMIT 1 ) );
+ERROR 23000: Column 'int_key' in field list is ambiguous
+UPDATE E AS X SET int_key = 90 , filler = REPEAT ( ' X ' , ( SELECT ( SELECT int_nokey
FROM C AS X LEFT JOIN C AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 58
LIMIT 1 ) FROM A AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X . pk < 99
GROUP BY int_nokey LIMIT 1 ) ) WHERE X . pk < 54 ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+UPDATE E AS X SET pk = 70 , filler = REPEAT ( ' X ' , 88 ) WHERE X . int_key < 74
ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Duplicate entry '70' for key 'PRIMARY'
+INSERT INTO A ( int_key , int_nokey ) VALUES ( 2 , 96 );
+UPDATE A AS X SET int_nokey = 76 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_key )
FROM A AS X WHERE X . int_nokey < 56 GROUP BY int_nokey LIMIT 1 ) ) WHERE X .
int_nokey < 76 ORDER BY RAND ( ) LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+UPDATE E AS X SET int_key = 93 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_key ) FROM
A AS X WHERE X . int_nokey < 77 GROUP BY pk LIMIT 1 ) ) WHERE X . pk < 66 ORDER BY
RAND ( ) LIMIT 20;
+INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT int_key FROM ( SELECT pk FROM (
SELECT int_nokey FROM A AS X LEFT JOIN B AS Y ON ( X . int_nokey = Y . int_key ) WHERE X
. int_nokey < 63 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 88 GROUP BY
int_key LIMIT 20 ) AS X WHERE X . int_key < 77 LIMIT 1 ) , ( SELECT COUNT( int_key )
FROM A AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey
< 67 GROUP BY int_key LIMIT 1 ) );
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+UPDATE E AS X SET pk = ( SELECT COUNT( int_nokey ) FROM B AS X LEFT JOIN D AS Y ON ( X .
pk = Y . int_nokey ) WHERE X . int_key < 74 GROUP BY int_nokey LIMIT 1 ) , filler =
REPEAT ( ' X ' , ( SELECT ( SELECT pk FROM ( SELECT int_key FROM A AS X LEFT JOIN D AS Y
ON ( X . int_key = Y . pk ) WHERE X . pk < 62 GROUP BY pk LIMIT 20 ) AS X WHERE X .
int_nokey < 11 GROUP BY int_key LIMIT 1 ) FROM B AS X LEFT JOIN D AS Y ON ( X .
int_nokey = Y . pk ) WHERE X . int_key < 10 LIMIT 1 ) ) WHERE X . int_key < 92
ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Column 'int_key' in field list is ambiguous
+START TRANSACTION;
+ROLLBACK;
+UPDATE E AS X SET int_nokey = 90 , filler = REPEAT ( ' X ' , 71 ) WHERE X . int_nokey
< 83 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET pk = ( SELECT AVG( int_nokey ) FROM B AS X LEFT JOIN C AS Y ON ( X .
int_key = Y . int_nokey ) WHERE X . int_key < 74 LIMIT 1 ) , filler = REPEAT ( ' X ' ,
11 ) WHERE X . int_key < 23 ORDER BY RAND ( ) LIMIT 20;
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+UPDATE E AS X SET int_key = 94 , filler = REPEAT ( ' X ' , ( SELECT 62 FROM ( SELECT 21
FROM C AS X WHERE X . int_key < 83 LIMIT 20 ) AS X WHERE X . int_nokey < 40 GROUP
BY int_key LIMIT 1 ) ) WHERE X . pk < 48 ORDER BY RAND ( ) LIMIT 20;
+ROLLBACK;
+INSERT INTO A ( int_key , int_nokey ) VALUES ( 93 , 97 );
+UPDATE A AS X SET int_nokey = 53 , filler = REPEAT ( ' X ' , 67 ) WHERE X . int_nokey
< 4 ORDER BY RAND ( ) LIMIT 20;
+UPDATE C AS X SET int_nokey = 65 , filler = REPEAT ( ' X ' , 33 ) WHERE X . int_nokey
< 31 ORDER BY RAND ( ) LIMIT 20;
+INSERT INTO E ( int_key , int_nokey ) VALUES ( 17 , ( SELECT AVG( int_nokey ) FROM E AS X
LEFT JOIN E AS Y ON ( X . int_key = Y . int_key ) WHERE X . int_key < 90 GROUP BY
int_nokey LIMIT 1 ) );
+ERROR 23000: Column 'int_nokey' in field list is ambiguous
+ROLLBACK;
+UPDATE E AS X SET int_key = ( SELECT pk FROM D AS X WHERE X . int_key < 39 LIMIT 1 ) ,
filler = REPEAT ( ' X ' , 71 ) WHERE X . int_key < 48 ORDER BY RAND ( ) LIMIT 20;
+UPDATE C AS X SET int_key = ( SELECT int_key FROM ( SELECT COUNT( pk ) FROM A AS X WHERE
X . int_key < 42 GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 88 LIMIT 1 ) ,
filler = REPEAT ( ' X ' , ( SELECT COUNT( int_nokey ) FROM D AS X WHERE X . pk < 55
GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_key < 38 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET int_nokey = ( SELECT int_key FROM A AS X LEFT JOIN A AS Y ON ( X . pk =
Y . int_nokey ) WHERE X . pk < 25 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X '
, ( SELECT COUNT( pk ) FROM C AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_key )
WHERE X . int_nokey < 3 LIMIT 1 ) ) WHERE X . pk < 33 ORDER BY RAND ( ) LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+UPDATE B AS X SET int_nokey = ( SELECT AVG( int_nokey ) FROM B AS X LEFT JOIN C AS Y ON (
X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 99 LIMIT 1 ) , filler = REPEAT (
' X ' , 96 ) WHERE X . int_nokey < 5 ORDER BY RAND ( ) LIMIT 20;
+ERROR HY000: You can't specify target table 'X' for update in FROM clause
+UPDATE C AS X SET int_key = ( SELECT AVG( int_nokey ) FROM E AS X WHERE X . int_nokey
< 69 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 59 ) WHERE X . int_nokey
< 60 ORDER BY RAND ( ) LIMIT 20;
+DROP TABLE A;
+DROP TABLE B;
+DROP TABLE C;
+DROP TABLE D;
+DROP TABLE E;

=== added file 'mysql-test/suite/falcon/t/falcon_bug_37344_A.test'
--- a/mysql-test/suite/falcon/t/falcon_bug_37344_A.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/t/falcon_bug_37344_A.test	2008-07-08 15:10:55 +0000
@@ -0,0 +1,1240 @@
+--source include/have_falcon.inc
+
+#
+# Bug #37344: Crash when balancing AVL tree in navigational
+#             index access, during merge of main and deferred
+#             indexes.  This tests the fix for a simple case.
+#             
+#
+--echo *** Bug #37344 ***
+
+# ----------------------------------------------------- #
+# --- Initialisation                                --- #
+# ----------------------------------------------------- #
+let $engine = 'Falcon';
+eval SET @@storage_engine = $engine;
+
+--disable_warnings
+# DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+# ----------------------------------------------------- #
+# --- Test                                          --- #
+# ----------------------------------------------------- #
+--disable_abort_on_error
+set autocommit=1;
+DROP TABLE IF EXISTS A;
+CREATE TABLE A ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+DROP TABLE IF EXISTS B;
+CREATE TABLE B ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+INSERT INTO B ( int_nokey, int_key ) VALUES (0, 0);
+DROP TABLE IF EXISTS C;
+CREATE TABLE C ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+INSERT INTO C ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO C ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO C ( int_nokey, int_key ) VALUES (3, 3);
+INSERT INTO C ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO C ( int_nokey, int_key ) VALUES (4, 4);
+INSERT INTO C ( int_nokey, int_key ) VALUES (9, 9);
+INSERT INTO C ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO C ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO C ( int_nokey, int_key ) VALUES (0, 0);
+INSERT INTO C ( int_nokey, int_key ) VALUES (6, 6);
+DROP TABLE IF EXISTS D;
+CREATE TABLE D ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+INSERT INTO D ( int_nokey, int_key ) VALUES (37, 37);
+INSERT INTO D ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO D ( int_nokey, int_key ) VALUES (45, 45);
+INSERT INTO D ( int_nokey, int_key ) VALUES (78, 78);
+INSERT INTO D ( int_nokey, int_key ) VALUES (8, 8);
+INSERT INTO D ( int_nokey, int_key ) VALUES (52, 52);
+INSERT INTO D ( int_nokey, int_key ) VALUES (57, 57);
+INSERT INTO D ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO D ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67);
+INSERT INTO D ( int_nokey, int_key ) VALUES (18, 18);
+INSERT INTO D ( int_nokey, int_key ) VALUES (98, 98);
+INSERT INTO D ( int_nokey, int_key ) VALUES (85, 85);
+INSERT INTO D ( int_nokey, int_key ) VALUES (72, 72);
+INSERT INTO D ( int_nokey, int_key ) VALUES (79, 79);
+INSERT INTO D ( int_nokey, int_key ) VALUES (4, 4);
+INSERT INTO D ( int_nokey, int_key ) VALUES (21, 21);
+INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67);
+INSERT INTO D ( int_nokey, int_key ) VALUES (81, 81);
+INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43);
+INSERT INTO D ( int_nokey, int_key ) VALUES (74, 74);
+INSERT INTO D ( int_nokey, int_key ) VALUES (61, 61);
+INSERT INTO D ( int_nokey, int_key ) VALUES (56, 56);
+INSERT INTO D ( int_nokey, int_key ) VALUES (23, 23);
+INSERT INTO D ( int_nokey, int_key ) VALUES (81, 81);
+INSERT INTO D ( int_nokey, int_key ) VALUES (2, 2);
+INSERT INTO D ( int_nokey, int_key ) VALUES (58, 58);
+INSERT INTO D ( int_nokey, int_key ) VALUES (48, 48);
+INSERT INTO D ( int_nokey, int_key ) VALUES (73, 73);
+INSERT INTO D ( int_nokey, int_key ) VALUES (62, 62);
+INSERT INTO D ( int_nokey, int_key ) VALUES (10, 10);
+INSERT INTO D ( int_nokey, int_key ) VALUES (50, 50);
+INSERT INTO D ( int_nokey, int_key ) VALUES (11, 11);
+INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67);
+INSERT INTO D ( int_nokey, int_key ) VALUES (76, 76);
+INSERT INTO D ( int_nokey, int_key ) VALUES (42, 42);
+INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43);
+INSERT INTO D ( int_nokey, int_key ) VALUES (39, 39);
+INSERT INTO D ( int_nokey, int_key ) VALUES (55, 55);
+INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO D ( int_nokey, int_key ) VALUES (76, 76);
+INSERT INTO D ( int_nokey, int_key ) VALUES (40, 40);
+INSERT INTO D ( int_nokey, int_key ) VALUES (88, 88);
+INSERT INTO D ( int_nokey, int_key ) VALUES (51, 51);
+INSERT INTO D ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO D ( int_nokey, int_key ) VALUES (74, 74);
+INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO D ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43);
+INSERT INTO D ( int_nokey, int_key ) VALUES (48, 48);
+INSERT INTO D ( int_nokey, int_key ) VALUES (99, 99);
+INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO D ( int_nokey, int_key ) VALUES (62, 62);
+INSERT INTO D ( int_nokey, int_key ) VALUES (53, 53);
+INSERT INTO D ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO D ( int_nokey, int_key ) VALUES (55, 55);
+INSERT INTO D ( int_nokey, int_key ) VALUES (9, 9);
+INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67);
+INSERT INTO D ( int_nokey, int_key ) VALUES (98, 98);
+INSERT INTO D ( int_nokey, int_key ) VALUES (34, 34);
+INSERT INTO D ( int_nokey, int_key ) VALUES (51, 51);
+INSERT INTO D ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO D ( int_nokey, int_key ) VALUES (64, 64);
+INSERT INTO D ( int_nokey, int_key ) VALUES (36, 36);
+INSERT INTO D ( int_nokey, int_key ) VALUES (37, 37);
+INSERT INTO D ( int_nokey, int_key ) VALUES (66, 66);
+INSERT INTO D ( int_nokey, int_key ) VALUES (86, 86);
+INSERT INTO D ( int_nokey, int_key ) VALUES (11, 11);
+INSERT INTO D ( int_nokey, int_key ) VALUES (3, 3);
+INSERT INTO D ( int_nokey, int_key ) VALUES (12, 12);
+INSERT INTO D ( int_nokey, int_key ) VALUES (35, 35);
+INSERT INTO D ( int_nokey, int_key ) VALUES (79, 79);
+INSERT INTO D ( int_nokey, int_key ) VALUES (87, 87);
+INSERT INTO D ( int_nokey, int_key ) VALUES (41, 41);
+INSERT INTO D ( int_nokey, int_key ) VALUES (97, 97);
+INSERT INTO D ( int_nokey, int_key ) VALUES (81, 81);
+INSERT INTO D ( int_nokey, int_key ) VALUES (87, 87);
+INSERT INTO D ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO D ( int_nokey, int_key ) VALUES (29, 29);
+INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO D ( int_nokey, int_key ) VALUES (19, 19);
+INSERT INTO D ( int_nokey, int_key ) VALUES (28, 28);
+INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43);
+INSERT INTO D ( int_nokey, int_key ) VALUES (75, 75);
+INSERT INTO D ( int_nokey, int_key ) VALUES (77, 77);
+INSERT INTO D ( int_nokey, int_key ) VALUES (6, 6);
+INSERT INTO D ( int_nokey, int_key ) VALUES (56, 56);
+INSERT INTO D ( int_nokey, int_key ) VALUES (85, 85);
+INSERT INTO D ( int_nokey, int_key ) VALUES (65, 65);
+INSERT INTO D ( int_nokey, int_key ) VALUES (92, 92);
+INSERT INTO D ( int_nokey, int_key ) VALUES (73, 73);
+INSERT INTO D ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO D ( int_nokey, int_key ) VALUES (45, 45);
+INSERT INTO D ( int_nokey, int_key ) VALUES (98, 98);
+INSERT INTO D ( int_nokey, int_key ) VALUES (57, 57);
+INSERT INTO D ( int_nokey, int_key ) VALUES (48, 48);
+INSERT INTO D ( int_nokey, int_key ) VALUES (86, 86);
+INSERT INTO D ( int_nokey, int_key ) VALUES (15, 15);
+INSERT INTO D ( int_nokey, int_key ) VALUES (39, 39);
+INSERT INTO D ( int_nokey, int_key ) VALUES (85, 85);
+DROP TABLE IF EXISTS E;
+CREATE TABLE E ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler
blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon;
+INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO E ( int_nokey, int_key ) VALUES (595, 595);
+INSERT INTO E ( int_nokey, int_key ) VALUES (552, 552);
+INSERT INTO E ( int_nokey, int_key ) VALUES (46, 46);
+INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93);
+INSERT INTO E ( int_nokey, int_key ) VALUES (939, 939);
+INSERT INTO E ( int_nokey, int_key ) VALUES (507, 507);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (35, 35);
+INSERT INTO E ( int_nokey, int_key ) VALUES (727, 727);
+INSERT INTO E ( int_nokey, int_key ) VALUES (317, 317);
+INSERT INTO E ( int_nokey, int_key ) VALUES (225, 225);
+INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204);
+INSERT INTO E ( int_nokey, int_key ) VALUES (751, 751);
+INSERT INTO E ( int_nokey, int_key ) VALUES (955, 955);
+INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543);
+INSERT INTO E ( int_nokey, int_key ) VALUES (530, 530);
+INSERT INTO E ( int_nokey, int_key ) VALUES (395, 395);
+INSERT INTO E ( int_nokey, int_key ) VALUES (296, 296);
+INSERT INTO E ( int_nokey, int_key ) VALUES (831, 831);
+INSERT INTO E ( int_nokey, int_key ) VALUES (363, 363);
+INSERT INTO E ( int_nokey, int_key ) VALUES (144, 144);
+INSERT INTO E ( int_nokey, int_key ) VALUES (260, 260);
+INSERT INTO E ( int_nokey, int_key ) VALUES (117, 117);
+INSERT INTO E ( int_nokey, int_key ) VALUES (142, 142);
+INSERT INTO E ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO E ( int_nokey, int_key ) VALUES (560, 560);
+INSERT INTO E ( int_nokey, int_key ) VALUES (175, 175);
+INSERT INTO E ( int_nokey, int_key ) VALUES (675, 675);
+INSERT INTO E ( int_nokey, int_key ) VALUES (489, 489);
+INSERT INTO E ( int_nokey, int_key ) VALUES (564, 564);
+INSERT INTO E ( int_nokey, int_key ) VALUES (82, 82);
+INSERT INTO E ( int_nokey, int_key ) VALUES (75, 75);
+INSERT INTO E ( int_nokey, int_key ) VALUES (921, 921);
+INSERT INTO E ( int_nokey, int_key ) VALUES (495, 495);
+INSERT INTO E ( int_nokey, int_key ) VALUES (533, 533);
+INSERT INTO E ( int_nokey, int_key ) VALUES (673, 673);
+INSERT INTO E ( int_nokey, int_key ) VALUES (49, 49);
+INSERT INTO E ( int_nokey, int_key ) VALUES (168, 168);
+INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371);
+INSERT INTO E ( int_nokey, int_key ) VALUES (534, 534);
+INSERT INTO E ( int_nokey, int_key ) VALUES (437, 437);
+INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591);
+INSERT INTO E ( int_nokey, int_key ) VALUES (208, 208);
+INSERT INTO E ( int_nokey, int_key ) VALUES (622, 622);
+INSERT INTO E ( int_nokey, int_key ) VALUES (956, 956);
+INSERT INTO E ( int_nokey, int_key ) VALUES (652, 652);
+INSERT INTO E ( int_nokey, int_key ) VALUES (391, 391);
+INSERT INTO E ( int_nokey, int_key ) VALUES (875, 875);
+INSERT INTO E ( int_nokey, int_key ) VALUES (743, 743);
+INSERT INTO E ( int_nokey, int_key ) VALUES (347, 347);
+INSERT INTO E ( int_nokey, int_key ) VALUES (395, 395);
+INSERT INTO E ( int_nokey, int_key ) VALUES (956, 956);
+INSERT INTO E ( int_nokey, int_key ) VALUES (623, 623);
+INSERT INTO E ( int_nokey, int_key ) VALUES (525, 525);
+INSERT INTO E ( int_nokey, int_key ) VALUES (140, 140);
+INSERT INTO E ( int_nokey, int_key ) VALUES (119, 119);
+INSERT INTO E ( int_nokey, int_key ) VALUES (136, 136);
+INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94);
+INSERT INTO E ( int_nokey, int_key ) VALUES (857, 857);
+INSERT INTO E ( int_nokey, int_key ) VALUES (20, 20);
+INSERT INTO E ( int_nokey, int_key ) VALUES (77, 77);
+INSERT INTO E ( int_nokey, int_key ) VALUES (58, 58);
+INSERT INTO E ( int_nokey, int_key ) VALUES (243, 243);
+INSERT INTO E ( int_nokey, int_key ) VALUES (21, 21);
+INSERT INTO E ( int_nokey, int_key ) VALUES (879, 879);
+INSERT INTO E ( int_nokey, int_key ) VALUES (999, 999);
+INSERT INTO E ( int_nokey, int_key ) VALUES (678, 678);
+INSERT INTO E ( int_nokey, int_key ) VALUES (986, 986);
+INSERT INTO E ( int_nokey, int_key ) VALUES (521, 521);
+INSERT INTO E ( int_nokey, int_key ) VALUES (259, 259);
+INSERT INTO E ( int_nokey, int_key ) VALUES (711, 711);
+INSERT INTO E ( int_nokey, int_key ) VALUES (458, 458);
+INSERT INTO E ( int_nokey, int_key ) VALUES (235, 235);
+INSERT INTO E ( int_nokey, int_key ) VALUES (230, 230);
+INSERT INTO E ( int_nokey, int_key ) VALUES (145, 145);
+INSERT INTO E ( int_nokey, int_key ) VALUES (506, 506);
+INSERT INTO E ( int_nokey, int_key ) VALUES (734, 734);
+INSERT INTO E ( int_nokey, int_key ) VALUES (873, 873);
+INSERT INTO E ( int_nokey, int_key ) VALUES (920, 920);
+INSERT INTO E ( int_nokey, int_key ) VALUES (753, 753);
+INSERT INTO E ( int_nokey, int_key ) VALUES (941, 941);
+INSERT INTO E ( int_nokey, int_key ) VALUES (792, 792);
+INSERT INTO E ( int_nokey, int_key ) VALUES (587, 587);
+INSERT INTO E ( int_nokey, int_key ) VALUES (420, 420);
+INSERT INTO E ( int_nokey, int_key ) VALUES (799, 799);
+INSERT INTO E ( int_nokey, int_key ) VALUES (944, 944);
+INSERT INTO E ( int_nokey, int_key ) VALUES (597, 597);
+INSERT INTO E ( int_nokey, int_key ) VALUES (397, 397);
+INSERT INTO E ( int_nokey, int_key ) VALUES (939, 939);
+INSERT INTO E ( int_nokey, int_key ) VALUES (996, 996);
+INSERT INTO E ( int_nokey, int_key ) VALUES (328, 328);
+INSERT INTO E ( int_nokey, int_key ) VALUES (579, 579);
+INSERT INTO E ( int_nokey, int_key ) VALUES (64, 64);
+INSERT INTO E ( int_nokey, int_key ) VALUES (622, 622);
+INSERT INTO E ( int_nokey, int_key ) VALUES (982, 982);
+INSERT INTO E ( int_nokey, int_key ) VALUES (108, 108);
+INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378);
+INSERT INTO E ( int_nokey, int_key ) VALUES (995, 995);
+INSERT INTO E ( int_nokey, int_key ) VALUES (99, 99);
+INSERT INTO E ( int_nokey, int_key ) VALUES (842, 842);
+INSERT INTO E ( int_nokey, int_key ) VALUES (433, 433);
+INSERT INTO E ( int_nokey, int_key ) VALUES (663, 663);
+INSERT INTO E ( int_nokey, int_key ) VALUES (762, 762);
+INSERT INTO E ( int_nokey, int_key ) VALUES (921, 921);
+INSERT INTO E ( int_nokey, int_key ) VALUES (9, 9);
+INSERT INTO E ( int_nokey, int_key ) VALUES (895, 895);
+INSERT INTO E ( int_nokey, int_key ) VALUES (2, 2);
+INSERT INTO E ( int_nokey, int_key ) VALUES (653, 653);
+INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184);
+INSERT INTO E ( int_nokey, int_key ) VALUES (905, 905);
+INSERT INTO E ( int_nokey, int_key ) VALUES (809, 809);
+INSERT INTO E ( int_nokey, int_key ) VALUES (124, 124);
+INSERT INTO E ( int_nokey, int_key ) VALUES (446, 446);
+INSERT INTO E ( int_nokey, int_key ) VALUES (777, 777);
+INSERT INTO E ( int_nokey, int_key ) VALUES (501, 501);
+INSERT INTO E ( int_nokey, int_key ) VALUES (810, 810);
+INSERT INTO E ( int_nokey, int_key ) VALUES (381, 381);
+INSERT INTO E ( int_nokey, int_key ) VALUES (970, 970);
+INSERT INTO E ( int_nokey, int_key ) VALUES (224, 224);
+INSERT INTO E ( int_nokey, int_key ) VALUES (435, 435);
+INSERT INTO E ( int_nokey, int_key ) VALUES (401, 401);
+INSERT INTO E ( int_nokey, int_key ) VALUES (360, 360);
+INSERT INTO E ( int_nokey, int_key ) VALUES (757, 757);
+INSERT INTO E ( int_nokey, int_key ) VALUES (167, 167);
+INSERT INTO E ( int_nokey, int_key ) VALUES (609, 609);
+INSERT INTO E ( int_nokey, int_key ) VALUES (607, 607);
+INSERT INTO E ( int_nokey, int_key ) VALUES (728, 728);
+INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745);
+INSERT INTO E ( int_nokey, int_key ) VALUES (929, 929);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (31, 31);
+INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO E ( int_nokey, int_key ) VALUES (190, 190);
+INSERT INTO E ( int_nokey, int_key ) VALUES (339, 339);
+INSERT INTO E ( int_nokey, int_key ) VALUES (940, 940);
+INSERT INTO E ( int_nokey, int_key ) VALUES (141, 141);
+INSERT INTO E ( int_nokey, int_key ) VALUES (928, 928);
+INSERT INTO E ( int_nokey, int_key ) VALUES (642, 642);
+INSERT INTO E ( int_nokey, int_key ) VALUES (814, 814);
+INSERT INTO E ( int_nokey, int_key ) VALUES (182, 182);
+INSERT INTO E ( int_nokey, int_key ) VALUES (283, 283);
+INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591);
+INSERT INTO E ( int_nokey, int_key ) VALUES (696, 696);
+INSERT INTO E ( int_nokey, int_key ) VALUES (679, 679);
+INSERT INTO E ( int_nokey, int_key ) VALUES (612, 612);
+INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (469, 469);
+INSERT INTO E ( int_nokey, int_key ) VALUES (231, 231);
+INSERT INTO E ( int_nokey, int_key ) VALUES (9, 9);
+INSERT INTO E ( int_nokey, int_key ) VALUES (115, 115);
+INSERT INTO E ( int_nokey, int_key ) VALUES (552, 552);
+INSERT INTO E ( int_nokey, int_key ) VALUES (455, 455);
+INSERT INTO E ( int_nokey, int_key ) VALUES (463, 463);
+INSERT INTO E ( int_nokey, int_key ) VALUES (831, 831);
+INSERT INTO E ( int_nokey, int_key ) VALUES (338, 338);
+INSERT INTO E ( int_nokey, int_key ) VALUES (338, 338);
+INSERT INTO E ( int_nokey, int_key ) VALUES (513, 513);
+INSERT INTO E ( int_nokey, int_key ) VALUES (819, 819);
+INSERT INTO E ( int_nokey, int_key ) VALUES (900, 900);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (481, 481);
+INSERT INTO E ( int_nokey, int_key ) VALUES (369, 369);
+INSERT INTO E ( int_nokey, int_key ) VALUES (267, 267);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (493, 493);
+INSERT INTO E ( int_nokey, int_key ) VALUES (299, 299);
+INSERT INTO E ( int_nokey, int_key ) VALUES (460, 460);
+INSERT INTO E ( int_nokey, int_key ) VALUES (426, 426);
+INSERT INTO E ( int_nokey, int_key ) VALUES (54, 54);
+INSERT INTO E ( int_nokey, int_key ) VALUES (332, 332);
+INSERT INTO E ( int_nokey, int_key ) VALUES (260, 260);
+INSERT INTO E ( int_nokey, int_key ) VALUES (900, 900);
+INSERT INTO E ( int_nokey, int_key ) VALUES (656, 656);
+INSERT INTO E ( int_nokey, int_key ) VALUES (192, 192);
+INSERT INTO E ( int_nokey, int_key ) VALUES (708, 708);
+INSERT INTO E ( int_nokey, int_key ) VALUES (254, 254);
+INSERT INTO E ( int_nokey, int_key ) VALUES (82, 82);
+INSERT INTO E ( int_nokey, int_key ) VALUES (424, 424);
+INSERT INTO E ( int_nokey, int_key ) VALUES (246, 246);
+INSERT INTO E ( int_nokey, int_key ) VALUES (565, 565);
+INSERT INTO E ( int_nokey, int_key ) VALUES (274, 274);
+INSERT INTO E ( int_nokey, int_key ) VALUES (909, 909);
+INSERT INTO E ( int_nokey, int_key ) VALUES (883, 883);
+INSERT INTO E ( int_nokey, int_key ) VALUES (751, 751);
+INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378);
+INSERT INTO E ( int_nokey, int_key ) VALUES (436, 436);
+INSERT INTO E ( int_nokey, int_key ) VALUES (807, 807);
+INSERT INTO E ( int_nokey, int_key ) VALUES (571, 571);
+INSERT INTO E ( int_nokey, int_key ) VALUES (930, 930);
+INSERT INTO E ( int_nokey, int_key ) VALUES (824, 824);
+INSERT INTO E ( int_nokey, int_key ) VALUES (532, 532);
+INSERT INTO E ( int_nokey, int_key ) VALUES (368, 368);
+INSERT INTO E ( int_nokey, int_key ) VALUES (278, 278);
+INSERT INTO E ( int_nokey, int_key ) VALUES (549, 549);
+INSERT INTO E ( int_nokey, int_key ) VALUES (940, 940);
+INSERT INTO E ( int_nokey, int_key ) VALUES (11, 11);
+INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457);
+INSERT INTO E ( int_nokey, int_key ) VALUES (56, 56);
+INSERT INTO E ( int_nokey, int_key ) VALUES (825, 825);
+INSERT INTO E ( int_nokey, int_key ) VALUES (350, 350);
+INSERT INTO E ( int_nokey, int_key ) VALUES (637, 637);
+INSERT INTO E ( int_nokey, int_key ) VALUES (843, 843);
+INSERT INTO E ( int_nokey, int_key ) VALUES (747, 747);
+INSERT INTO E ( int_nokey, int_key ) VALUES (415, 415);
+INSERT INTO E ( int_nokey, int_key ) VALUES (425, 425);
+INSERT INTO E ( int_nokey, int_key ) VALUES (642, 642);
+INSERT INTO E ( int_nokey, int_key ) VALUES (889, 889);
+INSERT INTO E ( int_nokey, int_key ) VALUES (196, 196);
+INSERT INTO E ( int_nokey, int_key ) VALUES (40, 40);
+INSERT INTO E ( int_nokey, int_key ) VALUES (988, 988);
+INSERT INTO E ( int_nokey, int_key ) VALUES (22, 22);
+INSERT INTO E ( int_nokey, int_key ) VALUES (989, 989);
+INSERT INTO E ( int_nokey, int_key ) VALUES (393, 393);
+INSERT INTO E ( int_nokey, int_key ) VALUES (801, 801);
+INSERT INTO E ( int_nokey, int_key ) VALUES (865, 865);
+INSERT INTO E ( int_nokey, int_key ) VALUES (868, 868);
+INSERT INTO E ( int_nokey, int_key ) VALUES (397, 397);
+INSERT INTO E ( int_nokey, int_key ) VALUES (251, 251);
+INSERT INTO E ( int_nokey, int_key ) VALUES (750, 750);
+INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543);
+INSERT INTO E ( int_nokey, int_key ) VALUES (180, 180);
+INSERT INTO E ( int_nokey, int_key ) VALUES (846, 846);
+INSERT INTO E ( int_nokey, int_key ) VALUES (193, 193);
+INSERT INTO E ( int_nokey, int_key ) VALUES (808, 808);
+INSERT INTO E ( int_nokey, int_key ) VALUES (12, 12);
+INSERT INTO E ( int_nokey, int_key ) VALUES (818, 818);
+INSERT INTO E ( int_nokey, int_key ) VALUES (407, 407);
+INSERT INTO E ( int_nokey, int_key ) VALUES (459, 459);
+INSERT INTO E ( int_nokey, int_key ) VALUES (547, 547);
+INSERT INTO E ( int_nokey, int_key ) VALUES (220, 220);
+INSERT INTO E ( int_nokey, int_key ) VALUES (907, 907);
+INSERT INTO E ( int_nokey, int_key ) VALUES (372, 372);
+INSERT INTO E ( int_nokey, int_key ) VALUES (893, 893);
+INSERT INTO E ( int_nokey, int_key ) VALUES (660, 660);
+INSERT INTO E ( int_nokey, int_key ) VALUES (788, 788);
+INSERT INTO E ( int_nokey, int_key ) VALUES (667, 667);
+INSERT INTO E ( int_nokey, int_key ) VALUES (31, 31);
+INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94);
+INSERT INTO E ( int_nokey, int_key ) VALUES (326, 326);
+INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184);
+INSERT INTO E ( int_nokey, int_key ) VALUES (281, 281);
+INSERT INTO E ( int_nokey, int_key ) VALUES (58, 58);
+INSERT INTO E ( int_nokey, int_key ) VALUES (801, 801);
+INSERT INTO E ( int_nokey, int_key ) VALUES (970, 970);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (910, 910);
+INSERT INTO E ( int_nokey, int_key ) VALUES (619, 619);
+INSERT INTO E ( int_nokey, int_key ) VALUES (37, 37);
+INSERT INTO E ( int_nokey, int_key ) VALUES (380, 380);
+INSERT INTO E ( int_nokey, int_key ) VALUES (247, 247);
+INSERT INTO E ( int_nokey, int_key ) VALUES (320, 320);
+INSERT INTO E ( int_nokey, int_key ) VALUES (190, 190);
+INSERT INTO E ( int_nokey, int_key ) VALUES (716, 716);
+INSERT INTO E ( int_nokey, int_key ) VALUES (298, 298);
+INSERT INTO E ( int_nokey, int_key ) VALUES (146, 146);
+INSERT INTO E ( int_nokey, int_key ) VALUES (376, 376);
+INSERT INTO E ( int_nokey, int_key ) VALUES (808, 808);
+INSERT INTO E ( int_nokey, int_key ) VALUES (544, 544);
+INSERT INTO E ( int_nokey, int_key ) VALUES (675, 675);
+INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591);
+INSERT INTO E ( int_nokey, int_key ) VALUES (272, 272);
+INSERT INTO E ( int_nokey, int_key ) VALUES (811, 811);
+INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371);
+INSERT INTO E ( int_nokey, int_key ) VALUES (141, 141);
+INSERT INTO E ( int_nokey, int_key ) VALUES (570, 570);
+INSERT INTO E ( int_nokey, int_key ) VALUES (758, 758);
+INSERT INTO E ( int_nokey, int_key ) VALUES (871, 871);
+INSERT INTO E ( int_nokey, int_key ) VALUES (707, 707);
+INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611);
+INSERT INTO E ( int_nokey, int_key ) VALUES (5, 5);
+INSERT INTO E ( int_nokey, int_key ) VALUES (374, 374);
+INSERT INTO E ( int_nokey, int_key ) VALUES (697, 697);
+INSERT INTO E ( int_nokey, int_key ) VALUES (227, 227);
+INSERT INTO E ( int_nokey, int_key ) VALUES (636, 636);
+INSERT INTO E ( int_nokey, int_key ) VALUES (907, 907);
+INSERT INTO E ( int_nokey, int_key ) VALUES (249, 249);
+INSERT INTO E ( int_nokey, int_key ) VALUES (724, 724);
+INSERT INTO E ( int_nokey, int_key ) VALUES (480, 480);
+INSERT INTO E ( int_nokey, int_key ) VALUES (727, 727);
+INSERT INTO E ( int_nokey, int_key ) VALUES (862, 862);
+INSERT INTO E ( int_nokey, int_key ) VALUES (530, 530);
+INSERT INTO E ( int_nokey, int_key ) VALUES (601, 601);
+INSERT INTO E ( int_nokey, int_key ) VALUES (866, 866);
+INSERT INTO E ( int_nokey, int_key ) VALUES (0, 0);
+INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745);
+INSERT INTO E ( int_nokey, int_key ) VALUES (652, 652);
+INSERT INTO E ( int_nokey, int_key ) VALUES (509, 509);
+INSERT INTO E ( int_nokey, int_key ) VALUES (592, 592);
+INSERT INTO E ( int_nokey, int_key ) VALUES (969, 969);
+INSERT INTO E ( int_nokey, int_key ) VALUES (58, 58);
+INSERT INTO E ( int_nokey, int_key ) VALUES (592, 592);
+INSERT INTO E ( int_nokey, int_key ) VALUES (717, 717);
+INSERT INTO E ( int_nokey, int_key ) VALUES (415, 415);
+INSERT INTO E ( int_nokey, int_key ) VALUES (181, 181);
+INSERT INTO E ( int_nokey, int_key ) VALUES (783, 783);
+INSERT INTO E ( int_nokey, int_key ) VALUES (702, 702);
+INSERT INTO E ( int_nokey, int_key ) VALUES (587, 587);
+INSERT INTO E ( int_nokey, int_key ) VALUES (88, 88);
+INSERT INTO E ( int_nokey, int_key ) VALUES (836, 836);
+INSERT INTO E ( int_nokey, int_key ) VALUES (872, 872);
+INSERT INTO E ( int_nokey, int_key ) VALUES (996, 996);
+INSERT INTO E ( int_nokey, int_key ) VALUES (162, 162);
+INSERT INTO E ( int_nokey, int_key ) VALUES (725, 725);
+INSERT INTO E ( int_nokey, int_key ) VALUES (116, 116);
+INSERT INTO E ( int_nokey, int_key ) VALUES (916, 916);
+INSERT INTO E ( int_nokey, int_key ) VALUES (466, 466);
+INSERT INTO E ( int_nokey, int_key ) VALUES (737, 737);
+INSERT INTO E ( int_nokey, int_key ) VALUES (702, 702);
+INSERT INTO E ( int_nokey, int_key ) VALUES (325, 325);
+INSERT INTO E ( int_nokey, int_key ) VALUES (441, 441);
+INSERT INTO E ( int_nokey, int_key ) VALUES (904, 904);
+INSERT INTO E ( int_nokey, int_key ) VALUES (546, 546);
+INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93);
+INSERT INTO E ( int_nokey, int_key ) VALUES (519, 519);
+INSERT INTO E ( int_nokey, int_key ) VALUES (360, 360);
+INSERT INTO E ( int_nokey, int_key ) VALUES (435, 435);
+INSERT INTO E ( int_nokey, int_key ) VALUES (598, 598);
+INSERT INTO E ( int_nokey, int_key ) VALUES (663, 663);
+INSERT INTO E ( int_nokey, int_key ) VALUES (910, 910);
+INSERT INTO E ( int_nokey, int_key ) VALUES (147, 147);
+INSERT INTO E ( int_nokey, int_key ) VALUES (47, 47);
+INSERT INTO E ( int_nokey, int_key ) VALUES (529, 529);
+INSERT INTO E ( int_nokey, int_key ) VALUES (845, 845);
+INSERT INTO E ( int_nokey, int_key ) VALUES (779, 779);
+INSERT INTO E ( int_nokey, int_key ) VALUES (479, 479);
+INSERT INTO E ( int_nokey, int_key ) VALUES (931, 931);
+INSERT INTO E ( int_nokey, int_key ) VALUES (669, 669);
+INSERT INTO E ( int_nokey, int_key ) VALUES (657, 657);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (37, 37);
+INSERT INTO E ( int_nokey, int_key ) VALUES (347, 347);
+INSERT INTO E ( int_nokey, int_key ) VALUES (676, 676);
+INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378);
+INSERT INTO E ( int_nokey, int_key ) VALUES (323, 323);
+INSERT INTO E ( int_nokey, int_key ) VALUES (266, 266);
+INSERT INTO E ( int_nokey, int_key ) VALUES (790, 790);
+INSERT INTO E ( int_nokey, int_key ) VALUES (780, 780);
+INSERT INTO E ( int_nokey, int_key ) VALUES (616, 616);
+INSERT INTO E ( int_nokey, int_key ) VALUES (619, 619);
+INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130);
+INSERT INTO E ( int_nokey, int_key ) VALUES (69, 69);
+INSERT INTO E ( int_nokey, int_key ) VALUES (812, 812);
+INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO E ( int_nokey, int_key ) VALUES (128, 128);
+INSERT INTO E ( int_nokey, int_key ) VALUES (484, 484);
+INSERT INTO E ( int_nokey, int_key ) VALUES (465, 465);
+INSERT INTO E ( int_nokey, int_key ) VALUES (534, 534);
+INSERT INTO E ( int_nokey, int_key ) VALUES (417, 417);
+INSERT INTO E ( int_nokey, int_key ) VALUES (333, 333);
+INSERT INTO E ( int_nokey, int_key ) VALUES (555, 555);
+INSERT INTO E ( int_nokey, int_key ) VALUES (172, 172);
+INSERT INTO E ( int_nokey, int_key ) VALUES (586, 586);
+INSERT INTO E ( int_nokey, int_key ) VALUES (965, 965);
+INSERT INTO E ( int_nokey, int_key ) VALUES (383, 383);
+INSERT INTO E ( int_nokey, int_key ) VALUES (283, 283);
+INSERT INTO E ( int_nokey, int_key ) VALUES (305, 305);
+INSERT INTO E ( int_nokey, int_key ) VALUES (984, 984);
+INSERT INTO E ( int_nokey, int_key ) VALUES (925, 925);
+INSERT INTO E ( int_nokey, int_key ) VALUES (213, 213);
+INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591);
+INSERT INTO E ( int_nokey, int_key ) VALUES (445, 445);
+INSERT INTO E ( int_nokey, int_key ) VALUES (550, 550);
+INSERT INTO E ( int_nokey, int_key ) VALUES (309, 309);
+INSERT INTO E ( int_nokey, int_key ) VALUES (13, 13);
+INSERT INTO E ( int_nokey, int_key ) VALUES (477, 477);
+INSERT INTO E ( int_nokey, int_key ) VALUES (92, 92);
+INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204);
+INSERT INTO E ( int_nokey, int_key ) VALUES (471, 471);
+INSERT INTO E ( int_nokey, int_key ) VALUES (739, 739);
+INSERT INTO E ( int_nokey, int_key ) VALUES (847, 847);
+INSERT INTO E ( int_nokey, int_key ) VALUES (239, 239);
+INSERT INTO E ( int_nokey, int_key ) VALUES (502, 502);
+INSERT INTO E ( int_nokey, int_key ) VALUES (245, 245);
+INSERT INTO E ( int_nokey, int_key ) VALUES (449, 449);
+INSERT INTO E ( int_nokey, int_key ) VALUES (263, 263);
+INSERT INTO E ( int_nokey, int_key ) VALUES (210, 210);
+INSERT INTO E ( int_nokey, int_key ) VALUES (336, 336);
+INSERT INTO E ( int_nokey, int_key ) VALUES (309, 309);
+INSERT INTO E ( int_nokey, int_key ) VALUES (216, 216);
+INSERT INTO E ( int_nokey, int_key ) VALUES (375, 375);
+INSERT INTO E ( int_nokey, int_key ) VALUES (78, 78);
+INSERT INTO E ( int_nokey, int_key ) VALUES (697, 697);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625);
+INSERT INTO E ( int_nokey, int_key ) VALUES (696, 696);
+INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745);
+INSERT INTO E ( int_nokey, int_key ) VALUES (78, 78);
+INSERT INTO E ( int_nokey, int_key ) VALUES (56, 56);
+INSERT INTO E ( int_nokey, int_key ) VALUES (144, 144);
+INSERT INTO E ( int_nokey, int_key ) VALUES (907, 907);
+INSERT INTO E ( int_nokey, int_key ) VALUES (103, 103);
+INSERT INTO E ( int_nokey, int_key ) VALUES (242, 242);
+INSERT INTO E ( int_nokey, int_key ) VALUES (764, 764);
+INSERT INTO E ( int_nokey, int_key ) VALUES (425, 425);
+INSERT INTO E ( int_nokey, int_key ) VALUES (760, 760);
+INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184);
+INSERT INTO E ( int_nokey, int_key ) VALUES (689, 689);
+INSERT INTO E ( int_nokey, int_key ) VALUES (502, 502);
+INSERT INTO E ( int_nokey, int_key ) VALUES (965, 965);
+INSERT INTO E ( int_nokey, int_key ) VALUES (630, 630);
+INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO E ( int_nokey, int_key ) VALUES (263, 263);
+INSERT INTO E ( int_nokey, int_key ) VALUES (151, 151);
+INSERT INTO E ( int_nokey, int_key ) VALUES (136, 136);
+INSERT INTO E ( int_nokey, int_key ) VALUES (83, 83);
+INSERT INTO E ( int_nokey, int_key ) VALUES (651, 651);
+INSERT INTO E ( int_nokey, int_key ) VALUES (91, 91);
+INSERT INTO E ( int_nokey, int_key ) VALUES (704, 704);
+INSERT INTO E ( int_nokey, int_key ) VALUES (986, 986);
+INSERT INTO E ( int_nokey, int_key ) VALUES (875, 875);
+INSERT INTO E ( int_nokey, int_key ) VALUES (382, 382);
+INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371);
+INSERT INTO E ( int_nokey, int_key ) VALUES (616, 616);
+INSERT INTO E ( int_nokey, int_key ) VALUES (235, 235);
+INSERT INTO E ( int_nokey, int_key ) VALUES (753, 753);
+INSERT INTO E ( int_nokey, int_key ) VALUES (592, 592);
+INSERT INTO E ( int_nokey, int_key ) VALUES (982, 982);
+INSERT INTO E ( int_nokey, int_key ) VALUES (428, 428);
+INSERT INTO E ( int_nokey, int_key ) VALUES (214, 214);
+INSERT INTO E ( int_nokey, int_key ) VALUES (864, 864);
+INSERT INTO E ( int_nokey, int_key ) VALUES (394, 394);
+INSERT INTO E ( int_nokey, int_key ) VALUES (206, 206);
+INSERT INTO E ( int_nokey, int_key ) VALUES (19, 19);
+INSERT INTO E ( int_nokey, int_key ) VALUES (934, 934);
+INSERT INTO E ( int_nokey, int_key ) VALUES (954, 954);
+INSERT INTO E ( int_nokey, int_key ) VALUES (246, 246);
+INSERT INTO E ( int_nokey, int_key ) VALUES (704, 704);
+INSERT INTO E ( int_nokey, int_key ) VALUES (235, 235);
+INSERT INTO E ( int_nokey, int_key ) VALUES (723, 723);
+INSERT INTO E ( int_nokey, int_key ) VALUES (834, 834);
+INSERT INTO E ( int_nokey, int_key ) VALUES (356, 356);
+INSERT INTO E ( int_nokey, int_key ) VALUES (149, 149);
+INSERT INTO E ( int_nokey, int_key ) VALUES (664, 664);
+INSERT INTO E ( int_nokey, int_key ) VALUES (754, 754);
+INSERT INTO E ( int_nokey, int_key ) VALUES (872, 872);
+INSERT INTO E ( int_nokey, int_key ) VALUES (317, 317);
+INSERT INTO E ( int_nokey, int_key ) VALUES (657, 657);
+INSERT INTO E ( int_nokey, int_key ) VALUES (98, 98);
+INSERT INTO E ( int_nokey, int_key ) VALUES (883, 883);
+INSERT INTO E ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO E ( int_nokey, int_key ) VALUES (867, 867);
+INSERT INTO E ( int_nokey, int_key ) VALUES (406, 406);
+INSERT INTO E ( int_nokey, int_key ) VALUES (413, 413);
+INSERT INTO E ( int_nokey, int_key ) VALUES (778, 778);
+INSERT INTO E ( int_nokey, int_key ) VALUES (703, 703);
+INSERT INTO E ( int_nokey, int_key ) VALUES (208, 208);
+INSERT INTO E ( int_nokey, int_key ) VALUES (70, 70);
+INSERT INTO E ( int_nokey, int_key ) VALUES (501, 501);
+INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611);
+INSERT INTO E ( int_nokey, int_key ) VALUES (946, 946);
+INSERT INTO E ( int_nokey, int_key ) VALUES (811, 811);
+INSERT INTO E ( int_nokey, int_key ) VALUES (161, 161);
+INSERT INTO E ( int_nokey, int_key ) VALUES (286, 286);
+INSERT INTO E ( int_nokey, int_key ) VALUES (48, 48);
+INSERT INTO E ( int_nokey, int_key ) VALUES (268, 268);
+INSERT INTO E ( int_nokey, int_key ) VALUES (753, 753);
+INSERT INTO E ( int_nokey, int_key ) VALUES (315, 315);
+INSERT INTO E ( int_nokey, int_key ) VALUES (500, 500);
+INSERT INTO E ( int_nokey, int_key ) VALUES (407, 407);
+INSERT INTO E ( int_nokey, int_key ) VALUES (112, 112);
+INSERT INTO E ( int_nokey, int_key ) VALUES (231, 231);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (505, 505);
+INSERT INTO E ( int_nokey, int_key ) VALUES (903, 903);
+INSERT INTO E ( int_nokey, int_key ) VALUES (874, 874);
+INSERT INTO E ( int_nokey, int_key ) VALUES (719, 719);
+INSERT INTO E ( int_nokey, int_key ) VALUES (61, 61);
+INSERT INTO E ( int_nokey, int_key ) VALUES (861, 861);
+INSERT INTO E ( int_nokey, int_key ) VALUES (400, 400);
+INSERT INTO E ( int_nokey, int_key ) VALUES (655, 655);
+INSERT INTO E ( int_nokey, int_key ) VALUES (382, 382);
+INSERT INTO E ( int_nokey, int_key ) VALUES (563, 563);
+INSERT INTO E ( int_nokey, int_key ) VALUES (348, 348);
+INSERT INTO E ( int_nokey, int_key ) VALUES (437, 437);
+INSERT INTO E ( int_nokey, int_key ) VALUES (50, 50);
+INSERT INTO E ( int_nokey, int_key ) VALUES (36, 36);
+INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625);
+INSERT INTO E ( int_nokey, int_key ) VALUES (632, 632);
+INSERT INTO E ( int_nokey, int_key ) VALUES (743, 743);
+INSERT INTO E ( int_nokey, int_key ) VALUES (251, 251);
+INSERT INTO E ( int_nokey, int_key ) VALUES (746, 746);
+INSERT INTO E ( int_nokey, int_key ) VALUES (74, 74);
+INSERT INTO E ( int_nokey, int_key ) VALUES (777, 777);
+INSERT INTO E ( int_nokey, int_key ) VALUES (704, 704);
+INSERT INTO E ( int_nokey, int_key ) VALUES (250, 250);
+INSERT INTO E ( int_nokey, int_key ) VALUES (960, 960);
+INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60);
+INSERT INTO E ( int_nokey, int_key ) VALUES (993, 993);
+INSERT INTO E ( int_nokey, int_key ) VALUES (57, 57);
+INSERT INTO E ( int_nokey, int_key ) VALUES (333, 333);
+INSERT INTO E ( int_nokey, int_key ) VALUES (656, 656);
+INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130);
+INSERT INTO E ( int_nokey, int_key ) VALUES (919, 919);
+INSERT INTO E ( int_nokey, int_key ) VALUES (45, 45);
+INSERT INTO E ( int_nokey, int_key ) VALUES (65, 65);
+INSERT INTO E ( int_nokey, int_key ) VALUES (703, 703);
+INSERT INTO E ( int_nokey, int_key ) VALUES (949, 949);
+INSERT INTO E ( int_nokey, int_key ) VALUES (570, 570);
+INSERT INTO E ( int_nokey, int_key ) VALUES (273, 273);
+INSERT INTO E ( int_nokey, int_key ) VALUES (118, 118);
+INSERT INTO E ( int_nokey, int_key ) VALUES (728, 728);
+INSERT INTO E ( int_nokey, int_key ) VALUES (506, 506);
+INSERT INTO E ( int_nokey, int_key ) VALUES (271, 271);
+INSERT INTO E ( int_nokey, int_key ) VALUES (987, 987);
+INSERT INTO E ( int_nokey, int_key ) VALUES (483, 483);
+INSERT INTO E ( int_nokey, int_key ) VALUES (577, 577);
+INSERT INTO E ( int_nokey, int_key ) VALUES (572, 572);
+INSERT INTO E ( int_nokey, int_key ) VALUES (965, 965);
+INSERT INTO E ( int_nokey, int_key ) VALUES (495, 495);
+INSERT INTO E ( int_nokey, int_key ) VALUES (54, 54);
+INSERT INTO E ( int_nokey, int_key ) VALUES (438, 438);
+INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457);
+INSERT INTO E ( int_nokey, int_key ) VALUES (798, 798);
+INSERT INTO E ( int_nokey, int_key ) VALUES (431, 431);
+INSERT INTO E ( int_nokey, int_key ) VALUES (300, 300);
+INSERT INTO E ( int_nokey, int_key ) VALUES (982, 982);
+INSERT INTO E ( int_nokey, int_key ) VALUES (712, 712);
+INSERT INTO E ( int_nokey, int_key ) VALUES (776, 776);
+INSERT INTO E ( int_nokey, int_key ) VALUES (934, 934);
+INSERT INTO E ( int_nokey, int_key ) VALUES (335, 335);
+INSERT INTO E ( int_nokey, int_key ) VALUES (958, 958);
+INSERT INTO E ( int_nokey, int_key ) VALUES (483, 483);
+INSERT INTO E ( int_nokey, int_key ) VALUES (462, 462);
+INSERT INTO E ( int_nokey, int_key ) VALUES (268, 268);
+INSERT INTO E ( int_nokey, int_key ) VALUES (654, 654);
+INSERT INTO E ( int_nokey, int_key ) VALUES (145, 145);
+INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184);
+INSERT INTO E ( int_nokey, int_key ) VALUES (135, 135);
+INSERT INTO E ( int_nokey, int_key ) VALUES (46, 46);
+INSERT INTO E ( int_nokey, int_key ) VALUES (532, 532);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (923, 923);
+INSERT INTO E ( int_nokey, int_key ) VALUES (284, 284);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (107, 107);
+INSERT INTO E ( int_nokey, int_key ) VALUES (446, 446);
+INSERT INTO E ( int_nokey, int_key ) VALUES (191, 191);
+INSERT INTO E ( int_nokey, int_key ) VALUES (705, 705);
+INSERT INTO E ( int_nokey, int_key ) VALUES (666, 666);
+INSERT INTO E ( int_nokey, int_key ) VALUES (156, 156);
+INSERT INTO E ( int_nokey, int_key ) VALUES (791, 791);
+INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO E ( int_nokey, int_key ) VALUES (499, 499);
+INSERT INTO E ( int_nokey, int_key ) VALUES (407, 407);
+INSERT INTO E ( int_nokey, int_key ) VALUES (359, 359);
+INSERT INTO E ( int_nokey, int_key ) VALUES (608, 608);
+INSERT INTO E ( int_nokey, int_key ) VALUES (661, 661);
+INSERT INTO E ( int_nokey, int_key ) VALUES (821, 821);
+INSERT INTO E ( int_nokey, int_key ) VALUES (80, 80);
+INSERT INTO E ( int_nokey, int_key ) VALUES (733, 733);
+INSERT INTO E ( int_nokey, int_key ) VALUES (823, 823);
+INSERT INTO E ( int_nokey, int_key ) VALUES (300, 300);
+INSERT INTO E ( int_nokey, int_key ) VALUES (693, 693);
+INSERT INTO E ( int_nokey, int_key ) VALUES (863, 863);
+INSERT INTO E ( int_nokey, int_key ) VALUES (734, 734);
+INSERT INTO E ( int_nokey, int_key ) VALUES (768, 768);
+INSERT INTO E ( int_nokey, int_key ) VALUES (52, 52);
+INSERT INTO E ( int_nokey, int_key ) VALUES (793, 793);
+INSERT INTO E ( int_nokey, int_key ) VALUES (756, 756);
+INSERT INTO E ( int_nokey, int_key ) VALUES (770, 770);
+INSERT INTO E ( int_nokey, int_key ) VALUES (644, 644);
+INSERT INTO E ( int_nokey, int_key ) VALUES (220, 220);
+INSERT INTO E ( int_nokey, int_key ) VALUES (109, 109);
+INSERT INTO E ( int_nokey, int_key ) VALUES (976, 976);
+INSERT INTO E ( int_nokey, int_key ) VALUES (291, 291);
+INSERT INTO E ( int_nokey, int_key ) VALUES (729, 729);
+INSERT INTO E ( int_nokey, int_key ) VALUES (151, 151);
+INSERT INTO E ( int_nokey, int_key ) VALUES (604, 604);
+INSERT INTO E ( int_nokey, int_key ) VALUES (367, 367);
+INSERT INTO E ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO E ( int_nokey, int_key ) VALUES (515, 515);
+INSERT INTO E ( int_nokey, int_key ) VALUES (912, 912);
+INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625);
+INSERT INTO E ( int_nokey, int_key ) VALUES (402, 402);
+INSERT INTO E ( int_nokey, int_key ) VALUES (768, 768);
+INSERT INTO E ( int_nokey, int_key ) VALUES (654, 654);
+INSERT INTO E ( int_nokey, int_key ) VALUES (675, 675);
+INSERT INTO E ( int_nokey, int_key ) VALUES (326, 326);
+INSERT INTO E ( int_nokey, int_key ) VALUES (888, 888);
+INSERT INTO E ( int_nokey, int_key ) VALUES (683, 683);
+INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94);
+INSERT INTO E ( int_nokey, int_key ) VALUES (175, 175);
+INSERT INTO E ( int_nokey, int_key ) VALUES (265, 265);
+INSERT INTO E ( int_nokey, int_key ) VALUES (443, 443);
+INSERT INTO E ( int_nokey, int_key ) VALUES (345, 345);
+INSERT INTO E ( int_nokey, int_key ) VALUES (306, 306);
+INSERT INTO E ( int_nokey, int_key ) VALUES (399, 399);
+INSERT INTO E ( int_nokey, int_key ) VALUES (557, 557);
+INSERT INTO E ( int_nokey, int_key ) VALUES (59, 59);
+INSERT INTO E ( int_nokey, int_key ) VALUES (484, 484);
+INSERT INTO E ( int_nokey, int_key ) VALUES (429, 429);
+INSERT INTO E ( int_nokey, int_key ) VALUES (249, 249);
+INSERT INTO E ( int_nokey, int_key ) VALUES (728, 728);
+INSERT INTO E ( int_nokey, int_key ) VALUES (501, 501);
+INSERT INTO E ( int_nokey, int_key ) VALUES (307, 307);
+INSERT INTO E ( int_nokey, int_key ) VALUES (173, 173);
+INSERT INTO E ( int_nokey, int_key ) VALUES (520, 520);
+INSERT INTO E ( int_nokey, int_key ) VALUES (229, 229);
+INSERT INTO E ( int_nokey, int_key ) VALUES (583, 583);
+INSERT INTO E ( int_nokey, int_key ) VALUES (950, 950);
+INSERT INTO E ( int_nokey, int_key ) VALUES (412, 412);
+INSERT INTO E ( int_nokey, int_key ) VALUES (810, 810);
+INSERT INTO E ( int_nokey, int_key ) VALUES (586, 586);
+INSERT INTO E ( int_nokey, int_key ) VALUES (276, 276);
+INSERT INTO E ( int_nokey, int_key ) VALUES (256, 256);
+INSERT INTO E ( int_nokey, int_key ) VALUES (722, 722);
+INSERT INTO E ( int_nokey, int_key ) VALUES (419, 419);
+INSERT INTO E ( int_nokey, int_key ) VALUES (727, 727);
+INSERT INTO E ( int_nokey, int_key ) VALUES (180, 180);
+INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130);
+INSERT INTO E ( int_nokey, int_key ) VALUES (738, 738);
+INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148);
+INSERT INTO E ( int_nokey, int_key ) VALUES (38, 38);
+INSERT INTO E ( int_nokey, int_key ) VALUES (346, 346);
+INSERT INTO E ( int_nokey, int_key ) VALUES (263, 263);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (584, 584);
+INSERT INTO E ( int_nokey, int_key ) VALUES (972, 972);
+INSERT INTO E ( int_nokey, int_key ) VALUES (485, 485);
+INSERT INTO E ( int_nokey, int_key ) VALUES (989, 989);
+INSERT INTO E ( int_nokey, int_key ) VALUES (22, 22);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (891, 891);
+INSERT INTO E ( int_nokey, int_key ) VALUES (756, 756);
+INSERT INTO E ( int_nokey, int_key ) VALUES (284, 284);
+INSERT INTO E ( int_nokey, int_key ) VALUES (146, 146);
+INSERT INTO E ( int_nokey, int_key ) VALUES (270, 270);
+INSERT INTO E ( int_nokey, int_key ) VALUES (379, 379);
+INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371);
+INSERT INTO E ( int_nokey, int_key ) VALUES (997, 997);
+INSERT INTO E ( int_nokey, int_key ) VALUES (624, 624);
+INSERT INTO E ( int_nokey, int_key ) VALUES (559, 559);
+INSERT INTO E ( int_nokey, int_key ) VALUES (690, 690);
+INSERT INTO E ( int_nokey, int_key ) VALUES (369, 369);
+INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625);
+INSERT INTO E ( int_nokey, int_key ) VALUES (604, 604);
+INSERT INTO E ( int_nokey, int_key ) VALUES (340, 340);
+INSERT INTO E ( int_nokey, int_key ) VALUES (253, 253);
+INSERT INTO E ( int_nokey, int_key ) VALUES (316, 316);
+INSERT INTO E ( int_nokey, int_key ) VALUES (481, 481);
+INSERT INTO E ( int_nokey, int_key ) VALUES (572, 572);
+INSERT INTO E ( int_nokey, int_key ) VALUES (117, 117);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94);
+INSERT INTO E ( int_nokey, int_key ) VALUES (311, 311);
+INSERT INTO E ( int_nokey, int_key ) VALUES (788, 788);
+INSERT INTO E ( int_nokey, int_key ) VALUES (281, 281);
+INSERT INTO E ( int_nokey, int_key ) VALUES (118, 118);
+INSERT INTO E ( int_nokey, int_key ) VALUES (26, 26);
+INSERT INTO E ( int_nokey, int_key ) VALUES (918, 918);
+INSERT INTO E ( int_nokey, int_key ) VALUES (660, 660);
+INSERT INTO E ( int_nokey, int_key ) VALUES (394, 394);
+INSERT INTO E ( int_nokey, int_key ) VALUES (739, 739);
+INSERT INTO E ( int_nokey, int_key ) VALUES (342, 342);
+INSERT INTO E ( int_nokey, int_key ) VALUES (921, 921);
+INSERT INTO E ( int_nokey, int_key ) VALUES (365, 365);
+INSERT INTO E ( int_nokey, int_key ) VALUES (594, 594);
+INSERT INTO E ( int_nokey, int_key ) VALUES (764, 764);
+INSERT INTO E ( int_nokey, int_key ) VALUES (788, 788);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (563, 563);
+INSERT INTO E ( int_nokey, int_key ) VALUES (131, 131);
+INSERT INTO E ( int_nokey, int_key ) VALUES (44, 44);
+INSERT INTO E ( int_nokey, int_key ) VALUES (868, 868);
+INSERT INTO E ( int_nokey, int_key ) VALUES (415, 415);
+INSERT INTO E ( int_nokey, int_key ) VALUES (335, 335);
+INSERT INTO E ( int_nokey, int_key ) VALUES (367, 367);
+INSERT INTO E ( int_nokey, int_key ) VALUES (221, 221);
+INSERT INTO E ( int_nokey, int_key ) VALUES (418, 418);
+INSERT INTO E ( int_nokey, int_key ) VALUES (108, 108);
+INSERT INTO E ( int_nokey, int_key ) VALUES (384, 384);
+INSERT INTO E ( int_nokey, int_key ) VALUES (569, 569);
+INSERT INTO E ( int_nokey, int_key ) VALUES (951, 951);
+INSERT INTO E ( int_nokey, int_key ) VALUES (206, 206);
+INSERT INTO E ( int_nokey, int_key ) VALUES (203, 203);
+INSERT INTO E ( int_nokey, int_key ) VALUES (68, 68);
+INSERT INTO E ( int_nokey, int_key ) VALUES (869, 869);
+INSERT INTO E ( int_nokey, int_key ) VALUES (827, 827);
+INSERT INTO E ( int_nokey, int_key ) VALUES (893, 893);
+INSERT INTO E ( int_nokey, int_key ) VALUES (271, 271);
+INSERT INTO E ( int_nokey, int_key ) VALUES (268, 268);
+INSERT INTO E ( int_nokey, int_key ) VALUES (319, 319);
+INSERT INTO E ( int_nokey, int_key ) VALUES (725, 725);
+INSERT INTO E ( int_nokey, int_key ) VALUES (948, 948);
+INSERT INTO E ( int_nokey, int_key ) VALUES (10, 10);
+INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204);
+INSERT INTO E ( int_nokey, int_key ) VALUES (714, 714);
+INSERT INTO E ( int_nokey, int_key ) VALUES (764, 764);
+INSERT INTO E ( int_nokey, int_key ) VALUES (828, 828);
+INSERT INTO E ( int_nokey, int_key ) VALUES (524, 524);
+INSERT INTO E ( int_nokey, int_key ) VALUES (324, 324);
+INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804);
+INSERT INTO E ( int_nokey, int_key ) VALUES (950, 950);
+INSERT INTO E ( int_nokey, int_key ) VALUES (201, 201);
+INSERT INTO E ( int_nokey, int_key ) VALUES (568, 568);
+INSERT INTO E ( int_nokey, int_key ) VALUES (946, 946);
+INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457);
+INSERT INTO E ( int_nokey, int_key ) VALUES (185, 185);
+INSERT INTO E ( int_nokey, int_key ) VALUES (445, 445);
+INSERT INTO E ( int_nokey, int_key ) VALUES (634, 634);
+INSERT INTO E ( int_nokey, int_key ) VALUES (141, 141);
+INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204);
+INSERT INTO E ( int_nokey, int_key ) VALUES (505, 505);
+INSERT INTO E ( int_nokey, int_key ) VALUES (546, 546);
+INSERT INTO E ( int_nokey, int_key ) VALUES (491, 491);
+INSERT INTO E ( int_nokey, int_key ) VALUES (432, 432);
+INSERT INTO E ( int_nokey, int_key ) VALUES (471, 471);
+INSERT INTO E ( int_nokey, int_key ) VALUES (341, 341);
+INSERT INTO E ( int_nokey, int_key ) VALUES (24, 24);
+INSERT INTO E ( int_nokey, int_key ) VALUES (666, 666);
+INSERT INTO E ( int_nokey, int_key ) VALUES (574, 574);
+INSERT INTO E ( int_nokey, int_key ) VALUES (515, 515);
+INSERT INTO E ( int_nokey, int_key ) VALUES (100, 100);
+INSERT INTO E ( int_nokey, int_key ) VALUES (857, 857);
+INSERT INTO E ( int_nokey, int_key ) VALUES (571, 571);
+INSERT INTO E ( int_nokey, int_key ) VALUES (366, 366);
+INSERT INTO E ( int_nokey, int_key ) VALUES (166, 166);
+INSERT INTO E ( int_nokey, int_key ) VALUES (411, 411);
+INSERT INTO E ( int_nokey, int_key ) VALUES (969, 969);
+INSERT INTO E ( int_nokey, int_key ) VALUES (862, 862);
+INSERT INTO E ( int_nokey, int_key ) VALUES (438, 438);
+INSERT INTO E ( int_nokey, int_key ) VALUES (153, 153);
+INSERT INTO E ( int_nokey, int_key ) VALUES (839, 839);
+INSERT INTO E ( int_nokey, int_key ) VALUES (690, 690);
+INSERT INTO E ( int_nokey, int_key ) VALUES (931, 931);
+INSERT INTO E ( int_nokey, int_key ) VALUES (834, 834);
+INSERT INTO E ( int_nokey, int_key ) VALUES (674, 674);
+INSERT INTO E ( int_nokey, int_key ) VALUES (773, 773);
+INSERT INTO E ( int_nokey, int_key ) VALUES (581, 581);
+INSERT INTO E ( int_nokey, int_key ) VALUES (438, 438);
+INSERT INTO E ( int_nokey, int_key ) VALUES (6, 6);
+INSERT INTO E ( int_nokey, int_key ) VALUES (818, 818);
+INSERT INTO E ( int_nokey, int_key ) VALUES (737, 737);
+INSERT INTO E ( int_nokey, int_key ) VALUES (127, 127);
+INSERT INTO E ( int_nokey, int_key ) VALUES (436, 436);
+INSERT INTO E ( int_nokey, int_key ) VALUES (101, 101);
+INSERT INTO E ( int_nokey, int_key ) VALUES (181, 181);
+INSERT INTO E ( int_nokey, int_key ) VALUES (783, 783);
+INSERT INTO E ( int_nokey, int_key ) VALUES (959, 959);
+INSERT INTO E ( int_nokey, int_key ) VALUES (170, 170);
+INSERT INTO E ( int_nokey, int_key ) VALUES (111, 111);
+INSERT INTO E ( int_nokey, int_key ) VALUES (574, 574);
+INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130);
+INSERT INTO E ( int_nokey, int_key ) VALUES (935, 935);
+INSERT INTO E ( int_nokey, int_key ) VALUES (388, 388);
+INSERT INTO E ( int_nokey, int_key ) VALUES (771, 771);
+INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84);
+INSERT INTO E ( int_nokey, int_key ) VALUES (898, 898);
+INSERT INTO E ( int_nokey, int_key ) VALUES (91, 91);
+INSERT INTO E ( int_nokey, int_key ) VALUES (896, 896);
+INSERT INTO E ( int_nokey, int_key ) VALUES (252, 252);
+INSERT INTO E ( int_nokey, int_key ) VALUES (773, 773);
+INSERT INTO E ( int_nokey, int_key ) VALUES (855, 855);
+INSERT INTO E ( int_nokey, int_key ) VALUES (735, 735);
+INSERT INTO E ( int_nokey, int_key ) VALUES (215, 215);
+INSERT INTO E ( int_nokey, int_key ) VALUES (544, 544);
+INSERT INTO E ( int_nokey, int_key ) VALUES (991, 991);
+INSERT INTO E ( int_nokey, int_key ) VALUES (626, 626);
+INSERT INTO E ( int_nokey, int_key ) VALUES (290, 290);
+INSERT INTO E ( int_nokey, int_key ) VALUES (24, 24);
+INSERT INTO E ( int_nokey, int_key ) VALUES (605, 605);
+INSERT INTO E ( int_nokey, int_key ) VALUES (718, 718);
+INSERT INTO E ( int_nokey, int_key ) VALUES (542, 542);
+INSERT INTO E ( int_nokey, int_key ) VALUES (61, 61);
+INSERT INTO E ( int_nokey, int_key ) VALUES (209, 209);
+INSERT INTO E ( int_nokey, int_key ) VALUES (467, 467);
+INSERT INTO E ( int_nokey, int_key ) VALUES (234, 234);
+INSERT INTO E ( int_nokey, int_key ) VALUES (919, 919);
+INSERT INTO E ( int_nokey, int_key ) VALUES (105, 105);
+INSERT INTO E ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO E ( int_nokey, int_key ) VALUES (432, 432);
+INSERT INTO E ( int_nokey, int_key ) VALUES (731, 731);
+INSERT INTO E ( int_nokey, int_key ) VALUES (514, 514);
+INSERT INTO E ( int_nokey, int_key ) VALUES (665, 665);
+INSERT INTO E ( int_nokey, int_key ) VALUES (280, 280);
+INSERT INTO E ( int_nokey, int_key ) VALUES (670, 670);
+INSERT INTO E ( int_nokey, int_key ) VALUES (136, 136);
+INSERT INTO E ( int_nokey, int_key ) VALUES (59, 59);
+INSERT INTO E ( int_nokey, int_key ) VALUES (516, 516);
+INSERT INTO E ( int_nokey, int_key ) VALUES (154, 154);
+INSERT INTO E ( int_nokey, int_key ) VALUES (232, 232);
+INSERT INTO E ( int_nokey, int_key ) VALUES (478, 478);
+INSERT INTO E ( int_nokey, int_key ) VALUES (127, 127);
+INSERT INTO E ( int_nokey, int_key ) VALUES (679, 679);
+INSERT INTO E ( int_nokey, int_key ) VALUES (983, 983);
+INSERT INTO E ( int_nokey, int_key ) VALUES (781, 781);
+INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745);
+INSERT INTO E ( int_nokey, int_key ) VALUES (55, 55);
+INSERT INTO E ( int_nokey, int_key ) VALUES (849, 849);
+INSERT INTO E ( int_nokey, int_key ) VALUES (924, 924);
+INSERT INTO E ( int_nokey, int_key ) VALUES (882, 882);
+INSERT INTO E ( int_nokey, int_key ) VALUES (854, 854);
+INSERT INTO E ( int_nokey, int_key ) VALUES (992, 992);
+INSERT INTO E ( int_nokey, int_key ) VALUES (232, 232);
+INSERT INTO E ( int_nokey, int_key ) VALUES (416, 416);
+INSERT INTO E ( int_nokey, int_key ) VALUES (881, 881);
+INSERT INTO E ( int_nokey, int_key ) VALUES (784, 784);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (718, 718);
+INSERT INTO E ( int_nokey, int_key ) VALUES (668, 668);
+INSERT INTO E ( int_nokey, int_key ) VALUES (776, 776);
+INSERT INTO E ( int_nokey, int_key ) VALUES (337, 337);
+INSERT INTO E ( int_nokey, int_key ) VALUES (257, 257);
+INSERT INTO E ( int_nokey, int_key ) VALUES (261, 261);
+INSERT INTO E ( int_nokey, int_key ) VALUES (557, 557);
+INSERT INTO E ( int_nokey, int_key ) VALUES (786, 786);
+INSERT INTO E ( int_nokey, int_key ) VALUES (879, 879);
+INSERT INTO E ( int_nokey, int_key ) VALUES (392, 392);
+INSERT INTO E ( int_nokey, int_key ) VALUES (227, 227);
+INSERT INTO E ( int_nokey, int_key ) VALUES (347, 347);
+INSERT INTO E ( int_nokey, int_key ) VALUES (802, 802);
+INSERT INTO E ( int_nokey, int_key ) VALUES (236, 236);
+INSERT INTO E ( int_nokey, int_key ) VALUES (97, 97);
+INSERT INTO E ( int_nokey, int_key ) VALUES (343, 343);
+INSERT INTO E ( int_nokey, int_key ) VALUES (556, 556);
+INSERT INTO E ( int_nokey, int_key ) VALUES (72, 72);
+INSERT INTO E ( int_nokey, int_key ) VALUES (2, 2);
+INSERT INTO E ( int_nokey, int_key ) VALUES (87, 87);
+INSERT INTO E ( int_nokey, int_key ) VALUES (216, 216);
+INSERT INTO E ( int_nokey, int_key ) VALUES (769, 769);
+INSERT INTO E ( int_nokey, int_key ) VALUES (711, 711);
+INSERT INTO E ( int_nokey, int_key ) VALUES (937, 937);
+INSERT INTO E ( int_nokey, int_key ) VALUES (434, 434);
+INSERT INTO E ( int_nokey, int_key ) VALUES (186, 186);
+INSERT INTO E ( int_nokey, int_key ) VALUES (355, 355);
+INSERT INTO E ( int_nokey, int_key ) VALUES (153, 153);
+INSERT INTO E ( int_nokey, int_key ) VALUES (609, 609);
+INSERT INTO E ( int_nokey, int_key ) VALUES (507, 507);
+INSERT INTO E ( int_nokey, int_key ) VALUES (83, 83);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (435, 435);
+INSERT INTO E ( int_nokey, int_key ) VALUES (623, 623);
+INSERT INTO E ( int_nokey, int_key ) VALUES (19, 19);
+INSERT INTO E ( int_nokey, int_key ) VALUES (292, 292);
+INSERT INTO E ( int_nokey, int_key ) VALUES (702, 702);
+INSERT INTO E ( int_nokey, int_key ) VALUES (884, 884);
+INSERT INTO E ( int_nokey, int_key ) VALUES (761, 761);
+INSERT INTO E ( int_nokey, int_key ) VALUES (993, 993);
+INSERT INTO E ( int_nokey, int_key ) VALUES (287, 287);
+INSERT INTO E ( int_nokey, int_key ) VALUES (531, 531);
+INSERT INTO E ( int_nokey, int_key ) VALUES (329, 329);
+INSERT INTO E ( int_nokey, int_key ) VALUES (919, 919);
+INSERT INTO E ( int_nokey, int_key ) VALUES (351, 351);
+INSERT INTO E ( int_nokey, int_key ) VALUES (692, 692);
+INSERT INTO E ( int_nokey, int_key ) VALUES (739, 739);
+INSERT INTO E ( int_nokey, int_key ) VALUES (254, 254);
+INSERT INTO E ( int_nokey, int_key ) VALUES (71, 71);
+INSERT INTO E ( int_nokey, int_key ) VALUES (873, 873);
+INSERT INTO E ( int_nokey, int_key ) VALUES (956, 956);
+INSERT INTO E ( int_nokey, int_key ) VALUES (888, 888);
+INSERT INTO E ( int_nokey, int_key ) VALUES (64, 64);
+INSERT INTO E ( int_nokey, int_key ) VALUES (945, 945);
+INSERT INTO E ( int_nokey, int_key ) VALUES (150, 150);
+INSERT INTO E ( int_nokey, int_key ) VALUES (705, 705);
+INSERT INTO E ( int_nokey, int_key ) VALUES (832, 832);
+INSERT INTO E ( int_nokey, int_key ) VALUES (7, 7);
+INSERT INTO E ( int_nokey, int_key ) VALUES (405, 405);
+INSERT INTO E ( int_nokey, int_key ) VALUES (411, 411);
+INSERT INTO E ( int_nokey, int_key ) VALUES (160, 160);
+INSERT INTO E ( int_nokey, int_key ) VALUES (429, 429);
+INSERT INTO E ( int_nokey, int_key ) VALUES (546, 546);
+INSERT INTO E ( int_nokey, int_key ) VALUES (332, 332);
+INSERT INTO E ( int_nokey, int_key ) VALUES (656, 656);
+INSERT INTO E ( int_nokey, int_key ) VALUES (410, 410);
+INSERT INTO E ( int_nokey, int_key ) VALUES (913, 913);
+INSERT INTO E ( int_nokey, int_key ) VALUES (289, 289);
+INSERT INTO E ( int_nokey, int_key ) VALUES (584, 584);
+INSERT INTO E ( int_nokey, int_key ) VALUES (624, 624);
+INSERT INTO E ( int_nokey, int_key ) VALUES (959, 959);
+INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132);
+INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378);
+INSERT INTO E ( int_nokey, int_key ) VALUES (758, 758);
+INSERT INTO E ( int_nokey, int_key ) VALUES (493, 493);
+INSERT INTO E ( int_nokey, int_key ) VALUES (401, 401);
+INSERT INTO E ( int_nokey, int_key ) VALUES (772, 772);
+INSERT INTO E ( int_nokey, int_key ) VALUES (787, 787);
+INSERT INTO E ( int_nokey, int_key ) VALUES (733, 733);
+INSERT INTO E ( int_nokey, int_key ) VALUES (981, 981);
+INSERT INTO E ( int_nokey, int_key ) VALUES (207, 207);
+INSERT INTO E ( int_nokey, int_key ) VALUES (937, 937);
+INSERT INTO E ( int_nokey, int_key ) VALUES (660, 660);
+INSERT INTO E ( int_nokey, int_key ) VALUES (779, 779);
+INSERT INTO E ( int_nokey, int_key ) VALUES (124, 124);
+INSERT INTO E ( int_nokey, int_key ) VALUES (857, 857);
+INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93);
+INSERT INTO E ( int_nokey, int_key ) VALUES (414, 414);
+INSERT INTO E ( int_nokey, int_key ) VALUES (129, 129);
+INSERT INTO E ( int_nokey, int_key ) VALUES (165, 165);
+INSERT INTO E ( int_nokey, int_key ) VALUES (807, 807);
+INSERT INTO E ( int_nokey, int_key ) VALUES (408, 408);
+INSERT INTO E ( int_nokey, int_key ) VALUES (823, 823);
+INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512);
+INSERT INTO E ( int_nokey, int_key ) VALUES (583, 583);
+INSERT INTO E ( int_nokey, int_key ) VALUES (687, 687);
+INSERT INTO E ( int_nokey, int_key ) VALUES (886, 886);
+INSERT INTO E ( int_nokey, int_key ) VALUES (382, 382);
+INSERT INTO E ( int_nokey, int_key ) VALUES (270, 270);
+INSERT INTO E ( int_nokey, int_key ) VALUES (339, 339);
+INSERT INTO E ( int_nokey, int_key ) VALUES (732, 732);
+INSERT INTO E ( int_nokey, int_key ) VALUES (121, 121);
+INSERT INTO E ( int_nokey, int_key ) VALUES (781, 781);
+INSERT INTO E ( int_nokey, int_key ) VALUES (11, 11);
+INSERT INTO E ( int_nokey, int_key ) VALUES (703, 703);
+INSERT INTO E ( int_nokey, int_key ) VALUES (227, 227);
+INSERT INTO E ( int_nokey, int_key ) VALUES (910, 910);
+INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611);
+INSERT INTO E ( int_nokey, int_key ) VALUES (77, 77);
+INSERT INTO E ( int_nokey, int_key ) VALUES (585, 585);
+INSERT INTO E ( int_nokey, int_key ) VALUES (137, 137);
+INSERT INTO E ( int_nokey, int_key ) VALUES (452, 452);
+INSERT INTO E ( int_nokey, int_key ) VALUES (719, 719);
+INSERT INTO E ( int_nokey, int_key ) VALUES (425, 425);
+INSERT INTO E ( int_nokey, int_key ) VALUES (398, 398);
+INSERT INTO E ( int_nokey, int_key ) VALUES (939, 939);
+INSERT INTO E ( int_nokey, int_key ) VALUES (448, 448);
+INSERT INTO E ( int_nokey, int_key ) VALUES (38, 38);
+INSERT INTO E ( int_nokey, int_key ) VALUES (416, 416);
+INSERT INTO E ( int_nokey, int_key ) VALUES (556, 556);
+INSERT INTO E ( int_nokey, int_key ) VALUES (220, 220);
+INSERT INTO E ( int_nokey, int_key ) VALUES (169, 169);
+INSERT INTO E ( int_nokey, int_key ) VALUES (476, 476);
+INSERT INTO E ( int_nokey, int_key ) VALUES (122, 122);
+INSERT INTO E ( int_nokey, int_key ) VALUES (430, 430);
+INSERT INTO E ( int_nokey, int_key ) VALUES (175, 175);
+INSERT INTO E ( int_nokey, int_key ) VALUES (973, 973);
+INSERT INTO E ( int_nokey, int_key ) VALUES (436, 436);
+INSERT INTO E ( int_nokey, int_key ) VALUES (394, 394);
+INSERT INTO E ( int_nokey, int_key ) VALUES (129, 129);
+INSERT INTO E ( int_nokey, int_key ) VALUES (177, 177);
+INSERT INTO E ( int_nokey, int_key ) VALUES (654, 654);
+INSERT INTO E ( int_nokey, int_key ) VALUES (798, 798);
+INSERT INTO E ( int_nokey, int_key ) VALUES (525, 525);
+INSERT INTO E ( int_nokey, int_key ) VALUES (992, 992);
+INSERT INTO E ( int_nokey, int_key ) VALUES (676, 676);
+INSERT INTO E ( int_nokey, int_key ) VALUES (286, 286);
+INSERT INTO E ( int_nokey, int_key ) VALUES (61, 61);
+INSERT INTO E ( int_nokey, int_key ) VALUES (357, 357);
+INSERT INTO E ( int_nokey, int_key ) VALUES (65, 65);
+INSERT INTO E ( int_nokey, int_key ) VALUES (830, 830);
+INSERT INTO E ( int_nokey, int_key ) VALUES (351, 351);
+INSERT INTO E ( int_nokey, int_key ) VALUES (941, 941);
+INSERT INTO E ( int_nokey, int_key ) VALUES (131, 131);
+INSERT INTO E ( int_nokey, int_key ) VALUES (54, 54);
+INSERT INTO E ( int_nokey, int_key ) VALUES (567, 567);
+INSERT INTO E ( int_nokey, int_key ) VALUES (918, 918);
+INSERT INTO E ( int_nokey, int_key ) VALUES (126, 126);
+INSERT INTO E ( int_nokey, int_key ) VALUES (716, 716);
+INSERT INTO E ( int_nokey, int_key ) VALUES (960, 960);
+INSERT INTO E ( int_nokey, int_key ) VALUES (665, 665);
+INSERT INTO E ( int_nokey, int_key ) VALUES (439, 439);
+INSERT INTO E ( int_nokey, int_key ) VALUES (396, 396);
+INSERT INTO E ( int_nokey, int_key ) VALUES (496, 496);
+INSERT INTO E ( int_nokey, int_key ) VALUES (789, 789);
+INSERT INTO E ( int_nokey, int_key ) VALUES (142, 142);
+INSERT INTO E ( int_nokey, int_key ) VALUES (452, 452);
+INSERT INTO E ( int_nokey, int_key ) VALUES (139, 139);
+INSERT INTO E ( int_nokey, int_key ) VALUES (992, 992);
+INSERT INTO E ( int_nokey, int_key ) VALUES (784, 784);
+INSERT INTO E ( int_nokey, int_key ) VALUES (267, 267);
+INSERT INTO E ( int_nokey, int_key ) VALUES (610, 610);
+INSERT INTO E ( int_nokey, int_key ) VALUES (83, 83);
+INSERT INTO E ( int_nokey, int_key ) VALUES (228, 228);
+INSERT INTO E ( int_nokey, int_key ) VALUES (884, 884);
+INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93);
+INSERT INTO E ( int_nokey, int_key ) VALUES (207, 207);
+INSERT INTO E ( int_nokey, int_key ) VALUES (278, 278);
+INSERT INTO E ( int_nokey, int_key ) VALUES (575, 575);
+INSERT INTO E ( int_nokey, int_key ) VALUES (599, 599);
+INSERT INTO E ( int_nokey, int_key ) VALUES (811, 811);
+INSERT INTO E ( int_nokey, int_key ) VALUES (646, 646);
+INSERT INTO E ( int_nokey, int_key ) VALUES (756, 756);
+INSERT INTO E ( int_nokey, int_key ) VALUES (772, 772);
+INSERT INTO E ( int_nokey, int_key ) VALUES (511, 511);
+INSERT INTO E ( int_nokey, int_key ) VALUES (115, 115);
+INSERT INTO E ( int_nokey, int_key ) VALUES (603, 603);
+INSERT INTO E ( int_nokey, int_key ) VALUES (294, 294);
+INSERT INTO E ( int_nokey, int_key ) VALUES (238, 238);
+INSERT INTO E ( int_nokey, int_key ) VALUES (966, 966);
+INSERT INTO E ( int_nokey, int_key ) VALUES (721, 721);
+INSERT INTO E ( int_nokey, int_key ) VALUES (665, 665);
+INSERT INTO E ( int_nokey, int_key ) VALUES (376, 376);
+INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543);
+INSERT INTO E ( int_nokey, int_key ) VALUES (305, 305);
+INSERT INTO E ( int_nokey, int_key ) VALUES (903, 903);
+INSERT INTO E ( int_nokey, int_key ) VALUES (232, 232);
+INSERT INTO E ( int_nokey, int_key ) VALUES (95, 95);
+INSERT INTO E ( int_nokey, int_key ) VALUES (282, 282);
+INSERT INTO E ( int_nokey, int_key ) VALUES (242, 242);
+INSERT INTO E ( int_nokey, int_key ) VALUES (785, 785);
+INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543);
+INSERT INTO E ( int_nokey, int_key ) VALUES (478, 478);
+INSERT INTO E ( int_nokey, int_key ) VALUES (413, 413);
+INSERT INTO E ( int_nokey, int_key ) VALUES (937, 937);
+INSERT INTO E ( int_nokey, int_key ) VALUES (955, 955);
+INSERT INTO E ( int_nokey, int_key ) VALUES (517, 517);
+INSERT INTO E ( int_nokey, int_key ) VALUES (972, 972);
+INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457);
+;
+set autocommit=1;
+SET AUTOCOMMIT=0;
+UPDATE C AS X SET pk = 9 , filler = REPEAT ( ' X ' , ( SELECT 90 FROM ( SELECT COUNT( pk
) FROM C AS X WHERE X . int_nokey < 92 LIMIT 20 ) AS X WHERE X . int_nokey < 76
LIMIT 1 ) ) WHERE X . pk < 58 ORDER BY RAND ( ) LIMIT 20;
+INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT int_nokey FROM E AS X WHERE X .
int_nokey < 93 LIMIT 1 ) , 16 );
+START TRANSACTION;
+INSERT INTO D ( int_key , int_nokey ) VALUES ( 42 , ( SELECT AVG( int_key ) FROM E AS X
WHERE X . int_key < 56 GROUP BY int_key LIMIT 1 ) );
+INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT int_nokey FROM D AS X LEFT JOIN E
AS Y ON ( X . int_nokey = Y . pk ) WHERE X . pk < 40 LIMIT 1 ) , 61 );
+INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_key ) FROM A AS X LEFT
JOIN D AS Y ON ( X . int_key = Y . int_nokey ) WHERE X . pk < 33 GROUP BY int_nokey
LIMIT 1 ) , ( SELECT int_key FROM E AS X LEFT JOIN B AS Y ON ( X . pk = Y . int_key )
WHERE X . pk < 42 GROUP BY int_key LIMIT 1 ) );
+UPDATE E AS X SET int_nokey = ( SELECT AVG( int_key ) FROM E AS X WHERE X . pk < 38
GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( pk ) FROM C AS X LEFT
JOIN A AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 46 GROUP BY pk LIMIT 1 )
) WHERE X . int_nokey < 49 ORDER BY RAND ( ) LIMIT 20;
+INSERT INTO E ( int_key , int_nokey ) VALUES ( 19 , 73 );
+START TRANSACTION;
+INSERT INTO D ( int_key , int_nokey ) VALUES ( ( SELECT int_key FROM B AS X LEFT JOIN D
AS Y ON ( X . int_key = Y . int_nokey ) WHERE X . pk < 54 LIMIT 1 ) , ( SELECT COUNT(
int_key ) FROM B AS X LEFT JOIN D AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk
< 14 LIMIT 1 ) );
+INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT 84 FROM C AS X LEFT JOIN D AS Y
ON ( X . pk = Y . pk ) WHERE X . pk < 52 GROUP BY int_nokey LIMIT 1 ) , 88 );
+INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT 55 FROM A AS X LEFT JOIN A AS Y
ON ( X . pk = Y . pk ) WHERE X . int_nokey < 10 GROUP BY int_nokey LIMIT 1 ) , (
SELECT 63 FROM ( SELECT AVG( pk ) FROM ( SELECT ( SELECT int_nokey FROM D AS X LEFT JOIN
C AS Y ON ( X . pk = Y . int_nokey ) WHERE X . int_nokey < 98 GROUP BY pk LIMIT 1 )
FROM B AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . pk < 74
LIMIT 20 ) AS X WHERE X . pk < 91 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk <
54 LIMIT 1 ) );
+UPDATE A AS X SET int_nokey = 85 , filler = REPEAT ( ' X ' , 15 ) WHERE X . int_key <
17 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET int_key = 97 , filler = REPEAT ( ' X ' , ( SELECT 84 FROM B AS X WHERE
X . pk < 62 LIMIT 1 ) ) WHERE X . int_nokey < 38 ORDER BY RAND ( ) LIMIT 20;
+UPDATE B AS X SET pk = 72 , filler = REPEAT ( ' X ' , 69 ) WHERE X . int_key < 46
ORDER BY RAND ( ) LIMIT 20;
+UPDATE A AS X SET int_key = ( SELECT AVG( int_nokey ) FROM ( SELECT AVG( pk ) FROM E AS X
WHERE X . int_key < 87 LIMIT 20 ) AS X WHERE X . pk < 14 LIMIT 1 ) , filler = REPEAT
( ' X ' , ( SELECT int_key FROM A AS X WHERE X . int_nokey < 66 LIMIT 1 ) ) WHERE X .
int_nokey < 24 ORDER BY RAND ( ) LIMIT 20;
+UPDATE C AS X SET int_nokey = ( SELECT AVG( int_nokey ) FROM B AS X WHERE X . pk < 83
GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM A
AS X WHERE X . pk < 58 LIMIT 1 ) ) WHERE X . int_nokey < 23 ORDER BY RAND ( ) LIMIT
20;
+UPDATE B AS X SET int_key = ( SELECT COUNT( pk ) FROM D AS X WHERE X . int_nokey < 79
GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( int_key ) FROM D
AS X LEFT JOIN A AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . pk < 7 GROUP BY
pk LIMIT 1 ) ) WHERE X . int_nokey < 82 ORDER BY RAND ( ) LIMIT 20;
+UPDATE B AS X SET int_nokey = 8 , filler = REPEAT ( ' X ' , 91 ) WHERE X . pk < 40
ORDER BY RAND ( ) LIMIT 20;
+UPDATE B AS X SET int_nokey = ( SELECT AVG( pk ) FROM E AS X LEFT JOIN B AS Y ON ( X .
int_nokey = Y . int_nokey ) WHERE X . int_key < 21 LIMIT 1 ) , filler = REPEAT ( ' X '
, ( SELECT AVG( pk ) FROM A AS X LEFT JOIN A AS Y ON ( X . int_key = Y . int_key ) WHERE X
. int_key < 89 LIMIT 1 ) ) WHERE X . int_nokey < 68 ORDER BY RAND ( ) LIMIT 20;
+UPDATE A AS X SET pk = ( SELECT AVG( int_key ) FROM E AS X LEFT JOIN D AS Y ON ( X .
int_nokey = Y . pk ) WHERE X . pk < 34 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT
int_key FROM ( SELECT COUNT( int_key ) FROM C AS X LEFT JOIN B AS Y ON ( X . pk = Y . pk
) WHERE X . pk < 36 LIMIT 20 ) AS X WHERE X . int_key < 89 LIMIT 1 ) ) WHERE X .
int_key < 87 ORDER BY RAND ( ) LIMIT 20;
+UPDATE D AS X SET int_key = ( SELECT 24 FROM D AS X LEFT JOIN D AS Y ON ( X . int_key = Y
. pk ) WHERE X . int_key < 3 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT COUNT(
int_nokey ) FROM E AS X LEFT JOIN D AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk
< 61 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 22 ORDER BY RAND ( )
LIMIT 20;
+INSERT INTO A ( int_key , int_nokey ) VALUES ( 74 , ( SELECT COUNT( int_nokey ) FROM D AS
X LEFT JOIN C AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 86 GROUP BY
int_nokey LIMIT 1 ) );
+INSERT INTO A ( int_key , int_nokey ) VALUES ( 80 , ( SELECT ( SELECT AVG( pk ) FROM E AS
X LEFT JOIN D AS Y ON ( X . int_nokey = Y . pk ) WHERE X . int_key < 44 LIMIT 1 ) FROM
( SELECT COUNT( int_key ) FROM E AS X WHERE X . pk < 85 GROUP BY int_nokey LIMIT 20 )
AS X WHERE X . pk < 24 LIMIT 1 ) );
+UPDATE C AS X SET pk = 79 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_key ) FROM B AS X
WHERE X . int_nokey < 97 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . pk < 85 ORDER BY
RAND ( ) LIMIT 20;
+INSERT INTO E ( int_key , int_nokey ) VALUES ( ( SELECT int_key FROM D AS X LEFT JOIN C
AS Y ON ( X . pk = Y . pk ) WHERE X . pk < 35 GROUP BY pk LIMIT 1 ) , ( SELECT AVG(
int_nokey ) FROM C AS X WHERE X . int_key < 27 LIMIT 1 ) );
+UPDATE C AS X SET int_key = 49 , filler = REPEAT ( ' X ' , 8 ) WHERE X . pk < 29 ORDER
BY RAND ( ) LIMIT 20;
+UPDATE B AS X SET int_key = 46 , filler = REPEAT ( ' X ' , ( SELECT int_key FROM B AS X
WHERE X . int_key < 97 LIMIT 1 ) ) WHERE X . int_key < 90 ORDER BY RAND ( ) LIMIT
20;
+INSERT INTO D ( int_key , int_nokey ) VALUES ( 98 , 25 );
+INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( pk ) FROM E AS X LEFT JOIN
C AS Y ON ( X . int_key = Y . int_key ) WHERE X . int_nokey < 1 LIMIT 1 ) , 35 );
+UPDATE A AS X SET int_nokey = ( SELECT AVG( pk ) FROM ( SELECT pk FROM C AS X LEFT JOIN D
AS Y ON ( X . pk = Y . int_key ) WHERE X . int_nokey < 23 GROUP BY int_key LIMIT 20 )
AS X WHERE X . int_nokey < 56 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG(
int_key ) FROM ( SELECT AVG( int_key ) FROM C AS X LEFT JOIN B AS Y ON ( X . int_key = Y
. int_key ) WHERE X . pk < 7 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey <
92 LIMIT 1 ) ) WHERE X . int_nokey < 22 ORDER BY RAND ( ) LIMIT 20;
+INSERT INTO B ( int_key , int_nokey ) VALUES ( 23 , ( SELECT AVG( int_nokey ) FROM E AS X
LEFT JOIN A AS Y ON ( X . pk = Y . int_key ) WHERE X . pk < 88 LIMIT 1 ) );
+INSERT INTO E ( int_key , int_nokey ) VALUES ( 43 , 42 );
+ROLLBACK;
+UPDATE E AS X SET int_nokey = ( SELECT 98 FROM A AS X LEFT JOIN B AS Y ON ( X . pk = Y .
int_key ) WHERE X . pk < 60 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 52
) WHERE X . int_nokey < 57 ORDER BY RAND ( ) LIMIT 20;
+INSERT INTO B ( int_key , int_nokey ) VALUES ( 97 , ( SELECT AVG( int_key ) FROM ( SELECT
COUNT( int_key ) FROM A AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_key ) WHERE X . pk
< 9 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 5 GROUP BY pk LIMIT 1 )
);
+UPDATE C AS X SET int_nokey = 33 , filler = REPEAT ( ' X ' , ( SELECT ( SELECT AVG( pk )
FROM C AS X LEFT JOIN B AS Y ON ( X . int_nokey = Y . pk ) WHERE X . int_nokey < 82
GROUP BY pk LIMIT 1 ) FROM C AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X
. pk < 3 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 85 ORDER BY RAND ( )
LIMIT 20;
+INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_nokey ) FROM B AS X
LEFT JOIN A AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 60 LIMIT 1
) , ( SELECT 92 FROM C AS X LEFT JOIN C AS Y ON ( X . int_key = Y . int_nokey ) WHERE X .
int_key < 1 LIMIT 1 ) );
+UPDATE A AS X SET pk = 84 , filler = REPEAT ( ' X ' , 59 ) WHERE X . int_key < 36
ORDER BY RAND ( ) LIMIT 20;
+UPDATE D AS X SET pk = 80 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM B AS
X WHERE X . int_key < 82 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_key < 70 ORDER
BY RAND ( ) LIMIT 20;
+COMMIT;
+START TRANSACTION;
+UPDATE B AS X SET int_key = 0 , filler = REPEAT ( ' X ' , 69 ) WHERE X . int_nokey < 2
ORDER BY RAND ( ) LIMIT 20;
+UPDATE D AS X SET pk = ( SELECT COUNT( pk ) FROM D AS X LEFT JOIN A AS Y ON ( X .
int_nokey = Y . int_nokey ) WHERE X . pk < 71 GROUP BY pk LIMIT 1 ) , filler = REPEAT
( ' X ' , 50 ) WHERE X . int_nokey < 96 ORDER BY RAND ( ) LIMIT 20;
+UPDATE A AS X SET pk = 38 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_nokey ) FROM (
SELECT COUNT( int_key ) FROM E AS X WHERE X . int_key < 98 LIMIT 20 ) AS X WHERE X .
int_nokey < 58 LIMIT 1 ) ) WHERE X . pk < 28 ORDER BY RAND ( ) LIMIT 20;
+UPDATE A AS X SET pk = 87 , filler = REPEAT ( ' X ' , 66 ) WHERE X . pk < 40 ORDER BY
RAND ( ) LIMIT 20;
+UPDATE C AS X SET int_key = ( SELECT pk FROM D AS X LEFT JOIN C AS Y ON ( X . int_key = Y
. pk ) WHERE X . int_nokey < 90 GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X '
, 90 ) WHERE X . int_nokey < 51 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET int_key = 41 , filler = REPEAT ( ' X ' , 49 ) WHERE X . int_nokey <
38 ORDER BY RAND ( ) LIMIT 20;
+UPDATE D AS X SET pk = 84 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM A AS
X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 60 LIMIT
1 ) ) WHERE X . int_key < 94 ORDER BY RAND ( ) LIMIT 20;
+UPDATE A AS X SET int_key = ( SELECT int_nokey FROM A AS X LEFT JOIN D AS Y ON ( X . pk =
Y . pk ) WHERE X . int_nokey < 47 GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , (
SELECT AVG( int_key ) FROM A AS X WHERE X . pk < 85 GROUP BY int_key LIMIT 1 ) ) WHERE
X . int_nokey < 79 ORDER BY RAND ( ) LIMIT 20;
+UPDATE D AS X SET pk = ( SELECT COUNT( int_key ) FROM B AS X LEFT JOIN C AS Y ON ( X . pk
= Y . int_key ) WHERE X . int_nokey < 64 LIMIT 1 ) , filler = REPEAT ( ' X ' , 0 )
WHERE X . pk < 74 ORDER BY RAND ( ) LIMIT 20;
+INSERT INTO E ( int_key , int_nokey ) VALUES ( ( SELECT AVG( int_nokey ) FROM B AS X
WHERE X . pk < 97 GROUP BY int_nokey LIMIT 1 ) , ( SELECT ( SELECT COUNT( int_key )
FROM D AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X . int_key < 83
GROUP BY pk LIMIT 1 ) FROM B AS X WHERE X . pk < 69 LIMIT 1 ) );
+UPDATE E AS X SET int_key = 90 , filler = REPEAT ( ' X ' , ( SELECT ( SELECT int_nokey
FROM C AS X LEFT JOIN C AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 58
LIMIT 1 ) FROM A AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X . pk < 99
GROUP BY int_nokey LIMIT 1 ) ) WHERE X . pk < 54 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET pk = 70 , filler = REPEAT ( ' X ' , 88 ) WHERE X . int_key < 74
ORDER BY RAND ( ) LIMIT 20;
+INSERT INTO A ( int_key , int_nokey ) VALUES ( 2 , 96 );
+UPDATE A AS X SET int_nokey = 76 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_key )
FROM A AS X WHERE X . int_nokey < 56 GROUP BY int_nokey LIMIT 1 ) ) WHERE X .
int_nokey < 76 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET int_key = 93 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_key ) FROM
A AS X WHERE X . int_nokey < 77 GROUP BY pk LIMIT 1 ) ) WHERE X . pk < 66 ORDER BY
RAND ( ) LIMIT 20;
+INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT int_key FROM ( SELECT pk FROM (
SELECT int_nokey FROM A AS X LEFT JOIN B AS Y ON ( X . int_nokey = Y . int_key ) WHERE X
. int_nokey < 63 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 88 GROUP BY
int_key LIMIT 20 ) AS X WHERE X . int_key < 77 LIMIT 1 ) , ( SELECT COUNT( int_key )
FROM A AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey
< 67 GROUP BY int_key LIMIT 1 ) );
+UPDATE E AS X SET pk = ( SELECT COUNT( int_nokey ) FROM B AS X LEFT JOIN D AS Y ON ( X .
pk = Y . int_nokey ) WHERE X . int_key < 74 GROUP BY int_nokey LIMIT 1 ) , filler =
REPEAT ( ' X ' , ( SELECT ( SELECT pk FROM ( SELECT int_key FROM A AS X LEFT JOIN D AS Y
ON ( X . int_key = Y . pk ) WHERE X . pk < 62 GROUP BY pk LIMIT 20 ) AS X WHERE X .
int_nokey < 11 GROUP BY int_key LIMIT 1 ) FROM B AS X LEFT JOIN D AS Y ON ( X .
int_nokey = Y . pk ) WHERE X . int_key < 10 LIMIT 1 ) ) WHERE X . int_key < 92
ORDER BY RAND ( ) LIMIT 20;
+START TRANSACTION;
+ROLLBACK;
+UPDATE E AS X SET int_nokey = 90 , filler = REPEAT ( ' X ' , 71 ) WHERE X . int_nokey
< 83 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET pk = ( SELECT AVG( int_nokey ) FROM B AS X LEFT JOIN C AS Y ON ( X .
int_key = Y . int_nokey ) WHERE X . int_key < 74 LIMIT 1 ) , filler = REPEAT ( ' X ' ,
11 ) WHERE X . int_key < 23 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET int_key = 94 , filler = REPEAT ( ' X ' , ( SELECT 62 FROM ( SELECT 21
FROM C AS X WHERE X . int_key < 83 LIMIT 20 ) AS X WHERE X . int_nokey < 40 GROUP
BY int_key LIMIT 1 ) ) WHERE X . pk < 48 ORDER BY RAND ( ) LIMIT 20;
+ROLLBACK;
+INSERT INTO A ( int_key , int_nokey ) VALUES ( 93 , 97 );
+UPDATE A AS X SET int_nokey = 53 , filler = REPEAT ( ' X ' , 67 ) WHERE X . int_nokey
< 4 ORDER BY RAND ( ) LIMIT 20;
+UPDATE C AS X SET int_nokey = 65 , filler = REPEAT ( ' X ' , 33 ) WHERE X . int_nokey
< 31 ORDER BY RAND ( ) LIMIT 20;
+INSERT INTO E ( int_key , int_nokey ) VALUES ( 17 , ( SELECT AVG( int_nokey ) FROM E AS X
LEFT JOIN E AS Y ON ( X . int_key = Y . int_key ) WHERE X . int_key < 90 GROUP BY
int_nokey LIMIT 1 ) );
+ROLLBACK;
+UPDATE E AS X SET int_key = ( SELECT pk FROM D AS X WHERE X . int_key < 39 LIMIT 1 ) ,
filler = REPEAT ( ' X ' , 71 ) WHERE X . int_key < 48 ORDER BY RAND ( ) LIMIT 20;
+UPDATE C AS X SET int_key = ( SELECT int_key FROM ( SELECT COUNT( pk ) FROM A AS X WHERE
X . int_key < 42 GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 88 LIMIT 1 ) ,
filler = REPEAT ( ' X ' , ( SELECT COUNT( int_nokey ) FROM D AS X WHERE X . pk < 55
GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_key < 38 ORDER BY RAND ( ) LIMIT 20;
+UPDATE E AS X SET int_nokey = ( SELECT int_key FROM A AS X LEFT JOIN A AS Y ON ( X . pk =
Y . int_nokey ) WHERE X . pk < 25 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X '
, ( SELECT COUNT( pk ) FROM C AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_key )
WHERE X . int_nokey < 3 LIMIT 1 ) ) WHERE X . pk < 33 ORDER BY RAND ( ) LIMIT 20;
+UPDATE B AS X SET int_nokey = ( SELECT AVG( int_nokey ) FROM B AS X LEFT JOIN C AS Y ON (
X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 99 LIMIT 1 ) , filler = REPEAT (
' X ' , 96 ) WHERE X . int_nokey < 5 ORDER BY RAND ( ) LIMIT 20;
+UPDATE C AS X SET int_key = ( SELECT AVG( int_nokey ) FROM E AS X WHERE X . int_nokey
< 69 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 59 ) WHERE X . int_nokey
< 60 ORDER BY RAND ( ) LIMIT 20;
+
+
+
+
+# ----------------------------------------------------- #
+# --- Check                                         --- #
+# ----------------------------------------------------- #
+
+# ----------------------------------------------------- #
+# --- Final cleanup                                 --- #
+# ----------------------------------------------------- #
+DROP TABLE A;
+DROP TABLE B;
+DROP TABLE C;
+DROP TABLE D;
+DROP TABLE E;

=== modified file 'storage/falcon/IndexWalker.cpp'
--- a/storage/falcon/IndexWalker.cpp	2008-05-08 14:21:41 +0000
+++ b/storage/falcon/IndexWalker.cpp	2008-07-08 15:10:55 +0000
@@ -36,6 +36,7 @@ IndexWalker::IndexWalker(Index *idx, Tra
 	parent = NULL;
 	next = NULL;
 	first = true;
+	balance = 0;
 }
 
 IndexWalker::~IndexWalker(void)
Thread
• bzr commit into mysql-6.0-falcon branch (klewis:2741)	Kevin Lewis	9 Jul