1connect master,127.0.0.1,root,,test,$MASTER_MYPORT,; 2connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT,; 3connection master; 4CREATE DATABASE federated; 5connection slave; 6CREATE DATABASE federated; 7connection default; 8SET @OLD_MASTER_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT; 9SET @@GLOBAL.CONCURRENT_INSERT= 0; 10connection slave; 11SET @OLD_SLAVE_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT; 12SET @@GLOBAL.CONCURRENT_INSERT= 0; 13DROP TABLE IF EXISTS federated.t1; 14Warnings: 15Note 1051 Unknown table 'federated.t1' 16CREATE TABLE federated.t1 ( 17`id` int(20) NOT NULL, 18`group` int NOT NULL default 0, 19`a\\b` int NOT NULL default 0, 20`a\\` int NOT NULL default 0, 21`name` varchar(32) NOT NULL default '' 22 ) 23DEFAULT CHARSET=latin1; 24connection master; 25DROP TABLE IF EXISTS federated.t1; 26Warnings: 27Note 1051 Unknown table 'federated.t1' 28CREATE TABLE federated.t1 ( 29`id` int(20) NOT NULL, 30`group` int NOT NULL default 0, 31`a\\b` inT NOT NULL default 0, 32`a\\` int NOT NULL default 0, 33`name` varchar(32) NOT NULL default '' 34 ) 35ENGINE="FEDERATED" DEFAULT CHARSET=latin1 36CONNECTION='mysql://root@127.0.0.1:@/too/many/items/federated/t1'; 37ERROR HY000: Can't create federated table. The data source connection string 'mysql://root@127.0.0.1:@/too/many/items/federated/t1' is not in the correct format 38CREATE TABLE federated.t1 ( 39`id` int(20) NOT NULL, 40`group` int NOT NULL default 0, 41`a\\b` iNt NOT NULL default 0, 42`a\\` int NOT NULL default 0, 43`name` varchar(32) NOT NULL default '' 44 ) 45ENGINE="FEDERATED" DEFAULT CHARSET=latin1 46CONNECTION='mysql://root@127.0.0.1'; 47ERROR HY000: Can't create federated table. The data source connection string 'mysql://root@127.0.0.1' is not in the correct format 48CREATE TABLE federated.t1 ( 49`id` int(20) NOT NULL, 50`group` int NOT NULL default 0, 51`a\\b` iNT NOT NULL default 0, 52`a\\` int NOT NULL default 0, 53`name` varchar(32) NOT NULL default '' 54 ) 55ENGINE="FEDERATED" DEFAULT CHARSET=latin1 56CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t3'; 57ERROR HY000: Can't create federated table. Foreign data src error: database: 'federated' username: 'root' hostname: '127.0.0.1' 58DROP TABLE IF EXISTS federated.t1; 59Warnings: 60Note 1051 Unknown table 'federated.t1' 61CREATE TABLE federated.t1 ( 62`id` int(20) NOT NULL, 63`group` int NOT NULL default 0, 64`a\\b` Int NOT NULL default 0, 65`a\\` int NOT NULL default 0, 66`name` varchar(32) NOT NULL default '' 67 ) 68ENGINE="FEDERATED" DEFAULT CHARSET=latin1 69CONNECTION='mysql://user:pass@127.0.0.1:SLAVE_PORT/federated/t1'; 70ERROR HY000: Can't create federated table. Foreign data src error: database: 'federated' username: 'user' hostname: '127.0.0.1' 71DROP TABLE IF EXISTS federated.t1; 72Warnings: 73Note 1051 Unknown table 'federated.t1' 74CREATE TABLE federated.t1 ( 75`id` int(20) NOT NULL, 76`group` int NOT NULL default 0, 77`a\\b` InT NOT NULL default 0, 78`a\\` int NOT NULL default 0, 79`name` varchar(32) NOT NULL default '' 80 ) 81ENGINE="FEDERATED" DEFAULT CHARSET=latin1 82CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 83INSERT INTO federated.t1 (id, name) VALUES (1, 'foo'); 84INSERT INTO federated.t1 (id, name) VALUES (2, 'fee'); 85INSERT INTO federated.t1 (id, `group`) VALUES (3, 42); 86INSERT INTO federated.t1 (id, `a\\b`) VALUES (4, 23); 87INSERT INTO federated.t1 (id, `a\\`) VALUES (5, 1); 88SELECT * FROM federated.t1; 89id group a\\b a\\ name 901 0 0 0 foo 912 0 0 0 fee 923 42 0 0 934 0 23 0 945 0 0 1 95DELETE FROM federated.t1; 96DROP TABLE federated.t1; 97DROP TABLE IF EXISTS federated.t2; 98Warnings: 99Note 1051 Unknown table 'federated.t2' 100CREATE TABLE federated.t2 ( 101`id` int(20) NOT NULL, 102`name` varchar(32) NOT NULL default '' 103 ) 104ENGINE="FEDERATED" DEFAULT CHARSET=latin1 105CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 106SHOW CREATE TABLE federated.t2; 107Table Create Table 108t2 CREATE TABLE `t2` ( 109 `id` int(20) NOT NULL, 110 `name` varchar(32) NOT NULL DEFAULT '' 111) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 112INSERT INTO federated.t2 (id, name) VALUES (1, 'foo'); 113INSERT INTO federated.t2 (id, name) VALUES (2, 'fee'); 114SELECT * FROM federated.t2 ORDER BY id, name; 115id name 1161 foo 1172 fee 118DROP TABLE federated.t2; 119connection slave; 120DROP TABLE IF EXISTS federated.t1; 121DROP TABLE IF EXISTS federated.`t1%`; 122Warnings: 123Note 1051 Unknown table 'federated.t1%' 124CREATE TABLE federated.`t1%` ( 125`id` int(20) NOT NULL, 126`name` varchar(32) NOT NULL default '' 127 ) 128DEFAULT CHARSET=latin1; 129connection master; 130DROP TABLE IF EXISTS federated.t1; 131Warnings: 132Note 1051 Unknown table 'federated.t1' 133CREATE TABLE federated.t1 ( 134`id` int(20) NOT NULL, 135`name` varchar(32) NOT NULL default '' 136 ) 137ENGINE="FEDERATED" DEFAULT CHARSET=latin1 138CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1%'; 139INSERT INTO federated.t1 (id, name) VALUES (1, 'foo'); 140INSERT INTO federated.t1 (id, name) VALUES (2, 'fee'); 141SELECT * FROM federated.t1 ORDER BY id,name; 142id name 1431 foo 1442 fee 145DELETE FROM federated.t1; 146DROP TABLE IF EXISTS federated.t1; 147CREATE TABLE federated.`t1%` ( 148`id` int(20) NOT NULL, 149`name` varchar(32) NOT NULL default '' 150 ) 151ENGINE="FEDERATED" DEFAULT CHARSET=latin1 152CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1%'; 153INSERT INTO federated.`t1%` (id, name) VALUES (1, 'foo'); 154INSERT INTO federated.`t1%` (id, name) VALUES (2, 'fee'); 155SELECT * FROM federated.`t1%` ORDER BY id, name; 156id name 1571 foo 1582 fee 159DELETE FROM federated.`t1%`; 160DROP TABLE IF EXISTS federated.`t1%`; 161connection slave; 162DROP TABLE IF EXISTS federated.`t1%`; 163DROP TABLE IF EXISTS federated.t1; 164Warnings: 165Note 1051 Unknown table 'federated.t1' 166CREATE TABLE federated.t1 ( 167`id` int(20) NOT NULL auto_increment, 168`name` varchar(32) NOT NULL default '', 169`other` int(20) NOT NULL default '0', 170`created` datetime default '2004-04-04 04:04:04', 171PRIMARY KEY (`id`)) 172DEFAULT CHARSET=latin1; 173connection master; 174CREATE TABLE federated.t1 ( 175`id` int(20) NOT NULL auto_increment, 176`name` varchar(32) NOT NULL default '', 177`other` int(20) NOT NULL default '0', 178`created` datetime default '2004-04-04 04:04:04', 179PRIMARY KEY (`id`)) 180ENGINE="FEDERATED" DEFAULT CHARSET=latin1 181CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 182INSERT INTO federated.t1 (name, other) VALUES ('First Name', 11111); 183INSERT INTO federated.t1 (name, other) VALUES ('Second Name', 22222); 184INSERT INTO federated.t1 (name, other) VALUES ('Third Name', 33333); 185INSERT INTO federated.t1 (name, other) VALUES ('Fourth Name', 44444); 186INSERT INTO federated.t1 (name, other) VALUES ('Fifth Name', 55555); 187INSERT INTO federated.t1 (name, other) VALUES ('Sixth Name', 66666); 188INSERT INTO federated.t1 (name, other) VALUES ('Seventh Name', 77777); 189INSERT INTO federated.t1 (name, other) VALUES ('Eigth Name', 88888); 190INSERT INTO federated.t1 (name, other) VALUES ('Ninth Name', 99999); 191INSERT INTO federated.t1 (name, other) VALUES ('Tenth Name', 101010); 192SELECT * FROM federated.t1; 193id name other created 1941 First Name 11111 2004-04-04 04:04:04 19510 Tenth Name 101010 2004-04-04 04:04:04 1962 Second Name 22222 2004-04-04 04:04:04 1973 Third Name 33333 2004-04-04 04:04:04 1984 Fourth Name 44444 2004-04-04 04:04:04 1995 Fifth Name 55555 2004-04-04 04:04:04 2006 Sixth Name 66666 2004-04-04 04:04:04 2017 Seventh Name 77777 2004-04-04 04:04:04 2028 Eigth Name 88888 2004-04-04 04:04:04 2039 Ninth Name 99999 2004-04-04 04:04:04 204SELECT * FROM federated.t1 WHERE id = 5; 205id name other created 2065 Fifth Name 55555 2004-04-04 04:04:04 207SELECT * FROM federated.t1 WHERE name = 'Sixth Name'; 208id name other created 2096 Sixth Name 66666 2004-04-04 04:04:04 210SELECT * FROM federated.t1 WHERE id = 6 and name = 'Sixth Name'; 211id name other created 2126 Sixth Name 66666 2004-04-04 04:04:04 213SELECT * FROM federated.t1 WHERE name = 'Sixth Name' AND other = 44444; 214id name other created 215SELECT * FROM federated.t1 WHERE name like '%th%'; 216id name other created 21710 Tenth Name 101010 2004-04-04 04:04:04 2183 Third Name 33333 2004-04-04 04:04:04 2194 Fourth Name 44444 2004-04-04 04:04:04 2205 Fifth Name 55555 2004-04-04 04:04:04 2216 Sixth Name 66666 2004-04-04 04:04:04 2227 Seventh Name 77777 2004-04-04 04:04:04 2238 Eigth Name 88888 2004-04-04 04:04:04 2249 Ninth Name 99999 2004-04-04 04:04:04 225UPDATE federated.t1 SET name = '3rd name' WHERE id = 3; 226SELECT * FROM federated.t1 WHERE name = '3rd name'; 227id name other created 2283 3rd name 33333 2004-04-04 04:04:04 229UPDATE federated.t1 SET name = 'Third name' WHERE name = '3rd name'; 230SELECT * FROM federated.t1 WHERE name = 'Third name'; 231id name other created 2323 Third name 33333 2004-04-04 04:04:04 233SELECT * FROM federated.t1 ORDER BY id DESC; 234id name other created 23510 Tenth Name 101010 2004-04-04 04:04:04 2369 Ninth Name 99999 2004-04-04 04:04:04 2378 Eigth Name 88888 2004-04-04 04:04:04 2387 Seventh Name 77777 2004-04-04 04:04:04 2396 Sixth Name 66666 2004-04-04 04:04:04 2405 Fifth Name 55555 2004-04-04 04:04:04 2414 Fourth Name 44444 2004-04-04 04:04:04 2423 Third name 33333 2004-04-04 04:04:04 2432 Second Name 22222 2004-04-04 04:04:04 2441 First Name 11111 2004-04-04 04:04:04 245SELECT * FROM federated.t1 ORDER BY name; 246id name other created 2478 Eigth Name 88888 2004-04-04 04:04:04 2485 Fifth Name 55555 2004-04-04 04:04:04 2491 First Name 11111 2004-04-04 04:04:04 2504 Fourth Name 44444 2004-04-04 04:04:04 2519 Ninth Name 99999 2004-04-04 04:04:04 2522 Second Name 22222 2004-04-04 04:04:04 2537 Seventh Name 77777 2004-04-04 04:04:04 2546 Sixth Name 66666 2004-04-04 04:04:04 25510 Tenth Name 101010 2004-04-04 04:04:04 2563 Third name 33333 2004-04-04 04:04:04 257SELECT * FROM federated.t1 ORDER BY name DESC; 258id name other created 2593 Third name 33333 2004-04-04 04:04:04 26010 Tenth Name 101010 2004-04-04 04:04:04 2616 Sixth Name 66666 2004-04-04 04:04:04 2627 Seventh Name 77777 2004-04-04 04:04:04 2632 Second Name 22222 2004-04-04 04:04:04 2649 Ninth Name 99999 2004-04-04 04:04:04 2654 Fourth Name 44444 2004-04-04 04:04:04 2661 First Name 11111 2004-04-04 04:04:04 2675 Fifth Name 55555 2004-04-04 04:04:04 2688 Eigth Name 88888 2004-04-04 04:04:04 269SELECT * FROM federated.t1 ORDER BY name ASC; 270id name other created 2718 Eigth Name 88888 2004-04-04 04:04:04 2725 Fifth Name 55555 2004-04-04 04:04:04 2731 First Name 11111 2004-04-04 04:04:04 2744 Fourth Name 44444 2004-04-04 04:04:04 2759 Ninth Name 99999 2004-04-04 04:04:04 2762 Second Name 22222 2004-04-04 04:04:04 2777 Seventh Name 77777 2004-04-04 04:04:04 2786 Sixth Name 66666 2004-04-04 04:04:04 27910 Tenth Name 101010 2004-04-04 04:04:04 2803 Third name 33333 2004-04-04 04:04:04 281SELECT * FROM federated.t1 GROUP BY other; 282id name other created 2831 First Name 11111 2004-04-04 04:04:04 2842 Second Name 22222 2004-04-04 04:04:04 2853 Third name 33333 2004-04-04 04:04:04 2864 Fourth Name 44444 2004-04-04 04:04:04 2875 Fifth Name 55555 2004-04-04 04:04:04 2886 Sixth Name 66666 2004-04-04 04:04:04 2897 Seventh Name 77777 2004-04-04 04:04:04 2908 Eigth Name 88888 2004-04-04 04:04:04 2919 Ninth Name 99999 2004-04-04 04:04:04 29210 Tenth Name 101010 2004-04-04 04:04:04 293DELETE FROM federated.t1 WHERE id = 5; 294SELECT * FROM federated.t1 WHERE id = 5; 295id name other created 296DELETE FROM federated.t1; 297SELECT * FROM federated.t1 WHERE id = 5; 298id name other created 299connection slave; 300DROP TABLE IF EXISTS federated.t1; 301CREATE TABLE federated.t1 ( 302`id` int(20) NOT NULL auto_increment, 303`name` varchar(32) NOT NULL default '', 304`other` int(20) NOT NULL default '0', 305`created` datetime NOT NULL, 306PRIMARY KEY (`id`), 307key name(`name`), 308key other(`other`), 309key created(`created`)) 310DEFAULT CHARSET=latin1; 311connection master; 312DROP TABLE IF EXISTS federated.t1; 313CREATE TABLE federated.t1 ( 314`id` int(20) NOT NULL auto_increment, 315`name` varchar(32) NOT NULL default '', 316`other` int(20) NOT NULL default '0', 317`created` datetime NOT NULL, 318PRIMARY KEY (`id`), 319key name(`name`), 320key other(`other`), 321key created(`created`)) 322ENGINE="FEDERATED" DEFAULT CHARSET=latin1 323CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 324INSERT INTO federated.t1 (name, other, created) 325VALUES ('First Name', 11111, '2004-01-01 01:01:01'); 326INSERT INTO federated.t1 (name, other, created) 327VALUES ('Second Name', 22222, '2004-01-23 02:43:00'); 328INSERT INTO federated.t1 (name, other, created) 329VALUES ('Third Name', 33333, '2004-02-14 02:14:00'); 330INSERT INTO federated.t1 (name, other, created) 331VALUES ('Fourth Name', 44444, '2003-04-05 00:00:00'); 332INSERT INTO federated.t1 (name, other, created) 333VALUES ('Fifth Name', 55555, '2001-02-02 02:02:02'); 334INSERT INTO federated.t1 (name, other, created) 335VALUES ('Sixth Name', 66666, '2005-06-06 15:30:00'); 336INSERT INTO federated.t1 (name, other, created) 337VALUES ('Seventh Name', 77777, '2003-12-12 18:32:00'); 338INSERT INTO federated.t1 (name, other, created) 339VALUES ('Eigth Name', 88888, '2005-03-12 11:00:00'); 340INSERT INTO federated.t1 (name, other, created) 341VALUES ('Ninth Name', 99999, '2005-03-12 11:00:01'); 342INSERT INTO federated.t1 (name, other, created) 343VALUES ('Tenth Name', 101010, '2005-03-12 12:00:01'); 344SELECT * FROM federated.t1; 345id name other created 3461 First Name 11111 2004-01-01 01:01:01 34710 Tenth Name 101010 2005-03-12 12:00:01 3482 Second Name 22222 2004-01-23 02:43:00 3493 Third Name 33333 2004-02-14 02:14:00 3504 Fourth Name 44444 2003-04-05 00:00:00 3515 Fifth Name 55555 2001-02-02 02:02:02 3526 Sixth Name 66666 2005-06-06 15:30:00 3537 Seventh Name 77777 2003-12-12 18:32:00 3548 Eigth Name 88888 2005-03-12 11:00:00 3559 Ninth Name 99999 2005-03-12 11:00:01 356SELECT * FROM federated.t1 WHERE id = 5; 357id name other created 3585 Fifth Name 55555 2001-02-02 02:02:02 359SELECT * FROM federated.t1 WHERE id = 6 and name = 'Sixth Name'; 360id name other created 3616 Sixth Name 66666 2005-06-06 15:30:00 362SELECT * FROM federated.t1 WHERE other = 44444; 363id name other created 3644 Fourth Name 44444 2003-04-05 00:00:00 365SELECT * FROM federated.t1 WHERE name like '%th%'; 366id name other created 36710 Tenth Name 101010 2005-03-12 12:00:01 3683 Third Name 33333 2004-02-14 02:14:00 3694 Fourth Name 44444 2003-04-05 00:00:00 3705 Fifth Name 55555 2001-02-02 02:02:02 3716 Sixth Name 66666 2005-06-06 15:30:00 3727 Seventh Name 77777 2003-12-12 18:32:00 3738 Eigth Name 88888 2005-03-12 11:00:00 3749 Ninth Name 99999 2005-03-12 11:00:01 375UPDATE federated.t1 SET name = '3rd name' WHERE id = 3; 376SELECT * FROM federated.t1 WHERE name = '3rd name'; 377id name other created 3783 3rd name 33333 2004-02-14 02:14:00 379UPDATE federated.t1 SET name = 'Third name' WHERE name = '3rd name'; 380SELECT * FROM federated.t1 WHERE name = 'Third name'; 381id name other created 3823 Third name 33333 2004-02-14 02:14:00 383SELECT * FROM federated.t1 ORDER BY id DESC; 384id name other created 38510 Tenth Name 101010 2005-03-12 12:00:01 3869 Ninth Name 99999 2005-03-12 11:00:01 3878 Eigth Name 88888 2005-03-12 11:00:00 3887 Seventh Name 77777 2003-12-12 18:32:00 3896 Sixth Name 66666 2005-06-06 15:30:00 3905 Fifth Name 55555 2001-02-02 02:02:02 3914 Fourth Name 44444 2003-04-05 00:00:00 3923 Third name 33333 2004-02-14 02:14:00 3932 Second Name 22222 2004-01-23 02:43:00 3941 First Name 11111 2004-01-01 01:01:01 395SELECT * FROM federated.t1 ORDER BY name; 396id name other created 3978 Eigth Name 88888 2005-03-12 11:00:00 3985 Fifth Name 55555 2001-02-02 02:02:02 3991 First Name 11111 2004-01-01 01:01:01 4004 Fourth Name 44444 2003-04-05 00:00:00 4019 Ninth Name 99999 2005-03-12 11:00:01 4022 Second Name 22222 2004-01-23 02:43:00 4037 Seventh Name 77777 2003-12-12 18:32:00 4046 Sixth Name 66666 2005-06-06 15:30:00 40510 Tenth Name 101010 2005-03-12 12:00:01 4063 Third name 33333 2004-02-14 02:14:00 407SELECT * FROM federated.t1 ORDER BY name DESC; 408id name other created 4093 Third name 33333 2004-02-14 02:14:00 41010 Tenth Name 101010 2005-03-12 12:00:01 4116 Sixth Name 66666 2005-06-06 15:30:00 4127 Seventh Name 77777 2003-12-12 18:32:00 4132 Second Name 22222 2004-01-23 02:43:00 4149 Ninth Name 99999 2005-03-12 11:00:01 4154 Fourth Name 44444 2003-04-05 00:00:00 4161 First Name 11111 2004-01-01 01:01:01 4175 Fifth Name 55555 2001-02-02 02:02:02 4188 Eigth Name 88888 2005-03-12 11:00:00 419SELECT * FROM federated.t1 ORDER BY name ASC; 420id name other created 4218 Eigth Name 88888 2005-03-12 11:00:00 4225 Fifth Name 55555 2001-02-02 02:02:02 4231 First Name 11111 2004-01-01 01:01:01 4244 Fourth Name 44444 2003-04-05 00:00:00 4259 Ninth Name 99999 2005-03-12 11:00:01 4262 Second Name 22222 2004-01-23 02:43:00 4277 Seventh Name 77777 2003-12-12 18:32:00 4286 Sixth Name 66666 2005-06-06 15:30:00 42910 Tenth Name 101010 2005-03-12 12:00:01 4303 Third name 33333 2004-02-14 02:14:00 431SELECT * FROM federated.t1 GROUP BY other; 432id name other created 4331 First Name 11111 2004-01-01 01:01:01 4342 Second Name 22222 2004-01-23 02:43:00 4353 Third name 33333 2004-02-14 02:14:00 4364 Fourth Name 44444 2003-04-05 00:00:00 4375 Fifth Name 55555 2001-02-02 02:02:02 4386 Sixth Name 66666 2005-06-06 15:30:00 4397 Seventh Name 77777 2003-12-12 18:32:00 4408 Eigth Name 88888 2005-03-12 11:00:00 4419 Ninth Name 99999 2005-03-12 11:00:01 44210 Tenth Name 101010 2005-03-12 12:00:01 443DELETE FROM federated.t1 WHERE id = 5; 444SELECT * FROM federated.t1 WHERE id = 5; 445id name other created 446DELETE FROM federated.t1; 447SELECT * FROM federated.t1 WHERE id = 5; 448id name other created 449connection slave; 450DROP TABLE IF EXISTS federated.t1; 451CREATE TABLE federated.t1 ( 452`id` int(20) NOT NULL auto_increment, 453`name` varchar(32), 454`other` varchar(20), 455PRIMARY KEY (`id`) ); 456connection master; 457DROP TABLE IF EXISTS federated.t1; 458CREATE TABLE federated.t1 ( 459`id` int(20) NOT NULL auto_increment, 460`name` varchar(32), 461`other` varchar(20), 462PRIMARY KEY (`id`) ) 463ENGINE="FEDERATED" 464 DEFAULT CHARSET=latin1 465CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 466INSERT INTO federated.t1 (name, other) VALUES ('First Name', 11111); 467INSERT INTO federated.t1 (name, other) VALUES ('Second Name', NULL); 468INSERT INTO federated.t1 (name, other) VALUES ('Third Name', 33333); 469INSERT INTO federated.t1 (name, other) VALUES (NULL, NULL); 470INSERT INTO federated.t1 (name, other) VALUES ('Fifth Name', 55555); 471INSERT INTO federated.t1 (name, other) VALUES ('Sixth Name', 66666); 472INSERT INTO federated.t1 (name) VALUES ('Seventh Name'); 473INSERT INTO federated.t1 (name, other) VALUES ('Eigth Name', 88888); 474INSERT INTO federated.t1 (name, other) VALUES ('Ninth Name', 99999); 475INSERT INTO federated.t1 (other) VALUES ('fee fie foe fum'); 476SELECT * FROM federated.t1 WHERE other IS NULL; 477id name other 4782 Second Name NULL 4794 NULL NULL 4807 Seventh Name NULL 481SELECT * FROM federated.t1 WHERE name IS NULL; 482id name other 48310 NULL fee fie foe fum 4844 NULL NULL 485SELECT * FROM federated.t1 WHERE name IS NULL and other IS NULL; 486id name other 4874 NULL NULL 488SELECT * FROM federated.t1 WHERE name IS NULL or other IS NULL; 489id name other 49010 NULL fee fie foe fum 4912 Second Name NULL 4924 NULL NULL 4937 Seventh Name NULL 494UPDATE federated.t1 495SET name = 'Fourth Name', other = 'four four four' 496WHERE name IS NULL AND other IS NULL; 497UPDATE federated.t1 SET other = 'two two two two' WHERE name = 'Second Name'; 498UPDATE federated.t1 SET other = 'seven seven' WHERE name like 'Sev%'; 499UPDATE federated.t1 SET name = 'Tenth Name' WHERE other like 'fee fie%'; 500SELECT * FROM federated.t1 WHERE name IS NULL OR other IS NULL ; 501id name other 502SELECT * FROM federated.t1; 503id name other 5041 First Name 11111 50510 Tenth Name fee fie foe fum 5062 Second Name two two two two 5073 Third Name 33333 5084 Fourth Name four four four 5095 Fifth Name 55555 5106 Sixth Name 66666 5117 Seventh Name seven seven 5128 Eigth Name 88888 5139 Ninth Name 99999 514connection slave; 515DROP TABLE IF EXISTS federated.t1; 516CREATE TABLE federated.t1 ( 517`id` int(20) NOT NULL auto_increment, 518`name` varchar(32) NOT NULL DEFAULT '', 519`other` varchar(20) NOT NULL DEFAULT '', 520PRIMARY KEY (`id`), 521KEY nameoth (name, other) ); 522connection master; 523DROP TABLE IF EXISTS federated.t1; 524CREATE TABLE federated.t1 ( 525`id` int(20) NOT NULL auto_increment, 526`name` varchar(32) NOT NULL DEFAULT '', 527`other` varchar(20) NOT NULL DEFAULT '', 528PRIMARY KEY (`id`), 529KEY nameoth (name, other)) 530ENGINE="FEDERATED" DEFAULT 531CHARSET=latin1 532CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 533INSERT INTO federated.t1 (name, other) VALUES ('First Name', '1111'); 534INSERT INTO federated.t1 (name, other) VALUES ('Second Name', '2222'); 535INSERT INTO federated.t1 (name, other) VALUES ('Third Name', '3333'); 536SELECT * FROM federated.t1 WHERE name = 'Second Name'; 537id name other 5382 Second Name 2222 539SELECT * FROM federated.t1 WHERE other = '2222'; 540id name other 5412 Second Name 2222 542SELECT * FROM federated.t1 WHERE name = 'Third Name'; 543id name other 5443 Third Name 3333 545SELECT * FROM federated.t1 WHERE name = 'Third Name' AND other = '3333'; 546id name other 5473 Third Name 3333 548connection slave; 549DROP TABLE IF EXISTS federated.t1; 550CREATE TABLE federated.t1 ( 551`id` int NOT NULL auto_increment, 552`name` char(32) NOT NULL DEFAULT '', 553`bincol` binary(1) NOT NULL, 554`floatval` decimal(5,2) NOT NULL DEFAULT 0.0, 555`other` int NOT NULL DEFAULT 0, 556PRIMARY KEY (id), 557KEY nameoth(name, other), 558KEY bincol(bincol), 559KEY floatval(floatval)); 560connection master; 561DROP TABLE IF EXISTS federated.t1; 562CREATE TABLE federated.t1 ( 563`id` int NOT NULL auto_increment, 564`name` char(32) NOT NULL DEFAULT '', 565`bincol` binary(1) NOT NULL, 566`floatval` decimal(5,2) NOT NULL DEFAULT 0.0, 567`other` int NOT NULL DEFAULT 0, 568PRIMARY KEY (id), 569KEY nameoth(name,other), 570KEY bincol(bincol), 571KEY floatval(floatval)) 572ENGINE="FEDERATED" 573 DEFAULT CHARSET=latin1 574CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 575INSERT INTO federated.t1 (name, bincol, floatval, other) 576VALUES ('first', 0x65, 11.11, 1111); 577INSERT INTO federated.t1 (name, bincol, floatval, other) 578VALUES ('second', 0x66, 22.22, 2222); 579INSERT INTO federated.t1 (name, bincol, floatval, other) 580VALUES ('third', 'g', 22.22, 2222); 581SELECT * FROM federated.t1; 582id name bincol floatval other 5831 first e 11.11 1111 5842 second f 22.22 2222 5853 third g 22.22 2222 586SELECT * FROM federated.t1 WHERE name = 'second'; 587id name bincol floatval other 5882 second f 22.22 2222 589SELECT * FROM federated.t1 WHERE bincol= 'f'; 590id name bincol floatval other 5912 second f 22.22 2222 592SELECT * FROM federated.t1 WHERE bincol= 0x66; 593id name bincol floatval other 5942 second f 22.22 2222 595SELECT * FROM federated.t1 WHERE bincol= 0x67; 596id name bincol floatval other 5973 third g 22.22 2222 598SELECT * FROM federated.t1 WHERE bincol= 'g'; 599id name bincol floatval other 6003 third g 22.22 2222 601SELECT * FROM federated.t1 WHERE floatval=11.11; 602id name bincol floatval other 6031 first e 11.11 1111 604SELECT * FROM federated.t1 WHERE name='third'; 605id name bincol floatval other 6063 third g 22.22 2222 607SELECT * FROM federated.t1 WHERE other=2222; 608id name bincol floatval other 6092 second f 22.22 2222 6103 third g 22.22 2222 611SELECT * FROM federated.t1 WHERE name='third' and other=2222; 612id name bincol floatval other 6133 third g 22.22 2222 614connection slave; 615DROP TABLE IF EXISTS federated.t1; 616CREATE TABLE federated.t1 ( 617`id` int NOT NULL auto_increment, 618`col1` int(10) NOT NULL DEFAULT 0, 619`col2` varchar(64) NOT NULL DEFAULT '', 620`col3` int(20) NOT NULL, 621`col4` int(40) NOT NULL, 622primary key (`id`, `col1`, `col2`, `col3`, `col4`), 623key col1(col1), 624key col2(col2), 625key col3(col3), 626key col4(col4)); 627connection master; 628DROP TABLE IF EXISTS federated.t1; 629CREATE TABLE federated.t1 ( 630`id` int NOT NULL auto_increment, 631`col1` int(10) NOT NULL DEFAULT 0, 632`col2` varchar(64) NOT NULL DEFAULT '', 633`col3` int(20) NOT NULL, 634`col4` int(40) NOT NULL, 635primary key (`id`, `col1`, `col2`, `col3`, `col4`), 636key col1(col1), 637key col2(col2), 638key col3(col3), 639key col4(col4)) 640ENGINE="FEDERATED" 641 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 642INSERT INTO federated.t1 (col1, col2, col3, col4) 643VALUES (1, 'one One', 11, 1111); 644INSERT INTO federated.t1 (col1, col2, col3, col4) 645VALUES (2, 'Two two', 22, 2222); 646INSERT INTO federated.t1 (col1, col2, col3, col4) 647VALUES (3, 'three Three', 33, 33333); 648INSERT INTO federated.t1 (col1, col2, col3, col4) 649VALUES (4, 'fourfourfour', 444, 4444444); 650INSERT INTO federated.t1 (col1, col2, col3, col4) 651VALUES (5, 'five 5 five five 5', 5, 55555); 652INSERT INTO federated.t1 (col1, col2, col3, col4) 653VALUES (6, 'six six Sixsix', 6666, 6); 654INSERT INTO federated.t1 (col1, col2, col3, col4) 655VALUES (7, 'seven Sevenseven', 77777, 7777); 656INSERT INTO federated.t1 (col1, col2, col3, col4) 657VALUES (8, 'eight eight eight', 88888, 88); 658INSERT INTO federated.t1 (col1, col2, col3, col4) 659VALUES (9, 'nine Nine', 999999, 999999); 660INSERT INTO federated.t1 (col1, col2, col3, col4) 661VALUES (10, 'Tenth ten TEN', 1010101, 1010); 662SELECT * FROM federated.t1 WHERE col2 = 'two two'; 663id col1 col2 col3 col4 6642 2 Two two 22 2222 665SELECT * FROM federated.t1 WHERE col2 = 'two Two'; 666id col1 col2 col3 col4 6672 2 Two two 22 2222 668SELECT * FROM federated.t1 WHERE id = 3; 669id col1 col2 col3 col4 6703 3 three Three 33 33333 671SELECT * FROM federated.t1 WHERE id = 3 AND col1 = 3; 672id col1 col2 col3 col4 6733 3 three Three 33 33333 674SELECT * FROM federated.t1 WHERE id = 4 AND col1 = 4 AND col2 = 'Two two'; 675id col1 col2 col3 col4 676SELECT * FROM federated.t1 WHERE id = 4 AND col1 = 4 AND col2 = 'fourfourfour'; 677id col1 col2 col3 col4 6784 4 fourfourfour 444 4444444 679SELECT * FROM federated.t1 WHERE id = 5 AND col2 = 'five 5 five five 5' 680AND col3 = 5; 681id col1 col2 col3 col4 6825 5 five 5 five five 5 5 55555 683SELECT * FROM federated.t1 WHERE id = 5 AND col2 = 'five 5 five five 5' 684AND col3 = 5 685AND col4 = 55555; 686id col1 col2 col3 col4 6875 5 five 5 five five 5 5 55555 688SELECT * FROM federated.t1 WHERE id = 5 689AND col2 = 'Two two' AND col3 = 22 690AND col4 = 33; 691id col1 col2 col3 col4 692SELECT * FROM federated.t1 WHERE id = 5 693AND col2 = 'five 5 five five 5' AND col3 = 5 694AND col4 = 55555; 695id col1 col2 col3 col4 6965 5 five 5 five five 5 5 55555 697SELECT * FROM federated.t1 WHERE (id = 5 AND col2 = 'five 5 five five 5') 698OR (col2 = 'three Three' AND col3 = 33); 699id col1 col2 col3 col4 7003 3 three Three 33 33333 7015 5 five 5 five five 5 5 55555 702SELECT * FROM federated.t1 WHERE (id = 5 AND col2 = 'Two two') 703OR (col2 = 444 AND col3 = 4444444); 704id col1 col2 col3 col4 705SELECT * FROM federated.t1 WHERE id = 1 706OR col1 = 10 707OR col2 = 'Two two' 708OR col3 = 33 709OR col4 = 4444444; 710id col1 col2 col3 col4 7111 1 one One 11 1111 71210 10 Tenth ten TEN 1010101 1010 7132 2 Two two 22 2222 7143 3 three Three 33 33333 7154 4 fourfourfour 444 4444444 716SELECT * FROM federated.t1 WHERE id > 5; 717id col1 col2 col3 col4 71810 10 Tenth ten TEN 1010101 1010 7196 6 six six Sixsix 6666 6 7207 7 seven Sevenseven 77777 7777 7218 8 eight eight eight 88888 88 7229 9 nine Nine 999999 999999 723SELECT * FROM federated.t1 WHERE id >= 5; 724id col1 col2 col3 col4 72510 10 Tenth ten TEN 1010101 1010 7265 5 five 5 five five 5 5 55555 7276 6 six six Sixsix 6666 6 7287 7 seven Sevenseven 77777 7777 7298 8 eight eight eight 88888 88 7309 9 nine Nine 999999 999999 731SELECT * FROM federated.t1 WHERE id < 5; 732id col1 col2 col3 col4 7331 1 one One 11 1111 7342 2 Two two 22 2222 7353 3 three Three 33 33333 7364 4 fourfourfour 444 4444444 737SELECT * FROM federated.t1 WHERE id <= 5; 738id col1 col2 col3 col4 7391 1 one One 11 1111 7402 2 Two two 22 2222 7413 3 three Three 33 33333 7424 4 fourfourfour 444 4444444 7435 5 five 5 five five 5 5 55555 744SELECT * FROM federated.t1 WHERE id != 5; 745id col1 col2 col3 col4 7461 1 one One 11 1111 74710 10 Tenth ten TEN 1010101 1010 7482 2 Two two 22 2222 7493 3 three Three 33 33333 7504 4 fourfourfour 444 4444444 7516 6 six six Sixsix 6666 6 7527 7 seven Sevenseven 77777 7777 7538 8 eight eight eight 88888 88 7549 9 nine Nine 999999 999999 755SELECT * FROM federated.t1 WHERE id > 3 AND id < 7; 756id col1 col2 col3 col4 7574 4 fourfourfour 444 4444444 7585 5 five 5 five five 5 5 55555 7596 6 six six Sixsix 6666 6 760SELECT * FROM federated.t1 WHERE id > 3 AND id <= 7; 761id col1 col2 col3 col4 7624 4 fourfourfour 444 4444444 7635 5 five 5 five five 5 5 55555 7646 6 six six Sixsix 6666 6 7657 7 seven Sevenseven 77777 7777 766SELECT * FROM federated.t1 WHERE id >= 3 AND id <= 7; 767id col1 col2 col3 col4 7683 3 three Three 33 33333 7694 4 fourfourfour 444 4444444 7705 5 five 5 five five 5 5 55555 7716 6 six six Sixsix 6666 6 7727 7 seven Sevenseven 77777 7777 773SELECT * FROM federated.t1 WHERE id < 3 AND id <= 7; 774id col1 col2 col3 col4 7751 1 one One 11 1111 7762 2 Two two 22 2222 777SELECT * FROM federated.t1 WHERE id < 3 AND id > 7; 778id col1 col2 col3 col4 779SELECT * FROM federated.t1 WHERE id < 3 OR id > 7; 780id col1 col2 col3 col4 7811 1 one One 11 1111 78210 10 Tenth ten TEN 1010101 1010 7832 2 Two two 22 2222 7848 8 eight eight eight 88888 88 7859 9 nine Nine 999999 999999 786SELECT * FROM federated.t1 WHERE col2 = 'three Three'; 787id col1 col2 col3 col4 7883 3 three Three 33 33333 789SELECT * FROM federated.t1 WHERE col2 > 'one'; 790id col1 col2 col3 col4 7911 1 one One 11 1111 79210 10 Tenth ten TEN 1010101 1010 7932 2 Two two 22 2222 7943 3 three Three 33 33333 7956 6 six six Sixsix 6666 6 7967 7 seven Sevenseven 77777 7777 797SELECT * FROM federated.t1 WHERE col2 LIKE 's%'; 798id col1 col2 col3 col4 7996 6 six six Sixsix 6666 6 8007 7 seven Sevenseven 77777 7777 801SELECT * FROM federated.t1 WHERE col2 LIKE 'si%'; 802id col1 col2 col3 col4 8036 6 six six Sixsix 6666 6 804SELECT * FROM federated.t1 WHERE col2 LIKE 'se%'; 805id col1 col2 col3 col4 8067 7 seven Sevenseven 77777 7777 807SELECT * FROM federated.t1 WHERE col2 NOT LIKE 'e%'; 808id col1 col2 col3 col4 8091 1 one One 11 1111 81010 10 Tenth ten TEN 1010101 1010 8112 2 Two two 22 2222 8123 3 three Three 33 33333 8134 4 fourfourfour 444 4444444 8145 5 five 5 five five 5 5 55555 8156 6 six six Sixsix 6666 6 8167 7 seven Sevenseven 77777 7777 8179 9 nine Nine 999999 999999 818SELECT * FROM federated.t1 WHERE col2 <> 'one One'; 819id col1 col2 col3 col4 82010 10 Tenth ten TEN 1010101 1010 8212 2 Two two 22 2222 8223 3 three Three 33 33333 8234 4 fourfourfour 444 4444444 8245 5 five 5 five five 5 5 55555 8256 6 six six Sixsix 6666 6 8267 7 seven Sevenseven 77777 7777 8278 8 eight eight eight 88888 88 8289 9 nine Nine 999999 999999 829connection slave; 830DROP TABLE IF EXISTS federated.t1; 831CREATE TABLE federated.t1 ( 832`col1` varchar(8) NOT NULL DEFAULT '', 833`col2` varchar(128) NOT NULL DEFAULT '', 834`col3` varchar(20) NOT NULL DEFAULT '', 835`col4` varchar(40) NOT NULL DEFAULT '', 836primary key (`col1`, `col2`, `col3`, `col4`), 837key 3key(`col2`,`col3`,`col4`), 838key 2key (`col3`,`col4`), 839key col4(col4)); 840connection master; 841DROP TABLE IF EXISTS federated.t1; 842CREATE TABLE federated.t1 ( 843`col1` varchar(8) NOT NULL DEFAULT '', 844`col2` varchar(128) NOT NULL DEFAULT '', 845`col3` varchar(20) NOT NULL DEFAULT '', 846`col4` varchar(40) NOT NULL DEFAULT '', 847primary key (`col1`, `col2`, `col3`, `col4`), 848key 3key(`col2`,`col3`,`col4`), 849key 2key (`col3`,`col4`), 850key col4(col4)) 851ENGINE="FEDERATED" 852 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 853INSERT INTO federated.t1 (col1, col2, col3, col4) 854VALUES ('aaaa', 'aaaaaaaaaaaaaaaaaaa', 'ababababab', 'acacacacacacacac'); 855INSERT INTO federated.t1 (col1, col2, col3, col4) 856VALUES ('bbbb', 'bbbbbbbbbbbbbbbbbbb', 'bababababa', 'bcbcbcbcbcbcbcbc'); 857INSERT INTO federated.t1 (col1, col2, col3, col4) 858VALUES ('cccc', 'ccccccccccccccccccc', 'cacacacaca', 'cbcbcbcbcbcbcbcb'); 859INSERT INTO federated.t1 (col1, col2, col3, col4) 860VALUES ('dddd', 'ddddddddddddddddddd', 'dadadadada', 'dcdcdcdcdcdcdcdc'); 861INSERT INTO federated.t1 (col1, col2, col3, col4) 862VALUES ('eeee', 'eeeeeeeeeeeeeeeeeee', 'eaeaeaeaea', 'ecececececececec'); 863INSERT INTO federated.t1 (col1, col2, col3, col4) 864VALUES ('ffff', 'fffffffffffffffffff', 'fafafafafa', 'fcfcfcfcfcfcfcfc'); 865INSERT INTO federated.t1 (col1, col2, col3, col4) 866VALUES ('gggg', 'ggggggggggggggggggg', 'gagagagaga', 'gcgcgcgcgcgcgcgc'); 867INSERT INTO federated.t1 (col1, col2, col3, col4) 868VALUES ('hhhh', 'hhhhhhhhhhhhhhhhhhh', 'hahahahaha', 'hchchchchchchchc'); 869SELECT * FROM federated.t1 WHERE col1 = 'cccc'; 870col1 col2 col3 col4 871cccc ccccccccccccccccccc cacacacaca cbcbcbcbcbcbcbcb 872SELECT * FROM federated.t1 WHERE col2 = 'eeeeeeeeeeeeeeeeeee'; 873col1 col2 col3 col4 874eeee eeeeeeeeeeeeeeeeeee eaeaeaeaea ecececececececec 875SELECT * FROM federated.t1 WHERE col3 = 'bababababa'; 876col1 col2 col3 col4 877bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 878SELECT * FROM federated.t1 WHERE col1 = 'gggg' AND col2 = 'ggggggggggggggggggg'; 879col1 col2 col3 col4 880gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 881SELECT * FROM federated.t1 WHERE col1 = 'gggg' AND col3 = 'gagagagaga'; 882col1 col2 col3 col4 883gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 884SELECT * FROM federated.t1 WHERE col1 = 'ffff' AND col4 = 'fcfcfcfcfcfcfcfc'; 885col1 col2 col3 col4 886ffff fffffffffffffffffff fafafafafa fcfcfcfcfcfcfcfc 887SELECT * FROM federated.t1 WHERE col1 > 'bbbb'; 888col1 col2 col3 col4 889cccc ccccccccccccccccccc cacacacaca cbcbcbcbcbcbcbcb 890dddd ddddddddddddddddddd dadadadada dcdcdcdcdcdcdcdc 891eeee eeeeeeeeeeeeeeeeeee eaeaeaeaea ecececececececec 892ffff fffffffffffffffffff fafafafafa fcfcfcfcfcfcfcfc 893gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 894hhhh hhhhhhhhhhhhhhhhhhh hahahahaha hchchchchchchchc 895SELECT * FROM federated.t1 WHERE col1 >= 'bbbb'; 896col1 col2 col3 col4 897bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 898cccc ccccccccccccccccccc cacacacaca cbcbcbcbcbcbcbcb 899dddd ddddddddddddddddddd dadadadada dcdcdcdcdcdcdcdc 900eeee eeeeeeeeeeeeeeeeeee eaeaeaeaea ecececececececec 901ffff fffffffffffffffffff fafafafafa fcfcfcfcfcfcfcfc 902gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 903hhhh hhhhhhhhhhhhhhhhhhh hahahahaha hchchchchchchchc 904SELECT * FROM federated.t1 WHERE col1 < 'bbbb'; 905col1 col2 col3 col4 906aaaa aaaaaaaaaaaaaaaaaaa ababababab acacacacacacacac 907SELECT * FROM federated.t1 WHERE col1 <= 'bbbb'; 908col1 col2 col3 col4 909aaaa aaaaaaaaaaaaaaaaaaa ababababab acacacacacacacac 910bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 911SELECT * FROM federated.t1 WHERE col1 <> 'bbbb'; 912col1 col2 col3 col4 913aaaa aaaaaaaaaaaaaaaaaaa ababababab acacacacacacacac 914cccc ccccccccccccccccccc cacacacaca cbcbcbcbcbcbcbcb 915dddd ddddddddddddddddddd dadadadada dcdcdcdcdcdcdcdc 916eeee eeeeeeeeeeeeeeeeeee eaeaeaeaea ecececececececec 917ffff fffffffffffffffffff fafafafafa fcfcfcfcfcfcfcfc 918gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 919hhhh hhhhhhhhhhhhhhhhhhh hahahahaha hchchchchchchchc 920SELECT * FROM federated.t1 WHERE col1 LIKE 'b%'; 921col1 col2 col3 col4 922bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 923SELECT * FROM federated.t1 WHERE col4 LIKE '%b%'; 924col1 col2 col3 col4 925bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 926cccc ccccccccccccccccccc cacacacaca cbcbcbcbcbcbcbcb 927SELECT * FROM federated.t1 WHERE col1 NOT LIKE 'c%'; 928col1 col2 col3 col4 929aaaa aaaaaaaaaaaaaaaaaaa ababababab acacacacacacacac 930bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 931dddd ddddddddddddddddddd dadadadada dcdcdcdcdcdcdcdc 932eeee eeeeeeeeeeeeeeeeeee eaeaeaeaea ecececececececec 933ffff fffffffffffffffffff fafafafafa fcfcfcfcfcfcfcfc 934gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 935hhhh hhhhhhhhhhhhhhhhhhh hahahahaha hchchchchchchchc 936SELECT * FROM federated.t1 WHERE col4 NOT LIKE '%c%'; 937col1 col2 col3 col4 938connection slave; 939DROP TABLE IF EXISTS federated.t1; 940CREATE TABLE federated.t1 ( 941`col1` varchar(8) NOT NULL DEFAULT '', 942`col2` int(8) NOT NULL DEFAULT 0, 943`col3` varchar(8) NOT NULL DEFAULT '', 944primary key (`col1`, `col2`, `col3`)); 945connection master; 946DROP TABLE IF EXISTS federated.t1; 947CREATE TABLE federated.t1 ( 948`col1` varchar(8) NOT NULL DEFAULT '', 949`col2` varchar(8) NOT NULL DEFAULT '', 950`col3` varchar(8) NOT NULL DEFAULT '', 951primary key (`col1`, `col2`, `col3`)) 952ENGINE="FEDERATED" 953 DEFAULT CHARSET=latin1 954CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 955INSERT INTO federated.t1 VALUES ('a00', '110', 'cc0'); 956INSERT INTO federated.t1 VALUES ('aaa', '111', 'ccc'); 957INSERT INTO federated.t1 VALUES ('bbb', '222', 'yyy'); 958INSERT INTO federated.t1 VALUES ('ccc', '111', 'zzz'); 959INSERT INTO federated.t1 VALUES ('ccd', '112', 'zzzz'); 960connection slave; 961SELECT col3 FROM federated.t1 WHERE ( 962(col1 = 'aaa' AND col2 >= '111') OR col1 > 'aaa') AND 963(col1 < 'ccc' OR ( col1 = 'ccc' AND col2 <= '111')); 964col3 965ccc 966yyy 967zzz 968connection master; 969SELECT col3 FROM federated.t1 WHERE ( 970(col1 = 'aaa' AND col2 >= '111') OR col1 > 'aaa') AND 971(col1 < 'ccc' OR ( col1 = 'ccc' AND col2 <= '111')); 972col3 973ccc 974yyy 975zzz 976connection slave; 977DROP TABLE IF EXISTS federated.t1; 978CREATE TABLE federated.t1 ( 979`id` int, 980`name` varchar(32), 981`floatval` float, 982`other` int) 983DEFAULT CHARSET=latin1; 984connection master; 985DROP TABLE IF EXISTS federated.t1; 986CREATE TABLE federated.t1 ( 987`id` int, 988`name` varchar(32), 989`floatval` float, 990`other` int) 991ENGINE="FEDERATED" 992DEFAULT CHARSET=latin1 993CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 994INSERT INTO federated.t1 values (NULL, NULL, NULL, NULL); 995INSERT INTO federated.t1 values (); 996INSERT INTO federated.t1 (id) VALUES (1); 997INSERT INTO federated.t1 (name, floatval, other) 998VALUES ('foo', 33.33333332, NULL); 999INSERT INTO federated.t1 (name, floatval, other) 1000VALUES (0, 00.3333, NULL); 1001SELECT * FROM federated.t1; 1002id name floatval other 10031 NULL NULL NULL 1004NULL 0 0.3333 NULL 1005NULL NULL NULL NULL 1006NULL NULL NULL NULL 1007NULL foo 33.3333 NULL 1008SELECT count(*) FROM federated.t1 1009WHERE id IS NULL 1010AND name IS NULL 1011AND floatval IS NULL 1012AND other IS NULL; 1013count(*) 10142 1015connection slave; 1016DROP TABLE IF EXISTS federated.t1; 1017CREATE TABLE federated.t1 ( 1018`blurb_id` int NOT NULL DEFAULT 0, 1019`blurb` text default '', 1020PRIMARY KEY (blurb_id)) 1021DEFAULT CHARSET=latin1; 1022connection master; 1023DROP TABLE IF EXISTS federated.t1; 1024CREATE TABLE federated.t1 ( 1025`blurb_id` int NOT NULL DEFAULT 0, 1026`blurb` text default '', 1027PRIMARY KEY (blurb_id)) 1028ENGINE="FEDERATED" 1029 DEFAULT CHARSET=latin1 1030CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1031INSERT INTO federated.t1 VALUES (1, " MySQL supports a number of column types in several categories: numeric types, date and time types, and string (character) types. This chapter first gives an overview of these column types, and then provides a more detailed description of the properties of the types in each category, and a summary of the column type storage requirements. The overview is intentionally brief. The more detailed descriptions should be consulted for additional information about particular column types, such as the allowable formats in which you can specify values."); 1032INSERT INTO federated.t1 VALUES (2, "All arithmetic is done using signed BIGINT or DOUBLE values, so you should not use unsigned big integers larger than 9223372036854775807 (63 bits) except with bit functions! If you do that, some of the last digits in the result may be wrong because of rounding errors when converting a BIGINT value to a DOUBLE."); 1033INSERT INTO federated.t1 VALUES (3, " A floating-point number. p represents the precision. It can be from 0 to 24 for a single-precision floating-point number and from 25 to 53 for a double-precision floating-point number. These types are like the FLOAT and DOUBLE types described immediately following. FLOAT(p) has the same range as the corresponding FLOAT and DOUBLE types, but the display size and number of decimals are undefined. "); 1034INSERT INTO federated.t1 VALUES(4, "Die �bersetzung einer so umfangreichen technischen Dokumentation wie des MySQL-Referenzhandbuchs ist schon eine besondere Herausforderung. Zumindest f�r jemanden, der seine Zielsprache ernst nimmt:"); 1035SELECT * FROM federated.t1; 1036blurb_id blurb 10371 MySQL supports a number of column types in several categories: numeric types, date and time types, and string (character) types. This chapter first gives an overview of these column types, and then provides a more detailed description of the properties of the types in each category, and a summary of the column type storage requirements. The overview is intentionally brief. The more detailed descriptions should be consulted for additional information about particular column types, such as the allowable formats in which you can specify values. 10382 All arithmetic is done using signed BIGINT or DOUBLE values, so you should not use unsigned big integers larger than 9223372036854775807 (63 bits) except with bit functions! If you do that, some of the last digits in the result may be wrong because of rounding errors when converting a BIGINT value to a DOUBLE. 10393 A floating-point number. p represents the precision. It can be from 0 to 24 for a single-precision floating-point number and from 25 to 53 for a double-precision floating-point number. These types are like the FLOAT and DOUBLE types described immediately following. FLOAT(p) has the same range as the corresponding FLOAT and DOUBLE types, but the display size and number of decimals are undefined. 10404 Die �bersetzung einer so umfangreichen technischen Dokumentation wie des MySQL-Referenzhandbuchs ist schon eine besondere Herausforderung. Zumindest f�r jemanden, der seine Zielsprache ernst nimmt: 1041connection slave; 1042DROP TABLE IF EXISTS federated.t1; 1043CREATE TABLE federated.t1 ( 1044`a` int NOT NULL, 1045`b` int NOT NULL, 1046`c` int NOT NULL, 1047PRIMARY KEY (a),key(b)); 1048connection master; 1049DROP TABLE IF EXISTS federated.t1; 1050CREATE TABLE federated.t1 ( 1051`a` int NOT NULL, 1052`b` int NOT NULL, 1053`c` int NOT NULL, 1054PRIMARY KEY (a), 1055KEY (b)) 1056ENGINE="FEDERATED" 1057 DEFAULT CHARSET=latin1 1058CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1059INSERT INTO federated.t1 VALUES (3,3,3),(1,1,1),(2,2,2),(4,4,4); 1060connection slave; 1061DROP TABLE IF EXISTS federated.t1; 1062CREATE TABLE federated.t1 (i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8 1063int, i9 int, i10 int, i11 int, i12 int, i13 int, i14 int, i15 int, i16 int, i17 1064int, i18 int, i19 int, i20 int, i21 int, i22 int, i23 int, i24 int, i25 int, 1065i26 int, i27 int, i28 int, i29 int, i30 int, i31 int, i32 int, i33 int, i34 1066int, i35 int, i36 int, i37 int, i38 int, i39 int, i40 int, i41 int, i42 int, 1067i43 int, i44 int, i45 int, i46 int, i47 int, i48 int, i49 int, i50 int, i51 1068int, i52 int, i53 int, i54 int, i55 int, i56 int, i57 int, i58 int, i59 int, 1069i60 int, i61 int, i62 int, i63 int, i64 int, i65 int, i66 int, i67 int, i68 1070int, i69 int, i70 int, i71 int, i72 int, i73 int, i74 int, i75 int, i76 int, 1071i77 int, i78 int, i79 int, i80 int, i81 int, i82 int, i83 int, i84 int, i85 1072int, i86 int, i87 int, i88 int, i89 int, i90 int, i91 int, i92 int, i93 int, 1073i94 int, i95 int, i96 int, i97 int, i98 int, i99 int, i100 int, i101 int, i102 1074int, i103 int, i104 int, i105 int, i106 int, i107 int, i108 int, i109 int, i110 1075int, i111 int, i112 int, i113 int, i114 int, i115 int, i116 int, i117 int, i118 1076int, i119 int, i120 int, i121 int, i122 int, i123 int, i124 int, i125 int, i126 1077int, i127 int, i128 int, i129 int, i130 int, i131 int, i132 int, i133 int, i134 1078int, i135 int, i136 int, i137 int, i138 int, i139 int, i140 int, i141 int, i142 1079int, i143 int, i144 int, i145 int, i146 int, i147 int, i148 int, i149 int, i150 1080int, i151 int, i152 int, i153 int, i154 int, i155 int, i156 int, i157 int, i158 1081int, i159 int, i160 int, i161 int, i162 int, i163 int, i164 int, i165 int, i166 1082int, i167 int, i168 int, i169 int, i170 int, i171 int, i172 int, i173 int, i174 1083int, i175 int, i176 int, i177 int, i178 int, i179 int, i180 int, i181 int, i182 1084int, i183 int, i184 int, i185 int, i186 int, i187 int, i188 int, i189 int, i190 1085int, i191 int, i192 int, i193 int, i194 int, i195 int, i196 int, i197 int, i198 1086int, i199 int, i200 int, i201 int, i202 int, i203 int, i204 int, i205 int, i206 1087int, i207 int, i208 int, i209 int, i210 int, i211 int, i212 int, i213 int, i214 1088int, i215 int, i216 int, i217 int, i218 int, i219 int, i220 int, i221 int, i222 1089int, i223 int, i224 int, i225 int, i226 int, i227 int, i228 int, i229 int, i230 1090int, i231 int, i232 int, i233 int, i234 int, i235 int, i236 int, i237 int, i238 1091int, i239 int, i240 int, i241 int, i242 int, i243 int, i244 int, i245 int, i246 1092int, i247 int, i248 int, i249 int, i250 int, i251 int, i252 int, i253 int, i254 1093int, i255 int, i256 int, i257 int, i258 int, i259 int, i260 int, i261 int, i262 1094int, i263 int, i264 int, i265 int, i266 int, i267 int, i268 int, i269 int, i270 1095int, i271 int, i272 int, i273 int, i274 int, i275 int, i276 int, i277 int, i278 1096int, i279 int, i280 int, i281 int, i282 int, i283 int, i284 int, i285 int, i286 1097int, i287 int, i288 int, i289 int, i290 int, i291 int, i292 int, i293 int, i294 1098int, i295 int, i296 int, i297 int, i298 int, i299 int, i300 int, i301 int, i302 1099int, i303 int, i304 int, i305 int, i306 int, i307 int, i308 int, i309 int, i310 1100int, i311 int, i312 int, i313 int, i314 int, i315 int, i316 int, i317 int, i318 1101int, i319 int, i320 int, i321 int, i322 int, i323 int, i324 int, i325 int, i326 1102int, i327 int, i328 int, i329 int, i330 int, i331 int, i332 int, i333 int, i334 1103int, i335 int, i336 int, i337 int, i338 int, i339 int, i340 int, i341 int, i342 1104int, i343 int, i344 int, i345 int, i346 int, i347 int, i348 int, i349 int, i350 1105int, i351 int, i352 int, i353 int, i354 int, i355 int, i356 int, i357 int, i358 1106int, i359 int, i360 int, i361 int, i362 int, i363 int, i364 int, i365 int, i366 1107int, i367 int, i368 int, i369 int, i370 int, i371 int, i372 int, i373 int, i374 1108int, i375 int, i376 int, i377 int, i378 int, i379 int, i380 int, i381 int, i382 1109int, i383 int, i384 int, i385 int, i386 int, i387 int, i388 int, i389 int, i390 1110int, i391 int, i392 int, i393 int, i394 int, i395 int, i396 int, i397 int, i398 1111int, i399 int, i400 int, i401 int, i402 int, i403 int, i404 int, i405 int, i406 1112int, i407 int, i408 int, i409 int, i410 int, i411 int, i412 int, i413 int, i414 1113int, i415 int, i416 int, i417 int, i418 int, i419 int, i420 int, i421 int, i422 1114int, i423 int, i424 int, i425 int, i426 int, i427 int, i428 int, i429 int, i430 1115int, i431 int, i432 int, i433 int, i434 int, i435 int, i436 int, i437 int, i438 1116int, i439 int, i440 int, i441 int, i442 int, i443 int, i444 int, i445 int, i446 1117int, i447 int, i448 int, i449 int, i450 int, i451 int, i452 int, i453 int, i454 1118int, i455 int, i456 int, i457 int, i458 int, i459 int, i460 int, i461 int, i462 1119int, i463 int, i464 int, i465 int, i466 int, i467 int, i468 int, i469 int, i470 1120int, i471 int, i472 int, i473 int, i474 int, i475 int, i476 int, i477 int, i478 1121int, i479 int, i480 int, i481 int, i482 int, i483 int, i484 int, i485 int, i486 1122int, i487 int, i488 int, i489 int, i490 int, i491 int, i492 int, i493 int, i494 1123int, i495 int, i496 int, i497 int, i498 int, i499 int, i500 int, i501 int, i502 1124int, i503 int, i504 int, i505 int, i506 int, i507 int, i508 int, i509 int, i510 1125int, i511 int, i512 int, i513 int, i514 int, i515 int, i516 int, i517 int, i518 1126int, i519 int, i520 int, i521 int, i522 int, i523 int, i524 int, i525 int, i526 1127int, i527 int, i528 int, i529 int, i530 int, i531 int, i532 int, i533 int, i534 1128int, i535 int, i536 int, i537 int, i538 int, i539 int, i540 int, i541 int, i542 1129int, i543 int, i544 int, i545 int, i546 int, i547 int, i548 int, i549 int, i550 1130int, i551 int, i552 int, i553 int, i554 int, i555 int, i556 int, i557 int, i558 1131int, i559 int, i560 int, i561 int, i562 int, i563 int, i564 int, i565 int, i566 1132int, i567 int, i568 int, i569 int, i570 int, i571 int, i572 int, i573 int, i574 1133int, i575 int, i576 int, i577 int, i578 int, i579 int, i580 int, i581 int, i582 1134int, i583 int, i584 int, i585 int, i586 int, i587 int, i588 int, i589 int, i590 1135int, i591 int, i592 int, i593 int, i594 int, i595 int, i596 int, i597 int, i598 1136int, i599 int, i600 int, i601 int, i602 int, i603 int, i604 int, i605 int, i606 1137int, i607 int, i608 int, i609 int, i610 int, i611 int, i612 int, i613 int, i614 1138int, i615 int, i616 int, i617 int, i618 int, i619 int, i620 int, i621 int, i622 1139int, i623 int, i624 int, i625 int, i626 int, i627 int, i628 int, i629 int, i630 1140int, i631 int, i632 int, i633 int, i634 int, i635 int, i636 int, i637 int, i638 1141int, i639 int, i640 int, i641 int, i642 int, i643 int, i644 int, i645 int, i646 1142int, i647 int, i648 int, i649 int, i650 int, i651 int, i652 int, i653 int, i654 1143int, i655 int, i656 int, i657 int, i658 int, i659 int, i660 int, i661 int, i662 1144int, i663 int, i664 int, i665 int, i666 int, i667 int, i668 int, i669 int, i670 1145int, i671 int, i672 int, i673 int, i674 int, i675 int, i676 int, i677 int, i678 1146int, i679 int, i680 int, i681 int, i682 int, i683 int, i684 int, i685 int, i686 1147int, i687 int, i688 int, i689 int, i690 int, i691 int, i692 int, i693 int, i694 1148int, i695 int, i696 int, i697 int, i698 int, i699 int, i700 int, i701 int, i702 1149int, i703 int, i704 int, i705 int, i706 int, i707 int, i708 int, i709 int, i710 1150int, i711 int, i712 int, i713 int, i714 int, i715 int, i716 int, i717 int, i718 1151int, i719 int, i720 int, i721 int, i722 int, i723 int, i724 int, i725 int, i726 1152int, i727 int, i728 int, i729 int, i730 int, i731 int, i732 int, i733 int, i734 1153int, i735 int, i736 int, i737 int, i738 int, i739 int, i740 int, i741 int, i742 1154int, i743 int, i744 int, i745 int, i746 int, i747 int, i748 int, i749 int, i750 1155int, i751 int, i752 int, i753 int, i754 int, i755 int, i756 int, i757 int, i758 1156int, i759 int, i760 int, i761 int, i762 int, i763 int, i764 int, i765 int, i766 1157int, i767 int, i768 int, i769 int, i770 int, i771 int, i772 int, i773 int, i774 1158int, i775 int, i776 int, i777 int, i778 int, i779 int, i780 int, i781 int, i782 1159int, i783 int, i784 int, i785 int, i786 int, i787 int, i788 int, i789 int, i790 1160int, i791 int, i792 int, i793 int, i794 int, i795 int, i796 int, i797 int, i798 1161int, i799 int, i800 int, i801 int, i802 int, i803 int, i804 int, i805 int, i806 1162int, i807 int, i808 int, i809 int, i810 int, i811 int, i812 int, i813 int, i814 1163int, i815 int, i816 int, i817 int, i818 int, i819 int, i820 int, i821 int, i822 1164int, i823 int, i824 int, i825 int, i826 int, i827 int, i828 int, i829 int, i830 1165int, i831 int, i832 int, i833 int, i834 int, i835 int, i836 int, i837 int, i838 1166int, i839 int, i840 int, i841 int, i842 int, i843 int, i844 int, i845 int, i846 1167int, i847 int, i848 int, i849 int, i850 int, i851 int, i852 int, i853 int, i854 1168int, i855 int, i856 int, i857 int, i858 int, i859 int, i860 int, i861 int, i862 1169int, i863 int, i864 int, i865 int, i866 int, i867 int, i868 int, i869 int, i870 1170int, i871 int, i872 int, i873 int, i874 int, i875 int, i876 int, i877 int, i878 1171int, i879 int, i880 int, i881 int, i882 int, i883 int, i884 int, i885 int, i886 1172int, i887 int, i888 int, i889 int, i890 int, i891 int, i892 int, i893 int, i894 1173int, i895 int, i896 int, i897 int, i898 int, i899 int, i900 int, i901 int, i902 1174int, i903 int, i904 int, i905 int, i906 int, i907 int, i908 int, i909 int, i910 1175int, i911 int, i912 int, i913 int, i914 int, i915 int, i916 int, i917 int, i918 1176int, i919 int, i920 int, i921 int, i922 int, i923 int, i924 int, i925 int, i926 1177int, i927 int, i928 int, i929 int, i930 int, i931 int, i932 int, i933 int, i934 1178int, i935 int, i936 int, i937 int, i938 int, i939 int, i940 int, i941 int, i942 1179int, i943 int, i944 int, i945 int, i946 int, i947 int, i948 int, i949 int, i950 1180int, i951 int, i952 int, i953 int, i954 int, i955 int, i956 int, i957 int, i958 1181int, i959 int, i960 int, i961 int, i962 int, i963 int, i964 int, i965 int, i966 1182int, i967 int, i968 int, i969 int, i970 int, i971 int, i972 int, i973 int, i974 1183int, i975 int, i976 int, i977 int, i978 int, i979 int, i980 int, i981 int, i982 1184int, i983 int, i984 int, i985 int, i986 int, i987 int, i988 int, i989 int, i990 1185int, i991 int, i992 int, i993 int, i994 int, i995 int, i996 int, i997 int, i998 1186int, i999 int, i1000 int, b varchar(256)) row_format=dynamic; 1187connection master; 1188DROP TABLE IF EXISTS federated.t1; 1189CREATE TABLE federated.t1 1190(i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8 1191int, i9 int, i10 int, i11 int, i12 int, i13 int, i14 int, i15 int, i16 int, 1192i17 int, i18 int, i19 int, i20 int, i21 int, i22 int, i23 int, i24 int, i25 int, 1193i26 int, i27 int, i28 int, i29 int, i30 int, i31 int, i32 int, i33 int, i34 1194int, i35 int, i36 int, i37 int, i38 int, i39 int, i40 int, i41 int, i42 int, 1195i43 int, i44 int, i45 int, i46 int, i47 int, i48 int, i49 int, i50 int, i51 1196int, i52 int, i53 int, i54 int, i55 int, i56 int, i57 int, i58 int, i59 int, 1197i60 int, i61 int, i62 int, i63 int, i64 int, i65 int, i66 int, i67 int, i68 1198int, i69 int, i70 int, i71 int, i72 int, i73 int, i74 int, i75 int, i76 int, 1199i77 int, i78 int, i79 int, i80 int, i81 int, i82 int, i83 int, i84 int, i85 1200int, i86 int, i87 int, i88 int, i89 int, i90 int, i91 int, i92 int, i93 int, 1201i94 int, i95 int, i96 int, i97 int, i98 int, i99 int, i100 int, i101 int, i102 1202int, i103 int, i104 int, i105 int, i106 int, i107 int, i108 int, i109 int, i110 1203int, i111 int, i112 int, i113 int, i114 int, i115 int, i116 int, i117 int, i118 1204int, i119 int, i120 int, i121 int, i122 int, i123 int, i124 int, i125 int, i126 1205int, i127 int, i128 int, i129 int, i130 int, i131 int, i132 int, i133 int, i134 1206int, i135 int, i136 int, i137 int, i138 int, i139 int, i140 int, i141 int, i142 1207int, i143 int, i144 int, i145 int, i146 int, i147 int, i148 int, i149 int, i150 1208int, i151 int, i152 int, i153 int, i154 int, i155 int, i156 int, i157 int, i158 1209int, i159 int, i160 int, i161 int, i162 int, i163 int, i164 int, i165 int, i166 1210int, i167 int, i168 int, i169 int, i170 int, i171 int, i172 int, i173 int, i174 1211int, i175 int, i176 int, i177 int, i178 int, i179 int, i180 int, i181 int, i182 1212int, i183 int, i184 int, i185 int, i186 int, i187 int, i188 int, i189 int, i190 1213int, i191 int, i192 int, i193 int, i194 int, i195 int, i196 int, i197 int, i198 1214int, i199 int, i200 int, i201 int, i202 int, i203 int, i204 int, i205 int, i206 1215int, i207 int, i208 int, i209 int, i210 int, i211 int, i212 int, i213 int, i214 1216int, i215 int, i216 int, i217 int, i218 int, i219 int, i220 int, i221 int, i222 1217int, i223 int, i224 int, i225 int, i226 int, i227 int, i228 int, i229 int, i230 1218int, i231 int, i232 int, i233 int, i234 int, i235 int, i236 int, i237 int, i238 1219int, i239 int, i240 int, i241 int, i242 int, i243 int, i244 int, i245 int, i246 1220int, i247 int, i248 int, i249 int, i250 int, i251 int, i252 int, i253 int, i254 1221int, i255 int, i256 int, i257 int, i258 int, i259 int, i260 int, i261 int, i262 1222int, i263 int, i264 int, i265 int, i266 int, i267 int, i268 int, i269 int, i270 1223int, i271 int, i272 int, i273 int, i274 int, i275 int, i276 int, i277 int, i278 1224int, i279 int, i280 int, i281 int, i282 int, i283 int, i284 int, i285 int, i286 1225int, i287 int, i288 int, i289 int, i290 int, i291 int, i292 int, i293 int, i294 1226int, i295 int, i296 int, i297 int, i298 int, i299 int, i300 int, i301 int, i302 1227int, i303 int, i304 int, i305 int, i306 int, i307 int, i308 int, i309 int, i310 1228int, i311 int, i312 int, i313 int, i314 int, i315 int, i316 int, i317 int, i318 1229int, i319 int, i320 int, i321 int, i322 int, i323 int, i324 int, i325 int, i326 1230int, i327 int, i328 int, i329 int, i330 int, i331 int, i332 int, i333 int, i334 1231int, i335 int, i336 int, i337 int, i338 int, i339 int, i340 int, i341 int, i342 1232int, i343 int, i344 int, i345 int, i346 int, i347 int, i348 int, i349 int, i350 1233int, i351 int, i352 int, i353 int, i354 int, i355 int, i356 int, i357 int, i358 1234int, i359 int, i360 int, i361 int, i362 int, i363 int, i364 int, i365 int, i366 1235int, i367 int, i368 int, i369 int, i370 int, i371 int, i372 int, i373 int, i374 1236int, i375 int, i376 int, i377 int, i378 int, i379 int, i380 int, i381 int, i382 1237int, i383 int, i384 int, i385 int, i386 int, i387 int, i388 int, i389 int, i390 1238int, i391 int, i392 int, i393 int, i394 int, i395 int, i396 int, i397 int, i398 1239int, i399 int, i400 int, i401 int, i402 int, i403 int, i404 int, i405 int, i406 1240int, i407 int, i408 int, i409 int, i410 int, i411 int, i412 int, i413 int, i414 1241int, i415 int, i416 int, i417 int, i418 int, i419 int, i420 int, i421 int, i422 1242int, i423 int, i424 int, i425 int, i426 int, i427 int, i428 int, i429 int, i430 1243int, i431 int, i432 int, i433 int, i434 int, i435 int, i436 int, i437 int, i438 1244int, i439 int, i440 int, i441 int, i442 int, i443 int, i444 int, i445 int, i446 1245int, i447 int, i448 int, i449 int, i450 int, i451 int, i452 int, i453 int, i454 1246int, i455 int, i456 int, i457 int, i458 int, i459 int, i460 int, i461 int, i462 1247int, i463 int, i464 int, i465 int, i466 int, i467 int, i468 int, i469 int, i470 1248int, i471 int, i472 int, i473 int, i474 int, i475 int, i476 int, i477 int, i478 1249int, i479 int, i480 int, i481 int, i482 int, i483 int, i484 int, i485 int, i486 1250int, i487 int, i488 int, i489 int, i490 int, i491 int, i492 int, i493 int, i494 1251int, i495 int, i496 int, i497 int, i498 int, i499 int, i500 int, i501 int, i502 1252int, i503 int, i504 int, i505 int, i506 int, i507 int, i508 int, i509 int, i510 1253int, i511 int, i512 int, i513 int, i514 int, i515 int, i516 int, i517 int, i518 1254int, i519 int, i520 int, i521 int, i522 int, i523 int, i524 int, i525 int, i526 1255int, i527 int, i528 int, i529 int, i530 int, i531 int, i532 int, i533 int, i534 1256int, i535 int, i536 int, i537 int, i538 int, i539 int, i540 int, i541 int, i542 1257int, i543 int, i544 int, i545 int, i546 int, i547 int, i548 int, i549 int, i550 1258int, i551 int, i552 int, i553 int, i554 int, i555 int, i556 int, i557 int, i558 1259int, i559 int, i560 int, i561 int, i562 int, i563 int, i564 int, i565 int, i566 1260int, i567 int, i568 int, i569 int, i570 int, i571 int, i572 int, i573 int, i574 1261int, i575 int, i576 int, i577 int, i578 int, i579 int, i580 int, i581 int, i582 1262int, i583 int, i584 int, i585 int, i586 int, i587 int, i588 int, i589 int, i590 1263int, i591 int, i592 int, i593 int, i594 int, i595 int, i596 int, i597 int, i598 1264int, i599 int, i600 int, i601 int, i602 int, i603 int, i604 int, i605 int, i606 1265int, i607 int, i608 int, i609 int, i610 int, i611 int, i612 int, i613 int, i614 1266int, i615 int, i616 int, i617 int, i618 int, i619 int, i620 int, i621 int, i622 1267int, i623 int, i624 int, i625 int, i626 int, i627 int, i628 int, i629 int, i630 1268int, i631 int, i632 int, i633 int, i634 int, i635 int, i636 int, i637 int, i638 1269int, i639 int, i640 int, i641 int, i642 int, i643 int, i644 int, i645 int, i646 1270int, i647 int, i648 int, i649 int, i650 int, i651 int, i652 int, i653 int, i654 1271int, i655 int, i656 int, i657 int, i658 int, i659 int, i660 int, i661 int, i662 1272int, i663 int, i664 int, i665 int, i666 int, i667 int, i668 int, i669 int, i670 1273int, i671 int, i672 int, i673 int, i674 int, i675 int, i676 int, i677 int, i678 1274int, i679 int, i680 int, i681 int, i682 int, i683 int, i684 int, i685 int, i686 1275int, i687 int, i688 int, i689 int, i690 int, i691 int, i692 int, i693 int, i694 1276int, i695 int, i696 int, i697 int, i698 int, i699 int, i700 int, i701 int, i702 1277int, i703 int, i704 int, i705 int, i706 int, i707 int, i708 int, i709 int, i710 1278int, i711 int, i712 int, i713 int, i714 int, i715 int, i716 int, i717 int, i718 1279int, i719 int, i720 int, i721 int, i722 int, i723 int, i724 int, i725 int, i726 1280int, i727 int, i728 int, i729 int, i730 int, i731 int, i732 int, i733 int, i734 1281int, i735 int, i736 int, i737 int, i738 int, i739 int, i740 int, i741 int, i742 1282int, i743 int, i744 int, i745 int, i746 int, i747 int, i748 int, i749 int, i750 1283int, i751 int, i752 int, i753 int, i754 int, i755 int, i756 int, i757 int, i758 1284int, i759 int, i760 int, i761 int, i762 int, i763 int, i764 int, i765 int, i766 1285int, i767 int, i768 int, i769 int, i770 int, i771 int, i772 int, i773 int, i774 1286int, i775 int, i776 int, i777 int, i778 int, i779 int, i780 int, i781 int, i782 1287int, i783 int, i784 int, i785 int, i786 int, i787 int, i788 int, i789 int, i790 1288int, i791 int, i792 int, i793 int, i794 int, i795 int, i796 int, i797 int, i798 1289int, i799 int, i800 int, i801 int, i802 int, i803 int, i804 int, i805 int, i806 1290int, i807 int, i808 int, i809 int, i810 int, i811 int, i812 int, i813 int, i814 1291int, i815 int, i816 int, i817 int, i818 int, i819 int, i820 int, i821 int, i822 1292int, i823 int, i824 int, i825 int, i826 int, i827 int, i828 int, i829 int, i830 1293int, i831 int, i832 int, i833 int, i834 int, i835 int, i836 int, i837 int, i838 1294int, i839 int, i840 int, i841 int, i842 int, i843 int, i844 int, i845 int, i846 1295int, i847 int, i848 int, i849 int, i850 int, i851 int, i852 int, i853 int, i854 1296int, i855 int, i856 int, i857 int, i858 int, i859 int, i860 int, i861 int, i862 1297int, i863 int, i864 int, i865 int, i866 int, i867 int, i868 int, i869 int, i870 1298int, i871 int, i872 int, i873 int, i874 int, i875 int, i876 int, i877 int, i878 1299int, i879 int, i880 int, i881 int, i882 int, i883 int, i884 int, i885 int, i886 1300int, i887 int, i888 int, i889 int, i890 int, i891 int, i892 int, i893 int, i894 1301int, i895 int, i896 int, i897 int, i898 int, i899 int, i900 int, i901 int, i902 1302int, i903 int, i904 int, i905 int, i906 int, i907 int, i908 int, i909 int, i910 1303int, i911 int, i912 int, i913 int, i914 int, i915 int, i916 int, i917 int, i918 1304int, i919 int, i920 int, i921 int, i922 int, i923 int, i924 int, i925 int, i926 1305int, i927 int, i928 int, i929 int, i930 int, i931 int, i932 int, i933 int, i934 1306int, i935 int, i936 int, i937 int, i938 int, i939 int, i940 int, i941 int, i942 1307int, i943 int, i944 int, i945 int, i946 int, i947 int, i948 int, i949 int, i950 1308int, i951 int, i952 int, i953 int, i954 int, i955 int, i956 int, i957 int, i958 1309int, i959 int, i960 int, i961 int, i962 int, i963 int, i964 int, i965 int, i966 1310int, i967 int, i968 int, i969 int, i970 int, i971 int, i972 int, i973 int, i974 1311int, i975 int, i976 int, i977 int, i978 int, i979 int, i980 int, i981 int, i982 1312int, i983 int, i984 int, i985 int, i986 int, i987 int, i988 int, i989 int, i990 1313int, i991 int, i992 int, i993 int, i994 int, i995 int, i996 int, i997 int, i998 1314int, i999 int, i1000 int, b varchar(256)) 1315row_format=dynamic 1316ENGINE="FEDERATED" 1317DEFAULT CHARSET=latin1 1318CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1319INSERT INTO federated.t1 1320values (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13211, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13221, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13231, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13241, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13251, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13261, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13271, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13281, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13291, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13301, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13311, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13321, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13331, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13341, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13351, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13361, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13371, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13381, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13391, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13401, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13411, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13421, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13431, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13441, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13451, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13461, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13471, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13481, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13491, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13501, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13511, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13521, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13531, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13541, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13551, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13561, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13571, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13581, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, "PatrickG"); 1359UPDATE federated.t1 SET b=repeat('a',256); 1360UPDATE federated.t1 SET i1=0, i2=0, i3=0, i4=0, i5=0, i6=0, i7=0, i8=0, i9=0, i10=0; 1361SELECT * FROM federated.t1 WHERE i9=0 and i10=0; 1362i1 i2 i3 i4 i5 i6 i7 i8 i9 i10 i11 i12 i13 i14 i15 i16 i17 i18 i19 i20 i21 i22 i23 i24 i25 i26 i27 i28 i29 i30 i31 i32 i33 i34 i35 i36 i37 i38 i39 i40 i41 i42 i43 i44 i45 i46 i47 i48 i49 i50 i51 i52 i53 i54 i55 i56 i57 i58 i59 i60 i61 i62 i63 i64 i65 i66 i67 i68 i69 i70 i71 i72 i73 i74 i75 i76 i77 i78 i79 i80 i81 i82 i83 i84 i85 i86 i87 i88 i89 i90 i91 i92 i93 i94 i95 i96 i97 i98 i99 i100 i101 i102 i103 i104 i105 i106 i107 i108 i109 i110 i111 i112 i113 i114 i115 i116 i117 i118 i119 i120 i121 i122 i123 i124 i125 i126 i127 i128 i129 i130 i131 i132 i133 i134 i135 i136 i137 i138 i139 i140 i141 i142 i143 i144 i145 i146 i147 i148 i149 i150 i151 i152 i153 i154 i155 i156 i157 i158 i159 i160 i161 i162 i163 i164 i165 i166 i167 i168 i169 i170 i171 i172 i173 i174 i175 i176 i177 i178 i179 i180 i181 i182 i183 i184 i185 i186 i187 i188 i189 i190 i191 i192 i193 i194 i195 i196 i197 i198 i199 i200 i201 i202 i203 i204 i205 i206 i207 i208 i209 i210 i211 i212 i213 i214 i215 i216 i217 i218 i219 i220 i221 i222 i223 i224 i225 i226 i227 i228 i229 i230 i231 i232 i233 i234 i235 i236 i237 i238 i239 i240 i241 i242 i243 i244 i245 i246 i247 i248 i249 i250 i251 i252 i253 i254 i255 i256 i257 i258 i259 i260 i261 i262 i263 i264 i265 i266 i267 i268 i269 i270 i271 i272 i273 i274 i275 i276 i277 i278 i279 i280 i281 i282 i283 i284 i285 i286 i287 i288 i289 i290 i291 i292 i293 i294 i295 i296 i297 i298 i299 i300 i301 i302 i303 i304 i305 i306 i307 i308 i309 i310 i311 i312 i313 i314 i315 i316 i317 i318 i319 i320 i321 i322 i323 i324 i325 i326 i327 i328 i329 i330 i331 i332 i333 i334 i335 i336 i337 i338 i339 i340 i341 i342 i343 i344 i345 i346 i347 i348 i349 i350 i351 i352 i353 i354 i355 i356 i357 i358 i359 i360 i361 i362 i363 i364 i365 i366 i367 i368 i369 i370 i371 i372 i373 i374 i375 i376 i377 i378 i379 i380 i381 i382 i383 i384 i385 i386 i387 i388 i389 i390 i391 i392 i393 i394 i395 i396 i397 i398 i399 i400 i401 i402 i403 i404 i405 i406 i407 i408 i409 i410 i411 i412 i413 i414 i415 i416 i417 i418 i419 i420 i421 i422 i423 i424 i425 i426 i427 i428 i429 i430 i431 i432 i433 i434 i435 i436 i437 i438 i439 i440 i441 i442 i443 i444 i445 i446 i447 i448 i449 i450 i451 i452 i453 i454 i455 i456 i457 i458 i459 i460 i461 i462 i463 i464 i465 i466 i467 i468 i469 i470 i471 i472 i473 i474 i475 i476 i477 i478 i479 i480 i481 i482 i483 i484 i485 i486 i487 i488 i489 i490 i491 i492 i493 i494 i495 i496 i497 i498 i499 i500 i501 i502 i503 i504 i505 i506 i507 i508 i509 i510 i511 i512 i513 i514 i515 i516 i517 i518 i519 i520 i521 i522 i523 i524 i525 i526 i527 i528 i529 i530 i531 i532 i533 i534 i535 i536 i537 i538 i539 i540 i541 i542 i543 i544 i545 i546 i547 i548 i549 i550 i551 i552 i553 i554 i555 i556 i557 i558 i559 i560 i561 i562 i563 i564 i565 i566 i567 i568 i569 i570 i571 i572 i573 i574 i575 i576 i577 i578 i579 i580 i581 i582 i583 i584 i585 i586 i587 i588 i589 i590 i591 i592 i593 i594 i595 i596 i597 i598 i599 i600 i601 i602 i603 i604 i605 i606 i607 i608 i609 i610 i611 i612 i613 i614 i615 i616 i617 i618 i619 i620 i621 i622 i623 i624 i625 i626 i627 i628 i629 i630 i631 i632 i633 i634 i635 i636 i637 i638 i639 i640 i641 i642 i643 i644 i645 i646 i647 i648 i649 i650 i651 i652 i653 i654 i655 i656 i657 i658 i659 i660 i661 i662 i663 i664 i665 i666 i667 i668 i669 i670 i671 i672 i673 i674 i675 i676 i677 i678 i679 i680 i681 i682 i683 i684 i685 i686 i687 i688 i689 i690 i691 i692 i693 i694 i695 i696 i697 i698 i699 i700 i701 i702 i703 i704 i705 i706 i707 i708 i709 i710 i711 i712 i713 i714 i715 i716 i717 i718 i719 i720 i721 i722 i723 i724 i725 i726 i727 i728 i729 i730 i731 i732 i733 i734 i735 i736 i737 i738 i739 i740 i741 i742 i743 i744 i745 i746 i747 i748 i749 i750 i751 i752 i753 i754 i755 i756 i757 i758 i759 i760 i761 i762 i763 i764 i765 i766 i767 i768 i769 i770 i771 i772 i773 i774 i775 i776 i777 i778 i779 i780 i781 i782 i783 i784 i785 i786 i787 i788 i789 i790 i791 i792 i793 i794 i795 i796 i797 i798 i799 i800 i801 i802 i803 i804 i805 i806 i807 i808 i809 i810 i811 i812 i813 i814 i815 i816 i817 i818 i819 i820 i821 i822 i823 i824 i825 i826 i827 i828 i829 i830 i831 i832 i833 i834 i835 i836 i837 i838 i839 i840 i841 i842 i843 i844 i845 i846 i847 i848 i849 i850 i851 i852 i853 i854 i855 i856 i857 i858 i859 i860 i861 i862 i863 i864 i865 i866 i867 i868 i869 i870 i871 i872 i873 i874 i875 i876 i877 i878 i879 i880 i881 i882 i883 i884 i885 i886 i887 i888 i889 i890 i891 i892 i893 i894 i895 i896 i897 i898 i899 i900 i901 i902 i903 i904 i905 i906 i907 i908 i909 i910 i911 i912 i913 i914 i915 i916 i917 i918 i919 i920 i921 i922 i923 i924 i925 i926 i927 i928 i929 i930 i931 i932 i933 i934 i935 i936 i937 i938 i939 i940 i941 i942 i943 i944 i945 i946 i947 i948 i949 i950 i951 i952 i953 i954 i955 i956 i957 i958 i959 i960 i961 i962 i963 i964 i965 i966 i967 i968 i969 i970 i971 i972 i973 i974 i975 i976 i977 i978 i979 i980 i981 i982 i983 i984 i985 i986 i987 i988 i989 i990 i991 i992 i993 i994 i995 i996 i997 i998 i999 i1000 b 13630 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 1364UPDATE federated.t1 SET i50=20; 1365SELECT * FROM federated.t1; 1366i1 i2 i3 i4 i5 i6 i7 i8 i9 i10 i11 i12 i13 i14 i15 i16 i17 i18 i19 i20 i21 i22 i23 i24 i25 i26 i27 i28 i29 i30 i31 i32 i33 i34 i35 i36 i37 i38 i39 i40 i41 i42 i43 i44 i45 i46 i47 i48 i49 i50 i51 i52 i53 i54 i55 i56 i57 i58 i59 i60 i61 i62 i63 i64 i65 i66 i67 i68 i69 i70 i71 i72 i73 i74 i75 i76 i77 i78 i79 i80 i81 i82 i83 i84 i85 i86 i87 i88 i89 i90 i91 i92 i93 i94 i95 i96 i97 i98 i99 i100 i101 i102 i103 i104 i105 i106 i107 i108 i109 i110 i111 i112 i113 i114 i115 i116 i117 i118 i119 i120 i121 i122 i123 i124 i125 i126 i127 i128 i129 i130 i131 i132 i133 i134 i135 i136 i137 i138 i139 i140 i141 i142 i143 i144 i145 i146 i147 i148 i149 i150 i151 i152 i153 i154 i155 i156 i157 i158 i159 i160 i161 i162 i163 i164 i165 i166 i167 i168 i169 i170 i171 i172 i173 i174 i175 i176 i177 i178 i179 i180 i181 i182 i183 i184 i185 i186 i187 i188 i189 i190 i191 i192 i193 i194 i195 i196 i197 i198 i199 i200 i201 i202 i203 i204 i205 i206 i207 i208 i209 i210 i211 i212 i213 i214 i215 i216 i217 i218 i219 i220 i221 i222 i223 i224 i225 i226 i227 i228 i229 i230 i231 i232 i233 i234 i235 i236 i237 i238 i239 i240 i241 i242 i243 i244 i245 i246 i247 i248 i249 i250 i251 i252 i253 i254 i255 i256 i257 i258 i259 i260 i261 i262 i263 i264 i265 i266 i267 i268 i269 i270 i271 i272 i273 i274 i275 i276 i277 i278 i279 i280 i281 i282 i283 i284 i285 i286 i287 i288 i289 i290 i291 i292 i293 i294 i295 i296 i297 i298 i299 i300 i301 i302 i303 i304 i305 i306 i307 i308 i309 i310 i311 i312 i313 i314 i315 i316 i317 i318 i319 i320 i321 i322 i323 i324 i325 i326 i327 i328 i329 i330 i331 i332 i333 i334 i335 i336 i337 i338 i339 i340 i341 i342 i343 i344 i345 i346 i347 i348 i349 i350 i351 i352 i353 i354 i355 i356 i357 i358 i359 i360 i361 i362 i363 i364 i365 i366 i367 i368 i369 i370 i371 i372 i373 i374 i375 i376 i377 i378 i379 i380 i381 i382 i383 i384 i385 i386 i387 i388 i389 i390 i391 i392 i393 i394 i395 i396 i397 i398 i399 i400 i401 i402 i403 i404 i405 i406 i407 i408 i409 i410 i411 i412 i413 i414 i415 i416 i417 i418 i419 i420 i421 i422 i423 i424 i425 i426 i427 i428 i429 i430 i431 i432 i433 i434 i435 i436 i437 i438 i439 i440 i441 i442 i443 i444 i445 i446 i447 i448 i449 i450 i451 i452 i453 i454 i455 i456 i457 i458 i459 i460 i461 i462 i463 i464 i465 i466 i467 i468 i469 i470 i471 i472 i473 i474 i475 i476 i477 i478 i479 i480 i481 i482 i483 i484 i485 i486 i487 i488 i489 i490 i491 i492 i493 i494 i495 i496 i497 i498 i499 i500 i501 i502 i503 i504 i505 i506 i507 i508 i509 i510 i511 i512 i513 i514 i515 i516 i517 i518 i519 i520 i521 i522 i523 i524 i525 i526 i527 i528 i529 i530 i531 i532 i533 i534 i535 i536 i537 i538 i539 i540 i541 i542 i543 i544 i545 i546 i547 i548 i549 i550 i551 i552 i553 i554 i555 i556 i557 i558 i559 i560 i561 i562 i563 i564 i565 i566 i567 i568 i569 i570 i571 i572 i573 i574 i575 i576 i577 i578 i579 i580 i581 i582 i583 i584 i585 i586 i587 i588 i589 i590 i591 i592 i593 i594 i595 i596 i597 i598 i599 i600 i601 i602 i603 i604 i605 i606 i607 i608 i609 i610 i611 i612 i613 i614 i615 i616 i617 i618 i619 i620 i621 i622 i623 i624 i625 i626 i627 i628 i629 i630 i631 i632 i633 i634 i635 i636 i637 i638 i639 i640 i641 i642 i643 i644 i645 i646 i647 i648 i649 i650 i651 i652 i653 i654 i655 i656 i657 i658 i659 i660 i661 i662 i663 i664 i665 i666 i667 i668 i669 i670 i671 i672 i673 i674 i675 i676 i677 i678 i679 i680 i681 i682 i683 i684 i685 i686 i687 i688 i689 i690 i691 i692 i693 i694 i695 i696 i697 i698 i699 i700 i701 i702 i703 i704 i705 i706 i707 i708 i709 i710 i711 i712 i713 i714 i715 i716 i717 i718 i719 i720 i721 i722 i723 i724 i725 i726 i727 i728 i729 i730 i731 i732 i733 i734 i735 i736 i737 i738 i739 i740 i741 i742 i743 i744 i745 i746 i747 i748 i749 i750 i751 i752 i753 i754 i755 i756 i757 i758 i759 i760 i761 i762 i763 i764 i765 i766 i767 i768 i769 i770 i771 i772 i773 i774 i775 i776 i777 i778 i779 i780 i781 i782 i783 i784 i785 i786 i787 i788 i789 i790 i791 i792 i793 i794 i795 i796 i797 i798 i799 i800 i801 i802 i803 i804 i805 i806 i807 i808 i809 i810 i811 i812 i813 i814 i815 i816 i817 i818 i819 i820 i821 i822 i823 i824 i825 i826 i827 i828 i829 i830 i831 i832 i833 i834 i835 i836 i837 i838 i839 i840 i841 i842 i843 i844 i845 i846 i847 i848 i849 i850 i851 i852 i853 i854 i855 i856 i857 i858 i859 i860 i861 i862 i863 i864 i865 i866 i867 i868 i869 i870 i871 i872 i873 i874 i875 i876 i877 i878 i879 i880 i881 i882 i883 i884 i885 i886 i887 i888 i889 i890 i891 i892 i893 i894 i895 i896 i897 i898 i899 i900 i901 i902 i903 i904 i905 i906 i907 i908 i909 i910 i911 i912 i913 i914 i915 i916 i917 i918 i919 i920 i921 i922 i923 i924 i925 i926 i927 i928 i929 i930 i931 i932 i933 i934 i935 i936 i937 i938 i939 i940 i941 i942 i943 i944 i945 i946 i947 i948 i949 i950 i951 i952 i953 i954 i955 i956 i957 i958 i959 i960 i961 i962 i963 i964 i965 i966 i967 i968 i969 i970 i971 i972 i973 i974 i975 i976 i977 i978 i979 i980 i981 i982 i983 i984 i985 i986 i987 i988 i989 i990 i991 i992 i993 i994 i995 i996 i997 i998 i999 i1000 b 13670 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 20 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 1368DELETE FROM federated.t1 WHERE i51=20; 1369SELECT * FROM federated.t1; 1370i1 i2 i3 i4 i5 i6 i7 i8 i9 i10 i11 i12 i13 i14 i15 i16 i17 i18 i19 i20 i21 i22 i23 i24 i25 i26 i27 i28 i29 i30 i31 i32 i33 i34 i35 i36 i37 i38 i39 i40 i41 i42 i43 i44 i45 i46 i47 i48 i49 i50 i51 i52 i53 i54 i55 i56 i57 i58 i59 i60 i61 i62 i63 i64 i65 i66 i67 i68 i69 i70 i71 i72 i73 i74 i75 i76 i77 i78 i79 i80 i81 i82 i83 i84 i85 i86 i87 i88 i89 i90 i91 i92 i93 i94 i95 i96 i97 i98 i99 i100 i101 i102 i103 i104 i105 i106 i107 i108 i109 i110 i111 i112 i113 i114 i115 i116 i117 i118 i119 i120 i121 i122 i123 i124 i125 i126 i127 i128 i129 i130 i131 i132 i133 i134 i135 i136 i137 i138 i139 i140 i141 i142 i143 i144 i145 i146 i147 i148 i149 i150 i151 i152 i153 i154 i155 i156 i157 i158 i159 i160 i161 i162 i163 i164 i165 i166 i167 i168 i169 i170 i171 i172 i173 i174 i175 i176 i177 i178 i179 i180 i181 i182 i183 i184 i185 i186 i187 i188 i189 i190 i191 i192 i193 i194 i195 i196 i197 i198 i199 i200 i201 i202 i203 i204 i205 i206 i207 i208 i209 i210 i211 i212 i213 i214 i215 i216 i217 i218 i219 i220 i221 i222 i223 i224 i225 i226 i227 i228 i229 i230 i231 i232 i233 i234 i235 i236 i237 i238 i239 i240 i241 i242 i243 i244 i245 i246 i247 i248 i249 i250 i251 i252 i253 i254 i255 i256 i257 i258 i259 i260 i261 i262 i263 i264 i265 i266 i267 i268 i269 i270 i271 i272 i273 i274 i275 i276 i277 i278 i279 i280 i281 i282 i283 i284 i285 i286 i287 i288 i289 i290 i291 i292 i293 i294 i295 i296 i297 i298 i299 i300 i301 i302 i303 i304 i305 i306 i307 i308 i309 i310 i311 i312 i313 i314 i315 i316 i317 i318 i319 i320 i321 i322 i323 i324 i325 i326 i327 i328 i329 i330 i331 i332 i333 i334 i335 i336 i337 i338 i339 i340 i341 i342 i343 i344 i345 i346 i347 i348 i349 i350 i351 i352 i353 i354 i355 i356 i357 i358 i359 i360 i361 i362 i363 i364 i365 i366 i367 i368 i369 i370 i371 i372 i373 i374 i375 i376 i377 i378 i379 i380 i381 i382 i383 i384 i385 i386 i387 i388 i389 i390 i391 i392 i393 i394 i395 i396 i397 i398 i399 i400 i401 i402 i403 i404 i405 i406 i407 i408 i409 i410 i411 i412 i413 i414 i415 i416 i417 i418 i419 i420 i421 i422 i423 i424 i425 i426 i427 i428 i429 i430 i431 i432 i433 i434 i435 i436 i437 i438 i439 i440 i441 i442 i443 i444 i445 i446 i447 i448 i449 i450 i451 i452 i453 i454 i455 i456 i457 i458 i459 i460 i461 i462 i463 i464 i465 i466 i467 i468 i469 i470 i471 i472 i473 i474 i475 i476 i477 i478 i479 i480 i481 i482 i483 i484 i485 i486 i487 i488 i489 i490 i491 i492 i493 i494 i495 i496 i497 i498 i499 i500 i501 i502 i503 i504 i505 i506 i507 i508 i509 i510 i511 i512 i513 i514 i515 i516 i517 i518 i519 i520 i521 i522 i523 i524 i525 i526 i527 i528 i529 i530 i531 i532 i533 i534 i535 i536 i537 i538 i539 i540 i541 i542 i543 i544 i545 i546 i547 i548 i549 i550 i551 i552 i553 i554 i555 i556 i557 i558 i559 i560 i561 i562 i563 i564 i565 i566 i567 i568 i569 i570 i571 i572 i573 i574 i575 i576 i577 i578 i579 i580 i581 i582 i583 i584 i585 i586 i587 i588 i589 i590 i591 i592 i593 i594 i595 i596 i597 i598 i599 i600 i601 i602 i603 i604 i605 i606 i607 i608 i609 i610 i611 i612 i613 i614 i615 i616 i617 i618 i619 i620 i621 i622 i623 i624 i625 i626 i627 i628 i629 i630 i631 i632 i633 i634 i635 i636 i637 i638 i639 i640 i641 i642 i643 i644 i645 i646 i647 i648 i649 i650 i651 i652 i653 i654 i655 i656 i657 i658 i659 i660 i661 i662 i663 i664 i665 i666 i667 i668 i669 i670 i671 i672 i673 i674 i675 i676 i677 i678 i679 i680 i681 i682 i683 i684 i685 i686 i687 i688 i689 i690 i691 i692 i693 i694 i695 i696 i697 i698 i699 i700 i701 i702 i703 i704 i705 i706 i707 i708 i709 i710 i711 i712 i713 i714 i715 i716 i717 i718 i719 i720 i721 i722 i723 i724 i725 i726 i727 i728 i729 i730 i731 i732 i733 i734 i735 i736 i737 i738 i739 i740 i741 i742 i743 i744 i745 i746 i747 i748 i749 i750 i751 i752 i753 i754 i755 i756 i757 i758 i759 i760 i761 i762 i763 i764 i765 i766 i767 i768 i769 i770 i771 i772 i773 i774 i775 i776 i777 i778 i779 i780 i781 i782 i783 i784 i785 i786 i787 i788 i789 i790 i791 i792 i793 i794 i795 i796 i797 i798 i799 i800 i801 i802 i803 i804 i805 i806 i807 i808 i809 i810 i811 i812 i813 i814 i815 i816 i817 i818 i819 i820 i821 i822 i823 i824 i825 i826 i827 i828 i829 i830 i831 i832 i833 i834 i835 i836 i837 i838 i839 i840 i841 i842 i843 i844 i845 i846 i847 i848 i849 i850 i851 i852 i853 i854 i855 i856 i857 i858 i859 i860 i861 i862 i863 i864 i865 i866 i867 i868 i869 i870 i871 i872 i873 i874 i875 i876 i877 i878 i879 i880 i881 i882 i883 i884 i885 i886 i887 i888 i889 i890 i891 i892 i893 i894 i895 i896 i897 i898 i899 i900 i901 i902 i903 i904 i905 i906 i907 i908 i909 i910 i911 i912 i913 i914 i915 i916 i917 i918 i919 i920 i921 i922 i923 i924 i925 i926 i927 i928 i929 i930 i931 i932 i933 i934 i935 i936 i937 i938 i939 i940 i941 i942 i943 i944 i945 i946 i947 i948 i949 i950 i951 i952 i953 i954 i955 i956 i957 i958 i959 i960 i961 i962 i963 i964 i965 i966 i967 i968 i969 i970 i971 i972 i973 i974 i975 i976 i977 i978 i979 i980 i981 i982 i983 i984 i985 i986 i987 i988 i989 i990 i991 i992 i993 i994 i995 i996 i997 i998 i999 i1000 b 13710 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 20 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 1372DELETE FROM federated.t1 WHERE i50=20; 1373SELECT * FROM federated.t1; 1374i1 i2 i3 i4 i5 i6 i7 i8 i9 i10 i11 i12 i13 i14 i15 i16 i17 i18 i19 i20 i21 i22 i23 i24 i25 i26 i27 i28 i29 i30 i31 i32 i33 i34 i35 i36 i37 i38 i39 i40 i41 i42 i43 i44 i45 i46 i47 i48 i49 i50 i51 i52 i53 i54 i55 i56 i57 i58 i59 i60 i61 i62 i63 i64 i65 i66 i67 i68 i69 i70 i71 i72 i73 i74 i75 i76 i77 i78 i79 i80 i81 i82 i83 i84 i85 i86 i87 i88 i89 i90 i91 i92 i93 i94 i95 i96 i97 i98 i99 i100 i101 i102 i103 i104 i105 i106 i107 i108 i109 i110 i111 i112 i113 i114 i115 i116 i117 i118 i119 i120 i121 i122 i123 i124 i125 i126 i127 i128 i129 i130 i131 i132 i133 i134 i135 i136 i137 i138 i139 i140 i141 i142 i143 i144 i145 i146 i147 i148 i149 i150 i151 i152 i153 i154 i155 i156 i157 i158 i159 i160 i161 i162 i163 i164 i165 i166 i167 i168 i169 i170 i171 i172 i173 i174 i175 i176 i177 i178 i179 i180 i181 i182 i183 i184 i185 i186 i187 i188 i189 i190 i191 i192 i193 i194 i195 i196 i197 i198 i199 i200 i201 i202 i203 i204 i205 i206 i207 i208 i209 i210 i211 i212 i213 i214 i215 i216 i217 i218 i219 i220 i221 i222 i223 i224 i225 i226 i227 i228 i229 i230 i231 i232 i233 i234 i235 i236 i237 i238 i239 i240 i241 i242 i243 i244 i245 i246 i247 i248 i249 i250 i251 i252 i253 i254 i255 i256 i257 i258 i259 i260 i261 i262 i263 i264 i265 i266 i267 i268 i269 i270 i271 i272 i273 i274 i275 i276 i277 i278 i279 i280 i281 i282 i283 i284 i285 i286 i287 i288 i289 i290 i291 i292 i293 i294 i295 i296 i297 i298 i299 i300 i301 i302 i303 i304 i305 i306 i307 i308 i309 i310 i311 i312 i313 i314 i315 i316 i317 i318 i319 i320 i321 i322 i323 i324 i325 i326 i327 i328 i329 i330 i331 i332 i333 i334 i335 i336 i337 i338 i339 i340 i341 i342 i343 i344 i345 i346 i347 i348 i349 i350 i351 i352 i353 i354 i355 i356 i357 i358 i359 i360 i361 i362 i363 i364 i365 i366 i367 i368 i369 i370 i371 i372 i373 i374 i375 i376 i377 i378 i379 i380 i381 i382 i383 i384 i385 i386 i387 i388 i389 i390 i391 i392 i393 i394 i395 i396 i397 i398 i399 i400 i401 i402 i403 i404 i405 i406 i407 i408 i409 i410 i411 i412 i413 i414 i415 i416 i417 i418 i419 i420 i421 i422 i423 i424 i425 i426 i427 i428 i429 i430 i431 i432 i433 i434 i435 i436 i437 i438 i439 i440 i441 i442 i443 i444 i445 i446 i447 i448 i449 i450 i451 i452 i453 i454 i455 i456 i457 i458 i459 i460 i461 i462 i463 i464 i465 i466 i467 i468 i469 i470 i471 i472 i473 i474 i475 i476 i477 i478 i479 i480 i481 i482 i483 i484 i485 i486 i487 i488 i489 i490 i491 i492 i493 i494 i495 i496 i497 i498 i499 i500 i501 i502 i503 i504 i505 i506 i507 i508 i509 i510 i511 i512 i513 i514 i515 i516 i517 i518 i519 i520 i521 i522 i523 i524 i525 i526 i527 i528 i529 i530 i531 i532 i533 i534 i535 i536 i537 i538 i539 i540 i541 i542 i543 i544 i545 i546 i547 i548 i549 i550 i551 i552 i553 i554 i555 i556 i557 i558 i559 i560 i561 i562 i563 i564 i565 i566 i567 i568 i569 i570 i571 i572 i573 i574 i575 i576 i577 i578 i579 i580 i581 i582 i583 i584 i585 i586 i587 i588 i589 i590 i591 i592 i593 i594 i595 i596 i597 i598 i599 i600 i601 i602 i603 i604 i605 i606 i607 i608 i609 i610 i611 i612 i613 i614 i615 i616 i617 i618 i619 i620 i621 i622 i623 i624 i625 i626 i627 i628 i629 i630 i631 i632 i633 i634 i635 i636 i637 i638 i639 i640 i641 i642 i643 i644 i645 i646 i647 i648 i649 i650 i651 i652 i653 i654 i655 i656 i657 i658 i659 i660 i661 i662 i663 i664 i665 i666 i667 i668 i669 i670 i671 i672 i673 i674 i675 i676 i677 i678 i679 i680 i681 i682 i683 i684 i685 i686 i687 i688 i689 i690 i691 i692 i693 i694 i695 i696 i697 i698 i699 i700 i701 i702 i703 i704 i705 i706 i707 i708 i709 i710 i711 i712 i713 i714 i715 i716 i717 i718 i719 i720 i721 i722 i723 i724 i725 i726 i727 i728 i729 i730 i731 i732 i733 i734 i735 i736 i737 i738 i739 i740 i741 i742 i743 i744 i745 i746 i747 i748 i749 i750 i751 i752 i753 i754 i755 i756 i757 i758 i759 i760 i761 i762 i763 i764 i765 i766 i767 i768 i769 i770 i771 i772 i773 i774 i775 i776 i777 i778 i779 i780 i781 i782 i783 i784 i785 i786 i787 i788 i789 i790 i791 i792 i793 i794 i795 i796 i797 i798 i799 i800 i801 i802 i803 i804 i805 i806 i807 i808 i809 i810 i811 i812 i813 i814 i815 i816 i817 i818 i819 i820 i821 i822 i823 i824 i825 i826 i827 i828 i829 i830 i831 i832 i833 i834 i835 i836 i837 i838 i839 i840 i841 i842 i843 i844 i845 i846 i847 i848 i849 i850 i851 i852 i853 i854 i855 i856 i857 i858 i859 i860 i861 i862 i863 i864 i865 i866 i867 i868 i869 i870 i871 i872 i873 i874 i875 i876 i877 i878 i879 i880 i881 i882 i883 i884 i885 i886 i887 i888 i889 i890 i891 i892 i893 i894 i895 i896 i897 i898 i899 i900 i901 i902 i903 i904 i905 i906 i907 i908 i909 i910 i911 i912 i913 i914 i915 i916 i917 i918 i919 i920 i921 i922 i923 i924 i925 i926 i927 i928 i929 i930 i931 i932 i933 i934 i935 i936 i937 i938 i939 i940 i941 i942 i943 i944 i945 i946 i947 i948 i949 i950 i951 i952 i953 i954 i955 i956 i957 i958 i959 i960 i961 i962 i963 i964 i965 i966 i967 i968 i969 i970 i971 i972 i973 i974 i975 i976 i977 i978 i979 i980 i981 i982 i983 i984 i985 i986 i987 i988 i989 i990 i991 i992 i993 i994 i995 i996 i997 i998 i999 i1000 b 1375connection slave; 1376DROP TABLE IF EXISTS federated.t1; 1377CREATE TABLE federated.t1 (id int NOT NULL auto_increment, code char(20) NOT NULL, fileguts blob NOT NULL, creation_date datetime, entered_time datetime default '2004-04-04 04:04:04', PRIMARY KEY(id), index(code), index(fileguts(10))) DEFAULT CHARSET=latin1; 1378connection master; 1379DROP TABLE IF EXISTS federated.t1; 1380CREATE TABLE federated.t1 ( 1381id int NOT NULL auto_increment, 1382code char(20) NOT NULL, 1383fileguts blob NOT NULL, 1384creation_date datetime, 1385entered_time datetime default '2004-04-04 04:04:04', 1386PRIMARY KEY(id), 1387index(code), 1388index(fileguts(10))) 1389ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1390CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1391INSERT INTO federated.t1 (code, fileguts, creation_date) VALUES ('ASDFWERQWETWETAWETA', '*()w*09*$()*#)(*09*^90*d)(*s()d8g)(s*ned)(*)(s*d)(*hn(d*)(*sbn)D((#$*(#*%%&#&^$#&#&#&#&^&#*&*#$*&^*(&#(&Q*&&(*!&!(*&*(#&*(%&#<S-F8>*<S-F8><S-F8><S-F8>#<S-F8>#<S-F8>#<S-F8>[[', '2003-03-03 03:03:03'); 1392INSERT INTO federated.t1 (code, fileguts, creation_date) VALUES ('DEUEUEUEUEUEUEUEUEU', '*()w*09*$()*#)(*09*^90*d)(*s()d8g)(s*ned)(*)(s*d)(*hn(d*)(*sbn)D((#$*(#*%%&#&^$#&#&#&#&^&#*&*#$*&^*(&#(&Q*&&(*!&!(*&*(#&*(%&#<S-F8>*<S-F8><S-F8><S-F8>#<S-F8>#<S-F8>#<S-F8>[[', '2004-04-04 04:04:04'); 1393INSERT INTO federated.t1 (code, fileguts, creation_date) VALUES ('DEUEUEUEUEUEUEUEUEU', 'jimbob', '2004-04-04 04:04:04'); 1394SELECT * FROM federated.t1; 1395id code fileguts creation_date entered_time 13961 ASDFWERQWETWETAWETA *()w*09*$()*#)(*09*^90*d)(*s()d8g)(s*ned)(*)(s*d)(*hn(d*)(*sbn)D((#$*(#*%%&#&^$#&#&#&#&^&#*&*#$*&^*(&#(&Q*&&(*!&!(*&*(#&*(%&#<S-F8>*<S-F8><S-F8><S-F8>#<S-F8>#<S-F8>#<S-F8>[[ 2003-03-03 03:03:03 2004-04-04 04:04:04 13972 DEUEUEUEUEUEUEUEUEU *()w*09*$()*#)(*09*^90*d)(*s()d8g)(s*ned)(*)(s*d)(*hn(d*)(*sbn)D((#$*(#*%%&#&^$#&#&#&#&^&#*&*#$*&^*(&#(&Q*&&(*!&!(*&*(#&*(%&#<S-F8>*<S-F8><S-F8><S-F8>#<S-F8>#<S-F8>#<S-F8>[[ 2004-04-04 04:04:04 2004-04-04 04:04:04 13983 DEUEUEUEUEUEUEUEUEU jimbob 2004-04-04 04:04:04 2004-04-04 04:04:04 1399SELECT * FROM federated.t1 WHERE fileguts = 'jimbob'; 1400id code fileguts creation_date entered_time 14013 DEUEUEUEUEUEUEUEUEU jimbob 2004-04-04 04:04:04 2004-04-04 04:04:04 1402connection slave; 1403DROP TABLE IF EXISTS federated.t1; 1404CREATE TABLE federated.t1 (`a` BLOB); 1405connection master; 1406DROP TABLE IF EXISTS federated.t1; 1407CREATE TABLE federated.t1 ( 1408`a` BLOB) 1409ENGINE="FEDERATED" 1410CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1411INSERT INTO federated.t1 VALUES (0x00); 1412INSERT INTO federated.t1 VALUES (0x0001); 1413INSERT INTO federated.t1 VALUES (0x0100); 1414SELECT HEX(a) FROM federated.t1; 1415HEX(a) 141600 14170001 14180100 1419connection slave; 1420DROP TABLE IF EXISTS federated.t1; 1421CREATE TABLE federated.t1 ( 1422`id` int(20) NOT NULL auto_increment, 1423`country_id` int(20) NOT NULL DEFAULT 0, 1424`name` varchar(32), 1425`other` varchar(20), 1426PRIMARY KEY (`id`), 1427key (country_id)); 1428connection master; 1429DROP TABLE IF EXISTS federated.countries; 1430Warnings: 1431Note 1051 Unknown table 'federated.countries' 1432CREATE TABLE federated.countries ( 1433`id` int(20) NOT NULL auto_increment, 1434`country` varchar(32), 1435PRIMARY KEY (id)); 1436INSERT INTO federated.countries (country) VALUES ('India'); 1437INSERT INTO federated.countries (country) VALUES ('Germany'); 1438INSERT INTO federated.countries (country) VALUES ('Italy'); 1439INSERT INTO federated.countries (country) VALUES ('Finland'); 1440INSERT INTO federated.countries (country) VALUES ('Ukraine'); 1441DROP TABLE IF EXISTS federated.t1; 1442CREATE TABLE federated.t1 ( 1443`id` int(20) NOT NULL auto_increment, 1444`country_id` int(20) NOT NULL DEFAULT 0, 1445`name` varchar(32), 1446`other` varchar(20), 1447PRIMARY KEY (`id`), 1448KEY (country_id) ) 1449ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1450CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1451INSERT INTO federated.t1 (name, country_id, other) VALUES ('Kumar', 1, 11111); 1452INSERT INTO federated.t1 (name, country_id, other) VALUES ('Lenz', 2, 22222); 1453INSERT INTO federated.t1 (name, country_id, other) VALUES ('Marizio', 3, 33333); 1454INSERT INTO federated.t1 (name, country_id, other) VALUES ('Monty', 4, 33333); 1455INSERT INTO federated.t1 (name, country_id, other) VALUES ('Sanja', 5, 33333); 1456SELECT federated.t1.name AS name, federated.t1.country_id AS country_id, 1457federated.t1.other AS other, federated.countries.country AS country 1458FROM federated.t1, federated.countries WHERE 1459federated.t1.country_id = federated.countries.id; 1460name country_id other country 1461Kumar 1 11111 India 1462Lenz 2 22222 Germany 1463Marizio 3 33333 Italy 1464Monty 4 33333 Finland 1465Sanja 5 33333 Ukraine 1466SELECT federated.t1.name AS name, federated.t1.country_id AS country_id, 1467federated.t1.other AS other, federated.countries.country AS country 1468FROM federated.t1 INNER JOIN federated.countries ON 1469federated.t1.country_id = federated.countries.id; 1470name country_id other country 1471Kumar 1 11111 India 1472Lenz 2 22222 Germany 1473Marizio 3 33333 Italy 1474Monty 4 33333 Finland 1475Sanja 5 33333 Ukraine 1476SELECT federated.t1.name AS name, federated.t1.country_id AS country_id, 1477federated.t1.other AS other, federated.countries.country AS country 1478FROM federated.t1 INNER JOIN federated.countries ON 1479federated.t1.country_id = federated.countries.id 1480WHERE federated.t1.name = 'Monty'; 1481name country_id other country 1482Monty 4 33333 Finland 1483SELECT federated.t1.*, federated.countries.country 1484FROM federated.t1 LEFT JOIN federated.countries 1485ON federated.t1.country_id = federated.countries.id 1486ORDER BY federated.countries.id; 1487id country_id name other country 14881 1 Kumar 11111 India 14892 2 Lenz 22222 Germany 14903 3 Marizio 33333 Italy 14914 4 Monty 33333 Finland 14925 5 Sanja 33333 Ukraine 1493SELECT federated.t1.*, federated.countries.country 1494FROM federated.t1 LEFT JOIN federated.countries 1495ON federated.t1.country_id = federated.countries.id 1496ORDER BY federated.countries.country; 1497id country_id name other country 14984 4 Monty 33333 Finland 14992 2 Lenz 22222 Germany 15001 1 Kumar 11111 India 15013 3 Marizio 33333 Italy 15025 5 Sanja 33333 Ukraine 1503SELECT federated.t1.*, federated.countries.country 1504FROM federated.t1 RIGHT JOIN federated.countries 1505ON federated.t1.country_id = federated.countries.id 1506ORDER BY federated.t1.country_id; 1507id country_id name other country 15081 1 Kumar 11111 India 15092 2 Lenz 22222 Germany 15103 3 Marizio 33333 Italy 15114 4 Monty 33333 Finland 15125 5 Sanja 33333 Ukraine 1513DROP TABLE federated.countries; 1514OPTIMIZE TABLE federated.t1; 1515Table Op Msg_type Msg_text 1516federated.t1 optimize status OK 1517REPAIR TABLE federated.t1; 1518Table Op Msg_type Msg_text 1519federated.t1 repair status OK 1520REPAIR TABLE federated.t1 QUICK; 1521Table Op Msg_type Msg_text 1522federated.t1 repair status OK 1523REPAIR TABLE federated.t1 EXTENDED; 1524Table Op Msg_type Msg_text 1525federated.t1 repair status OK 1526REPAIR TABLE federated.t1 USE_FRM; 1527Table Op Msg_type Msg_text 1528federated.t1 repair status OK 1529connection slave; 1530DROP TABLE IF EXISTS federated.normal_table; 1531CREATE TABLE federated.normal_table ( 1532`id` int(4) NOT NULL, 1533`name` varchar(10) default NULL 1534) DEFAULT CHARSET=latin1; 1535connection master; 1536DROP TABLE IF EXISTS federated.alter_me; 1537CREATE TABLE federated.alter_me ( 1538`id` int(4) NOT NULL, 1539`name` varchar(10) default NULL, 1540PRIMARY KEY (`id`) 1541) ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1542CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/normal_table'; 1543INSERT INTO federated.alter_me (id, name) VALUES (1, 'Monty'); 1544INSERT INTO federated.alter_me (id, name) VALUES (2, 'David'); 1545SELECT * FROM federated.alter_me; 1546id name 15471 Monty 15482 David 1549ALTER TABLE federated.alter_me MODIFY COLUMN id int(16) NOT NULL; 1550ERROR HY000: Storage engine FEDERATED of the table `federated`.`alter_me` doesn't have this option 1551SELECT * FROM federated.alter_me; 1552id name 15531 Monty 15542 David 1555DROP TABLE federated.alter_me; 1556connection slave; 1557DROP TABLE federated.normal_table; 1558DROP TABLE IF EXISTS federated.t1; 1559CREATE TABLE federated.t1 ( 1560`bitty` bit(3) 1561) DEFAULT CHARSET=latin1; 1562connection master; 1563DROP TABLE IF EXISTS federated.t1; 1564CREATE TABLE federated.t1 ( 1565`bitty` bit(3) 1566) ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1567CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1568INSERT INTO federated.t1 VALUES (b'001'); 1569INSERT INTO federated.t1 VALUES (b'010'); 1570INSERT INTO federated.t1 VALUES (b'011'); 1571INSERT INTO federated.t1 VALUES (b'100'); 1572INSERT INTO federated.t1 VALUES (b'101'); 1573INSERT INTO federated.t1 VALUES (b'110'); 1574INSERT INTO federated.t1 VALUES (b'111'); 1575select * FROM federated.t1; 1576bitty 1577 1578 1579 1580 1581 1582 1583 1584drop table federated.t1; 1585connection slave; 1586drop table federated.t1; 1587connection slave; 1588DROP TABLE IF EXISTS federated.t1; 1589Warnings: 1590Note 1051 Unknown table 'federated.t1' 1591CREATE TABLE federated.t1 ( 1592`id` int(20) NOT NULL auto_increment, 1593PRIMARY KEY (`id`)); 1594connection master; 1595DROP TABLE IF EXISTS federated.t1; 1596Warnings: 1597Note 1051 Unknown table 'federated.t1' 1598CREATE TABLE federated.t1 ( 1599`id` int(20) NOT NULL auto_increment, 1600PRIMARY KEY (`id`) 1601) 1602ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1603CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1604INSERT INTO federated.t1 VALUES (); 1605SELECT LAST_INSERT_ID(); 1606LAST_INSERT_ID() 16071 1608INSERT INTO federated.t1 VALUES (); 1609SELECT LAST_INSERT_ID(); 1610LAST_INSERT_ID() 16112 1612INSERT INTO federated.t1 VALUES (); 1613SELECT LAST_INSERT_ID(); 1614LAST_INSERT_ID() 16153 1616INSERT INTO federated.t1 VALUES (); 1617SELECT LAST_INSERT_ID(); 1618LAST_INSERT_ID() 16194 1620INSERT INTO federated.t1 VALUES (); 1621SELECT LAST_INSERT_ID(); 1622LAST_INSERT_ID() 16235 1624SELECT * FROM federated.t1; 1625id 16261 16272 16283 16294 16305 1631DROP TABLE federated.t1; 1632connection slave; 1633DROP TABLE federated.t1; 1634connection slave; 1635DROP TABLE IF EXISTS federated.bug_17377_table; 1636CREATE TABLE federated.bug_17377_table ( 1637`fld_cid` bigint(20) NOT NULL auto_increment, 1638`fld_name` varchar(255) NOT NULL default '', 1639`fld_parentid` bigint(20) NOT NULL default '0', 1640`fld_delt` int(1) NOT NULL default '0', 1641PRIMARY KEY (`fld_cid`), 1642KEY `fld_parentid` (`fld_parentid`), 1643KEY `fld_delt` (`fld_delt`), 1644KEY `fld_cid` (`fld_cid`) 1645) ENGINE=MyISAM; 1646insert into federated.bug_17377_table( fld_name ) 1647values 1648("Mats"), ("Sivert"), ("Sigvard"), ("Torgny"), ("Torkel"); 1649connection master; 1650DROP TABLE IF EXISTS federated.t1; 1651CREATE TABLE federated.t1 ( 1652`fld_cid` bigint(20) NOT NULL auto_increment, 1653`fld_name` varchar(255) NOT NULL default '', 1654`fld_parentid` bigint(20) NOT NULL default '0', 1655`fld_delt` int(1) NOT NULL default '0', 1656PRIMARY KEY (`fld_cid`), 1657KEY `fld_parentid` (`fld_parentid`), 1658KEY `fld_delt` (`fld_delt`), 1659KEY `fld_cid` (`fld_cid`) 1660) ENGINE=FEDERATED 1661CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/bug_17377_table'; 1662select * from federated.t1 where fld_parentid=0 and fld_delt=0 1663order by fld_name; 1664fld_cid fld_name fld_parentid fld_delt 16651 Mats 0 0 16663 Sigvard 0 0 16672 Sivert 0 0 16684 Torgny 0 0 16695 Torkel 0 0 1670select * from federated.t1 where fld_parentid=0 and fld_delt=0; 1671fld_cid fld_name fld_parentid fld_delt 16721 Mats 0 0 16732 Sivert 0 0 16743 Sigvard 0 0 16754 Torgny 0 0 16765 Torkel 0 0 1677DROP TABLE federated.t1; 1678connection slave; 1679DROP TABLE federated.bug_17377_table; 1680connection slave; 1681DROP TABLE IF EXISTS federated.test; 1682CREATE TABLE federated.test ( 1683`id` int(11) NOT NULL, 1684`val1` varchar(255) NOT NULL, 1685`val2` varchar(255) NOT NULL, 1686PRIMARY KEY (`id`) 1687) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1688connection master; 1689DROP TABLE IF EXISTS federated.test_local; 1690DROP TABLE IF EXISTS federated.test_remote; 1691CREATE TABLE federated.test_local ( 1692`id` int(11) NOT NULL, 1693`val1` varchar(255) NOT NULL, 1694`val2` varchar(255) NOT NULL, 1695PRIMARY KEY (`id`) 1696) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1697INSERT INTO federated.test_local VALUES (1, 'foo', 'bar'), 1698(2, 'bar', 'foo'); 1699CREATE TABLE federated.test_remote ( 1700`id` int(11) NOT NULL, 1701`val1` varchar(255) NOT NULL, 1702`val2` varchar(255) NOT NULL, 1703PRIMARY KEY (`id`) 1704) ENGINE=FEDERATED DEFAULT CHARSET=latin1 1705CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/test'; 1706insert into federated.test_remote select * from federated.test_local; 1707select * from federated.test_remote; 1708id val1 val2 17091 foo bar 17102 bar foo 1711delete from federated.test_remote where id in (1,2); 1712insert into federated.test_remote select * from federated.test_local; 1713select * from federated.test_remote; 1714id val1 val2 17152 bar foo 17161 foo bar 1717DROP TABLE federated.test_local; 1718DROP TABLE federated.test_remote; 1719connection slave; 1720DROP TABLE federated.test; 1721connection slave; 1722drop table if exists federated.t1; 1723create table federated.t1 (a int, b int, c int); 1724connection master; 1725drop table if exists federated.t1; 1726drop table if exists federated.t2; 1727create table federated.t1 (a int, b int, c int) engine=federated connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1728create trigger federated.t1_bi before insert on federated.t1 for each row set new.c= new.a * new.b; 1729create table federated.t2 (a int, b int); 1730insert into federated.t2 values (13, 17), (19, 23); 1731insert into federated.t1 (a, b) values (1, 2), (3, 5), (7, 11); 1732select * from federated.t1 order by a; 1733a b c 17341 2 2 17353 5 15 17367 11 77 1737delete from federated.t1; 1738insert into federated.t1 (a, b) select * from federated.t2; 1739select * from federated.t1 order by a; 1740a b c 174113 17 221 174219 23 437 1743delete from federated.t1; 1744load data infile '../../std_data/loaddata5.dat' into table federated.t1 fields terminated by '' enclosed by '' ignore 1 lines (a, b); 1745Warnings: 1746Note 1265 Data truncated for column 'a' at row 1 1747Note 1265 Data truncated for column 'b' at row 1 1748Note 1265 Data truncated for column 'a' at row 2 1749Note 1265 Data truncated for column 'b' at row 2 1750select * from federated.t1 order by a; 1751a b c 17523 4 12 17535 6 30 1754drop tables federated.t1, federated.t2; 1755connection slave; 1756drop table federated.t1; 1757connection slave; 1758create table federated.t1 (i1 int, i2 int, i3 int); 1759create table federated.t2 (id int, c1 varchar(20), c2 varchar(20)); 1760connection master; 1761create table federated.t1 (i1 int, i2 int, i3 int) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1762create table federated.t2 (id int, c1 varchar(20), c2 varchar(20)) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t2'; 1763insert into federated.t1 values (1,5,10),(3,7,12),(4,5,2),(9,10,15),(2,2,2); 1764insert into federated.t2 values (9,"abc","def"),(5,"opq","lmn"),(2,"test t","t test"); 1765select * from federated.t1 order by i1; 1766i1 i2 i3 17671 5 10 17682 2 2 17693 7 12 17704 5 2 17719 10 15 1772select * from federated.t2; 1773id c1 c2 17749 abc def 17755 opq lmn 17762 test t t test 1777update federated.t1,federated.t2 set t1.i2=15, t2.c2="ppc" where t1.i1=t2.id; 1778select * from federated.t1 order by i1; 1779i1 i2 i3 17801 5 10 17812 15 2 17823 7 12 17834 5 2 17849 15 15 1785select * from federated.t2 order by id; 1786id c1 c2 17872 test t ppc 17885 opq lmn 17899 abc ppc 1790delete federated.t1.*,federated.t2.* from federated.t1,federated.t2 where t1.i2=t2.id; 1791select * from federated.t1 order by i1; 1792i1 i2 i3 17932 15 2 17943 7 12 17959 15 15 1796select * from federated.t2 order by id; 1797id c1 c2 17982 test t ppc 17999 abc ppc 1800drop table federated.t1, federated.t2; 1801connection slave; 1802drop table federated.t1, federated.t2; 1803connection slave; 1804create table federated.t1 (i1 int, i2 int, i3 int, primary key (i1)); 1805create table federated.t2 (id int, c1 varchar(20), c2 varchar(20), primary key (id)); 1806connection master; 1807create table federated.t1 (i1 int auto_increment not null, i2 int, i3 int, primary key (i1)) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1808create table federated.t2 (id int auto_increment not null, c1 varchar(20), c2 varchar(20), primary key(id)) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t2'; 1809insert into federated.t1 values (1,5,10),(3,7,12),(4,5,2),(9,10,15),(2,2,2); 1810insert into federated.t2 values (9,"abc","def"),(5,"opq","lmn"),(2,"test t","t test"); 1811select * from federated.t1 order by i1; 1812i1 i2 i3 18131 5 10 18142 2 2 18153 7 12 18164 5 2 18179 10 15 1818select * from federated.t2 order by id; 1819id c1 c2 18202 test t t test 18215 opq lmn 18229 abc def 1823update federated.t1,federated.t2 set t1.i2=15, t2.c2="ppc" where t1.i1=t2.id; 1824select * from federated.t1 order by i1; 1825i1 i2 i3 18261 5 10 18272 15 2 18283 7 12 18294 5 2 18309 15 15 1831select * from federated.t2 order by id; 1832id c1 c2 18332 test t ppc 18345 opq lmn 18359 abc ppc 1836delete federated.t1.*,federated.t2.* from federated.t1,federated.t2 where t1.i2=t2.id; 1837select * from federated.t1 order by i1; 1838i1 i2 i3 18392 15 2 18403 7 12 18419 15 15 1842select * from federated.t2 order by id; 1843id c1 c2 18442 test t ppc 18459 abc ppc 1846drop table federated.t1, federated.t2; 1847connection slave; 1848drop table federated.t1, federated.t2; 1849connection slave; 1850create table t1 (id int not null auto_increment primary key, val int); 1851connection master; 1852create table t1 1853(id int not null auto_increment primary key, val int) engine=federated 1854connection='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 1855insert into t1 values (1,0),(2,0); 1856update t1 set val = NULL where id = 1; 1857select * from t1; 1858id val 18591 NULL 18602 0 1861connection slave; 1862select * from t1; 1863id val 18641 NULL 18652 0 1866drop table t1; 1867connection master; 1868drop table t1; 1869connection slave; 1870create table t1 (a longblob not null); 1871connection master; 1872create table t1 1873(a longblob not null) engine=federated 1874connection='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 1875insert into t1 values (repeat('a',5000)); 1876select length(a) from t1; 1877length(a) 18785000 1879connection slave; 1880select length(a) from t1; 1881length(a) 18825000 1883drop table t1; 1884connection master; 1885drop table t1; 1886connection slave; 1887set sql_mode=""; 1888DROP TABLE IF EXISTS federated.test; 1889CREATE TABLE federated.test ( 1890`i` int(11) NOT NULL, 1891`j` int(11) NOT NULL, 1892`c` varchar(30) default NULL, 1893PRIMARY KEY (`i`,`j`), 1894UNIQUE KEY `i` (`i`,`c`) 1895) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1896set sql_mode=default; 1897connection master; 1898DROP TABLE IF EXISTS federated.test1; 1899DROP TABLE IF EXISTS federated.test2; 1900create table federated.test1 ( 1901i int not null, 1902j int not null, 1903c varchar(30), 1904primary key (i,j), 1905unique key (i, c)) 1906engine = federated 1907connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/test'; 1908create table federated.test2 ( 1909i int default null, 1910j int not null, 1911c varchar(30), 1912key (i)) 1913engine = federated 1914connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/test'; 1915drop table federated.test1, federated.test2; 1916connection slave; 1917drop table federated.test; 1918connection slave; 1919set names utf8; 1920create table federated.t1 (a varchar(64)) DEFAULT CHARSET=utf8; 1921insert into federated.t1 values (0x6DC3A56E6164); 1922select hex(a) from federated.t1; 1923hex(a) 19246DC3A56E6164 1925connection master; 1926create table federated.t1 (a varchar(64)) 1927ENGINE=FEDERATED 1928connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1929DEFAULT CHARSET=utf8; 1930set names utf8; 1931select hex(a) from federated.t1; 1932hex(a) 19336DC3A56E6164 1934insert into federated.t1 values (0xC3A4C3B6C3BCC39F); 1935insert into federated.t1 values (0xD18DD184D184D0B5D0BAD182D0B8D0B2D0BDD183D18E); 1936select hex(a) from federated.t1; 1937hex(a) 19386DC3A56E6164 1939C3A4C3B6C3BCC39F 1940D18DD184D184D0B5D0BAD182D0B8D0B2D0BDD183D18E 1941connection slave; 1942select hex(a) from federated.t1; 1943hex(a) 19446DC3A56E6164 1945C3A4C3B6C3BCC39F 1946D18DD184D184D0B5D0BAD182D0B8D0B2D0BDD183D18E 1947connection master; 1948drop table federated.t1; 1949connection slave; 1950drop table federated.t1; 1951connection slave; 1952CREATE TABLE federated.t1 ( 1953categoryId int(11) NOT NULL AUTO_INCREMENT, 1954domainId varchar(745) NOT NULL DEFAULT '', 1955categoryName varchar(255) NOT NULL DEFAULT '', 1956PRIMARY KEY (categoryId), 1957UNIQUE KEY idx_unique_category_categoryName (domainId, categoryName), 1958KEY idx_category_domainId (domainId) 1959) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1960connection master; 1961CREATE TABLE federated.t1 ( 1962categoryId int(11) NOT NULL AUTO_INCREMENT, 1963domainId varchar(745) NOT NULL DEFAULT '', 1964categoryName varchar(255) NOT NULL DEFAULT '', 1965PRIMARY KEY (categoryId), 1966UNIQUE KEY idx_unique_category_categoryName (domainId, categoryName), 1967KEY idx_category_domainId (domainId) 1968) ENGINE=FEDERATED DEFAULT CHARSET=latin1 1969CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1970insert into federated.t1 (domainId, categoryName) values ( '1231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231 300', '1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345 250'); 1971insert into federated.t1 (domainId, categoryName) values ( '12312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312 301', '12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456 250'); 1972insert into federated.t1 (domainId, categoryName) values ('a', 'b'); 1973select categoryId from federated.t1 order by domainId, categoryName; 1974categoryId 19751 19762 19773 1978select categoryId from federated.t1 where domainId='a' and categoryName='b' order by categoryId; 1979categoryId 19803 1981select categoryId from federated.t1 where domainId='a' and categoryName='b' order by categoryId; 1982categoryId 19833 1984select categoryId from federated.t1 where domainId<>'a' and categoryName<>'b' order by categoryId; 1985categoryId 19861 19872 1988drop table federated.t1; 1989connection slave; 1990drop table federated.t1; 1991connection slave; 1992create table federated.t1 (a int primary key, b varchar(64)) 1993DEFAULT CHARSET=utf8; 1994connection master; 1995create table federated.t1 (a int primary key, b varchar(64)) 1996ENGINE=FEDERATED 1997connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1998 DEFAULT CHARSET=utf8; 1999insert ignore into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe"); 2000select * from federated.t1; 2001a b 20021 Larry 20032 Curly 2004truncate federated.t1; 2005replace into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe"); 2006select * from federated.t1; 2007a b 20081 Moe 20092 Curly 2010update ignore federated.t1 set a=a+1; 2011select * from federated.t1; 2012a b 20131 Moe 20143 Curly 2015drop table federated.t1; 2016connection slave; 2017drop table federated.t1; 2018connection slave; 2019create table federated.t1 (a int primary key, b varchar(64)) 2020DEFAULT CHARSET=utf8; 2021connection master; 2022create table federated.t1 (a int primary key, b varchar(64)) 2023ENGINE=FEDERATED 2024connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 2025 DEFAULT CHARSET=utf8; 2026insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe") 2027on duplicate key update a=a+100; 2028ERROR 23000: Can't write; duplicate key in table 't1' 2029select * from federated.t1; 2030a b 20311 Larry 20322 Curly 2033drop table federated.t1; 2034connection slave; 2035drop table federated.t1; 2036 2037Bug#18287 create federated table always times out, error 1159 ' ' 2038 2039Test that self-references work 2040 2041fix LOCK_open before reenabling test for Bug#18287 2042connection slave; 2043CREATE TABLE federated.t1 (a INT PRIMARY KEY) DEFAULT CHARSET=utf8; 2044connection master; 2045CREATE TABLE federated.t1 (a INT PRIMARY KEY) 2046ENGINE=FEDERATED 2047CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 2048 DEFAULT CHARSET=utf8; 2049SELECT transactions FROM information_schema.engines WHERE engine="FEDERATED"; 2050transactions 2051YES 2052INSERT INTO federated.t1 VALUES (1); 2053SET autocommit=0; 2054INSERT INTO federated.t1 VALUES (2); 2055ROLLBACK; 2056SET autocommit=1; 2057SELECT * FROM federated.t1; 2058a 20591 20602 2061DROP TABLE federated.t1; 2062connection slave; 2063DROP TABLE federated.t1; 2064connection slave; 2065create table t1 (a varchar(256)); 2066drop view if exists v1; 2067create view v1 as select a from t1; 2068connection master; 2069create table t1 2070(a varchar(256)) engine=federated 2071connection='mysql://root@127.0.0.1:SLAVE_PORT/test/v1'; 2072select 1 from t1 order by a; 20731 20741 20751 20761 20771 20781 20791 20801 20811 20821 20831 20841 20851 20861 20871 20881 20891 20901 20911 20921 20931 20941 20951 20961 20971 20981 20991 21001 21011 21021 21031 21041 21051 21061 21071 21081 21091 21101 21111 21121 21131 21141 21151 21161 21171 21181 21191 21201 21211 21221 21231 21241 21251 21261 21271 21281 21291 21301 21311 21321 21331 21341 21351 21361 21371 21381 21391 21401 21411 21421 21431 21441 21451 21461 21471 21481 21491 21501 21511 21521 21531 21541 21551 21561 21571 21581 21591 21601 21611 21621 21631 21641 21651 21661 21671 21681 21691 21701 21711 21721 21731 2174drop table t1; 2175connection slave; 2176drop table t1; 2177drop view v1; 2178connection slave; 2179CREATE TABLE t1 (a INT, b INT, KEY(a,b)); 2180INSERT INTO t1 VALUES(NULL,1),(1,NULL),(NULL,NULL),(1,1),(2,2); 2181connection master; 2182CREATE TABLE t1 (a INT, b INT, KEY(a,b)) ENGINE=federated 2183CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2184SELECT * FROM t1 WHERE a IS NULL; 2185a b 2186NULL NULL 2187NULL 1 2188SELECT * FROM t1 WHERE a IS NOT NULL; 2189a b 21901 NULL 21911 1 21922 2 2193SELECT * FROM t1 WHERE a=1 AND b=1; 2194a b 21951 1 2196SELECT * FROM t1 WHERE a IS NULL AND b=1; 2197a b 2198NULL 1 2199SELECT * FROM t1 WHERE a IS NOT NULL AND b=1; 2200a b 22011 1 2202DROP TABLE t1; 2203connection slave; 2204DROP TABLE t1; 2205CREATE TABLE t1 (a INT) ENGINE=federated CONNECTION='mysql://@:://'; 2206DROP TABLE t1; 2207connection slave; 2208CREATE TABLE t1 (a LONGBLOB, b LONGBLOB); 2209INSERT INTO t1 VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaa', NULL); 2210connection master; 2211CREATE TABLE t1 2212(a LONGBLOB, b LONGBLOB) ENGINE=FEDERATED 2213CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2214CHECKSUM TABLE t1; 2215Table Checksum 2216test.t1 2465757603 2217connection slave; 2218DROP TABLE t1; 2219connection master; 2220DROP TABLE t1; 2221connection slave; 2222CREATE TABLE t1 (a TEXT, b TEXT, KEY(b(1))); 2223INSERT INTO t1 VALUES (NULL, NULL), (NULL, NULL), (NULL, NULL), (NULL, NULL); 2224connection master; 2225CREATE TABLE t1 2226(a TEXT, b TEXT, KEY(b(1))) ENGINE=FEDERATED 2227CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2228SELECT t1.a FROM t1, t1 as t2 WHERE t2.b NOT LIKE t1.b; 2229a 2230connection slave; 2231DROP TABLE t1; 2232connection master; 2233DROP TABLE t1; 2234# 2235# BUG#21360 - mysqldump error on federated tables 2236# 2237connection slave; 2238#Switch to Connection Slave 2239CREATE TABLE t1(id VARCHAR(20) NOT NULL, PRIMARY KEY(id)); 2240INSERT INTO t1 VALUES ('text1'),('text2'),('text3'),('text4'); 2241connection master; 2242#Switch to Connection Master 2243CREATE TABLE t1(id VARCHAR(20) NOT NULL, PRIMARY KEY(id)) ENGINE=FEDERATED 2244CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2245# Dump table t1 using mysqldump tool 2246/*!40101 SET @saved_cs_client = @@character_set_client */; 2247/*!40101 SET character_set_client = utf8 */; 2248CREATE TABLE `t1` ( 2249 `id` varchar(20) NOT NULL, 2250 PRIMARY KEY (`id`) 2251) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2252/*!40101 SET character_set_client = @saved_cs_client */; 2253DROP TABLE t1; 2254connection slave; 2255#Switch to Connection Slave 2256DROP TABLE t1; 2257connection default; 2258End of 5.0 tests 2259create server 's1' foreign data wrapper 'mysql' options (host 'foo'); 2260drop server 's1'; 2261# 2262# Bug #32426: FEDERATED query returns corrupt results for ORDER BY on a TEXT 2263# 2264connection slave; 2265CREATE TABLE federated.t1(a TEXT); 2266INSERT INTO federated.t1 VALUES('abc'), ('gh'), ('f'), ('ijk'), ('de'); 2267connection master; 2268CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED 2269CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 2270DROP TABLE federated.t1; 2271connection slave; 2272DROP TABLE federated.t1; 2273connection default; 2274End of 5.1 tests 2275SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT; 2276connection slave; 2277SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT; 2278connection default; 2279# 2280# MDEV-9346 - The federatedx and spider engine make mysqld crash when 2281# they are configured withtout username 2282# 2283connection master; 2284CREATE TABLE t1 (a INT) ENGINE=FEDERATED CONNECTION='mysql://@127.0.0.1:SLAVE_PORT/federated/t1'; 2285ERROR HY000: Can't create federated table. Foreign data src error: database: 'federated' username: '' hostname: '127.0.0.1' 2286# 2287# MDEV-17573 Assertion in federatedx on multi-update 2288# 2289create table t1 ( 2290x int, 2291d datetime); 2292create table t1f engine=FEDERATED connection='mysql://root@127.0.0.1:MASTER_MYPORT/test/t1'; 2293create table t2 ( 2294x int, y int, 2295d datetime); 2296create table t2f engine=FEDERATED connection='mysql://root@127.0.0.1:MASTER_MYPORT/test/t2'; 2297create table t3 ( 2298x int, y int, z int, 2299d datetime); 2300create table t3f engine=FEDERATED connection='mysql://root@127.0.0.1:MASTER_MYPORT/test/t3'; 2301insert into t1 values (1, "1990-01-01 00:00"); 2302insert into t1 values (1, "1991-01-01 11:11"); 2303insert into t2 values (2, 2, "1992-02-02 22:22"); 2304insert into t3 values (3, 3, 3, "1993-03-03 23:33"); 2305update t1f, t2f, t3f set t1f.x= 11, t2f.y= 22, t3f.z= 33; 2306drop table t1f; 2307drop table t2f; 2308drop table t3f; 2309drop table t1; 2310drop table t2; 2311drop table t3; 2312# 2313# MDEV-21049 Segfault in create federatedx table with empty hostname 2314# 2315connection master; 2316CREATE TABLE federated.t1 (x int) ENGINE=FEDERATED 2317CONNECTION='mysql://root@:SLAVE_PORT/federated/t1'; 2318ERROR HY000: Can't create federated table. Foreign data src error: database: 'federated' username: 'root' hostname: 'localhost' 2319connection slave; 2320CREATE TABLE federated.t1(x int); 2321connection master; 2322CREATE TABLE federated.t1 (x int) ENGINE=FEDERATED 2323CONNECTION='mysql://root@:SLAVE_PORT/federated/t1'; 2324DROP TABLE federated.t1; 2325connection slave; 2326DROP TABLE federated.t1; 2327connection default; 2328connection master; 2329DROP TABLE IF EXISTS federated.t1; 2330DROP DATABASE IF EXISTS federated; 2331connection slave; 2332DROP TABLE IF EXISTS federated.t1; 2333DROP DATABASE IF EXISTS federated; 2334