1CREATE DATABASE federated; 2CREATE DATABASE federated; 3SET @OLD_MASTER_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT; 4SET @@GLOBAL.CONCURRENT_INSERT= 0; 5SET @OLD_SLAVE_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT; 6SET @@GLOBAL.CONCURRENT_INSERT= 0; 7DROP TABLE IF EXISTS federated.t1; 8Warnings: 9Note 1051 Unknown table 'federated.t1' 10CREATE TABLE federated.t1 ( 11`id` int(20) NOT NULL, 12`group` int NOT NULL default 0, 13`a\\b` int NOT NULL default 0, 14`a\\` int NOT NULL default 0, 15`name` varchar(32) NOT NULL default '' 16 ) 17DEFAULT CHARSET=latin1; 18DROP TABLE IF EXISTS federated.t1; 19Warnings: 20Note 1051 Unknown table 'federated.t1' 21CREATE TABLE federated.t1 ( 22`id` int(20) NOT NULL, 23`group` int NOT NULL default 0, 24`a\\b` inT NOT NULL default 0, 25`a\\` int NOT NULL default 0, 26`name` varchar(32) NOT NULL default '' 27 ) 28ENGINE="FEDERATED" DEFAULT CHARSET=latin1 29CONNECTION='mysql://root@127.0.0.1:@/too/many/items/federated/t1'; 30ERROR 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 31CREATE TABLE federated.t1 ( 32`id` int(20) NOT NULL, 33`group` int NOT NULL default 0, 34`a\\b` iNt NOT NULL default 0, 35`a\\` int NOT NULL default 0, 36`name` varchar(32) NOT NULL default '' 37 ) 38ENGINE="FEDERATED" DEFAULT CHARSET=latin1 39CONNECTION='mysql://root@127.0.0.1'; 40ERROR HY000: Can't create federated table. The data source connection string 'mysql://root@127.0.0.1' is not in the correct format 41CREATE TABLE federated.t1 ( 42`id` int(20) NOT NULL, 43`group` int NOT NULL default 0, 44`a\\b` iNT NOT NULL default 0, 45`a\\` int NOT NULL default 0, 46`name` varchar(32) NOT NULL default '' 47 ) 48ENGINE="FEDERATED" DEFAULT CHARSET=latin1 49CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t3'; 50SELECT * FROM federated.t1; 51ERROR HY000: The foreign data source you are trying to reference does not exist. Data source error: error: 1146 'Table 'federated.t3' doesn't exist' 52DROP TABLE federated.t1; 53CREATE TABLE federated.t1 ( 54`id` int(20) NOT NULL, 55`group` int NOT NULL default 0, 56`a\\b` Int NOT NULL default 0, 57`a\\` int NOT NULL default 0, 58`name` varchar(32) NOT NULL default '' 59 ) 60ENGINE="FEDERATED" DEFAULT CHARSET=latin1 61CONNECTION='mysql://user:pass@127.0.0.1:SLAVE_PORT/federated/t1'; 62SELECT * FROM federated.t1; 63ERROR HY000: Unable to connect to foreign data source: Access denied for user 'user'@'localhost' (using password: YES) 64DROP TABLE federated.t1; 65CREATE TABLE federated.t1 ( 66`id` int(20) NOT NULL, 67`group` int NOT NULL default 0, 68`a\\b` InT NOT NULL default 0, 69`a\\` int NOT NULL default 0, 70`name` varchar(32) NOT NULL default '' 71 ) 72ENGINE="FEDERATED" DEFAULT CHARSET=latin1 73CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 74INSERT INTO federated.t1 (id, name) VALUES (1, 'foo'); 75INSERT INTO federated.t1 (id, name) VALUES (2, 'fee'); 76INSERT INTO federated.t1 (id, `group`) VALUES (3, 42); 77INSERT INTO federated.t1 (id, `a\\b`) VALUES (4, 23); 78INSERT INTO federated.t1 (id, `a\\`) VALUES (5, 1); 79SELECT * FROM federated.t1; 80id group a\\b a\\ name 811 0 0 0 foo 822 0 0 0 fee 833 42 0 0 844 0 23 0 855 0 0 1 86DELETE FROM federated.t1; 87DROP TABLE federated.t1; 88DROP TABLE IF EXISTS federated.t2; 89Warnings: 90Note 1051 Unknown table 'federated.t2' 91CREATE TABLE federated.t2 ( 92`id` int(20) NOT NULL, 93`name` varchar(32) NOT NULL default '' 94 ) 95ENGINE="FEDERATED" DEFAULT CHARSET=latin1 96CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 97SHOW CREATE TABLE federated.t2; 98Table Create Table 99t2 CREATE TABLE `t2` ( 100 `id` int(20) NOT NULL, 101 `name` varchar(32) NOT NULL DEFAULT '' 102) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 103INSERT INTO federated.t2 (id, name) VALUES (1, 'foo'); 104INSERT INTO federated.t2 (id, name) VALUES (2, 'fee'); 105SELECT * FROM federated.t2 ORDER BY id, name; 106id name 1071 foo 1082 fee 109DROP TABLE federated.t2; 110DROP TABLE IF EXISTS federated.t1; 111DROP TABLE IF EXISTS federated.`t1%`; 112Warnings: 113Note 1051 Unknown table 'federated.t1%' 114CREATE TABLE federated.`t1%` ( 115`id` int(20) NOT NULL, 116`name` varchar(32) NOT NULL default '' 117 ) 118DEFAULT CHARSET=latin1; 119DROP TABLE IF EXISTS federated.t1; 120Warnings: 121Note 1051 Unknown table 'federated.t1' 122CREATE TABLE federated.t1 ( 123`id` int(20) NOT NULL, 124`name` varchar(32) NOT NULL default '' 125 ) 126ENGINE="FEDERATED" DEFAULT CHARSET=latin1 127CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1%'; 128INSERT INTO federated.t1 (id, name) VALUES (1, 'foo'); 129INSERT INTO federated.t1 (id, name) VALUES (2, 'fee'); 130SELECT * FROM federated.t1 ORDER BY id,name; 131id name 1321 foo 1332 fee 134DELETE FROM federated.t1; 135DROP TABLE IF EXISTS federated.t1; 136CREATE TABLE federated.`t1%` ( 137`id` int(20) NOT NULL, 138`name` varchar(32) NOT NULL default '' 139 ) 140ENGINE="FEDERATED" DEFAULT CHARSET=latin1 141CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1%'; 142INSERT INTO federated.`t1%` (id, name) VALUES (1, 'foo'); 143INSERT INTO federated.`t1%` (id, name) VALUES (2, 'fee'); 144SELECT * FROM federated.`t1%` ORDER BY id, name; 145id name 1461 foo 1472 fee 148DELETE FROM federated.`t1%`; 149DROP TABLE IF EXISTS federated.`t1%`; 150DROP TABLE IF EXISTS federated.`t1%`; 151DROP TABLE IF EXISTS federated.t1; 152Warnings: 153Note 1051 Unknown table 'federated.t1' 154CREATE TABLE federated.t1 ( 155`id` int(20) NOT NULL auto_increment, 156`name` varchar(32) NOT NULL default '', 157`other` int(20) NOT NULL default '0', 158`created` datetime default '2004-04-04 04:04:04', 159PRIMARY KEY (`id`)) 160DEFAULT CHARSET=latin1; 161CREATE TABLE federated.t1 ( 162`id` int(20) NOT NULL auto_increment, 163`name` varchar(32) NOT NULL default '', 164`other` int(20) NOT NULL default '0', 165`created` datetime default '2004-04-04 04:04:04', 166PRIMARY KEY (`id`)) 167ENGINE="FEDERATED" DEFAULT CHARSET=latin1 168CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 169INSERT INTO federated.t1 (name, other) VALUES ('First Name', 11111); 170INSERT INTO federated.t1 (name, other) VALUES ('Second Name', 22222); 171INSERT INTO federated.t1 (name, other) VALUES ('Third Name', 33333); 172INSERT INTO federated.t1 (name, other) VALUES ('Fourth Name', 44444); 173INSERT INTO federated.t1 (name, other) VALUES ('Fifth Name', 55555); 174INSERT INTO federated.t1 (name, other) VALUES ('Sixth Name', 66666); 175INSERT INTO federated.t1 (name, other) VALUES ('Seventh Name', 77777); 176INSERT INTO federated.t1 (name, other) VALUES ('Eigth Name', 88888); 177INSERT INTO federated.t1 (name, other) VALUES ('Ninth Name', 99999); 178INSERT INTO federated.t1 (name, other) VALUES ('Tenth Name', 101010); 179SELECT * FROM federated.t1; 180id name other created 1811 First Name 11111 2004-04-04 04:04:04 18210 Tenth Name 101010 2004-04-04 04:04:04 1832 Second Name 22222 2004-04-04 04:04:04 1843 Third Name 33333 2004-04-04 04:04:04 1854 Fourth Name 44444 2004-04-04 04:04:04 1865 Fifth Name 55555 2004-04-04 04:04:04 1876 Sixth Name 66666 2004-04-04 04:04:04 1887 Seventh Name 77777 2004-04-04 04:04:04 1898 Eigth Name 88888 2004-04-04 04:04:04 1909 Ninth Name 99999 2004-04-04 04:04:04 191SELECT * FROM federated.t1 WHERE id = 5; 192id name other created 1935 Fifth Name 55555 2004-04-04 04:04:04 194SELECT * FROM federated.t1 WHERE name = 'Sixth Name'; 195id name other created 1966 Sixth Name 66666 2004-04-04 04:04:04 197SELECT * FROM federated.t1 WHERE id = 6 and name = 'Sixth Name'; 198id name other created 1996 Sixth Name 66666 2004-04-04 04:04:04 200SELECT * FROM federated.t1 WHERE name = 'Sixth Name' AND other = 44444; 201id name other created 202SELECT * FROM federated.t1 WHERE name like '%th%'; 203id name other created 20410 Tenth Name 101010 2004-04-04 04:04:04 2053 Third Name 33333 2004-04-04 04:04:04 2064 Fourth Name 44444 2004-04-04 04:04:04 2075 Fifth Name 55555 2004-04-04 04:04:04 2086 Sixth Name 66666 2004-04-04 04:04:04 2097 Seventh Name 77777 2004-04-04 04:04:04 2108 Eigth Name 88888 2004-04-04 04:04:04 2119 Ninth Name 99999 2004-04-04 04:04:04 212UPDATE federated.t1 SET name = '3rd name' WHERE id = 3; 213SELECT * FROM federated.t1 WHERE name = '3rd name'; 214id name other created 2153 3rd name 33333 2004-04-04 04:04:04 216UPDATE federated.t1 SET name = 'Third name' WHERE name = '3rd name'; 217SELECT * FROM federated.t1 WHERE name = 'Third name'; 218id name other created 2193 Third name 33333 2004-04-04 04:04:04 220SELECT * FROM federated.t1 ORDER BY id DESC; 221id name other created 22210 Tenth Name 101010 2004-04-04 04:04:04 2239 Ninth Name 99999 2004-04-04 04:04:04 2248 Eigth Name 88888 2004-04-04 04:04:04 2257 Seventh Name 77777 2004-04-04 04:04:04 2266 Sixth Name 66666 2004-04-04 04:04:04 2275 Fifth Name 55555 2004-04-04 04:04:04 2284 Fourth Name 44444 2004-04-04 04:04:04 2293 Third name 33333 2004-04-04 04:04:04 2302 Second Name 22222 2004-04-04 04:04:04 2311 First Name 11111 2004-04-04 04:04:04 232SELECT * FROM federated.t1 ORDER BY name; 233id name other created 2348 Eigth Name 88888 2004-04-04 04:04:04 2355 Fifth Name 55555 2004-04-04 04:04:04 2361 First Name 11111 2004-04-04 04:04:04 2374 Fourth Name 44444 2004-04-04 04:04:04 2389 Ninth Name 99999 2004-04-04 04:04:04 2392 Second Name 22222 2004-04-04 04:04:04 2407 Seventh Name 77777 2004-04-04 04:04:04 2416 Sixth Name 66666 2004-04-04 04:04:04 24210 Tenth Name 101010 2004-04-04 04:04:04 2433 Third name 33333 2004-04-04 04:04:04 244SELECT * FROM federated.t1 ORDER BY name DESC; 245id name other created 2463 Third name 33333 2004-04-04 04:04:04 24710 Tenth Name 101010 2004-04-04 04:04:04 2486 Sixth Name 66666 2004-04-04 04:04:04 2497 Seventh Name 77777 2004-04-04 04:04:04 2502 Second Name 22222 2004-04-04 04:04:04 2519 Ninth Name 99999 2004-04-04 04:04:04 2524 Fourth Name 44444 2004-04-04 04:04:04 2531 First Name 11111 2004-04-04 04:04:04 2545 Fifth Name 55555 2004-04-04 04:04:04 2558 Eigth Name 88888 2004-04-04 04:04:04 256SELECT * FROM federated.t1 ORDER BY name ASC; 257id name other created 2588 Eigth Name 88888 2004-04-04 04:04:04 2595 Fifth Name 55555 2004-04-04 04:04:04 2601 First Name 11111 2004-04-04 04:04:04 2614 Fourth Name 44444 2004-04-04 04:04:04 2629 Ninth Name 99999 2004-04-04 04:04:04 2632 Second Name 22222 2004-04-04 04:04:04 2647 Seventh Name 77777 2004-04-04 04:04:04 2656 Sixth Name 66666 2004-04-04 04:04:04 26610 Tenth Name 101010 2004-04-04 04:04:04 2673 Third name 33333 2004-04-04 04:04:04 268SELECT * FROM federated.t1 GROUP BY other; 269id name other created 2701 First Name 11111 2004-04-04 04:04:04 2712 Second Name 22222 2004-04-04 04:04:04 2723 Third name 33333 2004-04-04 04:04:04 2734 Fourth Name 44444 2004-04-04 04:04:04 2745 Fifth Name 55555 2004-04-04 04:04:04 2756 Sixth Name 66666 2004-04-04 04:04:04 2767 Seventh Name 77777 2004-04-04 04:04:04 2778 Eigth Name 88888 2004-04-04 04:04:04 2789 Ninth Name 99999 2004-04-04 04:04:04 27910 Tenth Name 101010 2004-04-04 04:04:04 280DELETE FROM federated.t1 WHERE id = 5; 281SELECT * FROM federated.t1 WHERE id = 5; 282id name other created 283DELETE FROM federated.t1; 284SELECT * FROM federated.t1 WHERE id = 5; 285id name other created 286DROP TABLE IF EXISTS federated.t1; 287CREATE TABLE federated.t1 ( 288`id` int(20) NOT NULL auto_increment, 289`name` varchar(32) NOT NULL default '', 290`other` int(20) NOT NULL default '0', 291`created` datetime NOT NULL, 292PRIMARY KEY (`id`), 293key name(`name`), 294key other(`other`), 295key created(`created`)) 296DEFAULT CHARSET=latin1; 297DROP TABLE IF EXISTS federated.t1; 298CREATE TABLE federated.t1 ( 299`id` int(20) NOT NULL auto_increment, 300`name` varchar(32) NOT NULL default '', 301`other` int(20) NOT NULL default '0', 302`created` datetime NOT NULL, 303PRIMARY KEY (`id`), 304key name(`name`), 305key other(`other`), 306key created(`created`)) 307ENGINE="FEDERATED" DEFAULT CHARSET=latin1 308CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 309INSERT INTO federated.t1 (name, other, created) 310VALUES ('First Name', 11111, '2004-01-01 01:01:01'); 311INSERT INTO federated.t1 (name, other, created) 312VALUES ('Second Name', 22222, '2004-01-23 02:43:00'); 313INSERT INTO federated.t1 (name, other, created) 314VALUES ('Third Name', 33333, '2004-02-14 02:14:00'); 315INSERT INTO federated.t1 (name, other, created) 316VALUES ('Fourth Name', 44444, '2003-04-05 00:00:00'); 317INSERT INTO federated.t1 (name, other, created) 318VALUES ('Fifth Name', 55555, '2001-02-02 02:02:02'); 319INSERT INTO federated.t1 (name, other, created) 320VALUES ('Sixth Name', 66666, '2005-06-06 15:30:00'); 321INSERT INTO federated.t1 (name, other, created) 322VALUES ('Seventh Name', 77777, '2003-12-12 18:32:00'); 323INSERT INTO federated.t1 (name, other, created) 324VALUES ('Eigth Name', 88888, '2005-03-12 11:00:00'); 325INSERT INTO federated.t1 (name, other, created) 326VALUES ('Ninth Name', 99999, '2005-03-12 11:00:01'); 327INSERT INTO federated.t1 (name, other, created) 328VALUES ('Tenth Name', 101010, '2005-03-12 12:00:01'); 329SELECT * FROM federated.t1; 330id name other created 3311 First Name 11111 2004-01-01 01:01:01 33210 Tenth Name 101010 2005-03-12 12:00:01 3332 Second Name 22222 2004-01-23 02:43:00 3343 Third Name 33333 2004-02-14 02:14:00 3354 Fourth Name 44444 2003-04-05 00:00:00 3365 Fifth Name 55555 2001-02-02 02:02:02 3376 Sixth Name 66666 2005-06-06 15:30:00 3387 Seventh Name 77777 2003-12-12 18:32:00 3398 Eigth Name 88888 2005-03-12 11:00:00 3409 Ninth Name 99999 2005-03-12 11:00:01 341SELECT * FROM federated.t1 WHERE id = 5; 342id name other created 3435 Fifth Name 55555 2001-02-02 02:02:02 344SELECT * FROM federated.t1 WHERE id = 6 and name = 'Sixth Name'; 345id name other created 3466 Sixth Name 66666 2005-06-06 15:30:00 347SELECT * FROM federated.t1 WHERE other = 44444; 348id name other created 3494 Fourth Name 44444 2003-04-05 00:00:00 350SELECT * FROM federated.t1 WHERE name like '%th%'; 351id name other created 35210 Tenth Name 101010 2005-03-12 12:00:01 3533 Third Name 33333 2004-02-14 02:14:00 3544 Fourth Name 44444 2003-04-05 00:00:00 3555 Fifth Name 55555 2001-02-02 02:02:02 3566 Sixth Name 66666 2005-06-06 15:30:00 3577 Seventh Name 77777 2003-12-12 18:32:00 3588 Eigth Name 88888 2005-03-12 11:00:00 3599 Ninth Name 99999 2005-03-12 11:00:01 360UPDATE federated.t1 SET name = '3rd name' WHERE id = 3; 361SELECT * FROM federated.t1 WHERE name = '3rd name'; 362id name other created 3633 3rd name 33333 2004-02-14 02:14:00 364UPDATE federated.t1 SET name = 'Third name' WHERE name = '3rd name'; 365SELECT * FROM federated.t1 WHERE name = 'Third name'; 366id name other created 3673 Third name 33333 2004-02-14 02:14:00 368SELECT * FROM federated.t1 ORDER BY id DESC; 369id name other created 37010 Tenth Name 101010 2005-03-12 12:00:01 3719 Ninth Name 99999 2005-03-12 11:00:01 3728 Eigth Name 88888 2005-03-12 11:00:00 3737 Seventh Name 77777 2003-12-12 18:32:00 3746 Sixth Name 66666 2005-06-06 15:30:00 3755 Fifth Name 55555 2001-02-02 02:02:02 3764 Fourth Name 44444 2003-04-05 00:00:00 3773 Third name 33333 2004-02-14 02:14:00 3782 Second Name 22222 2004-01-23 02:43:00 3791 First Name 11111 2004-01-01 01:01:01 380SELECT * FROM federated.t1 ORDER BY name; 381id name other created 3828 Eigth Name 88888 2005-03-12 11:00:00 3835 Fifth Name 55555 2001-02-02 02:02:02 3841 First Name 11111 2004-01-01 01:01:01 3854 Fourth Name 44444 2003-04-05 00:00:00 3869 Ninth Name 99999 2005-03-12 11:00:01 3872 Second Name 22222 2004-01-23 02:43:00 3887 Seventh Name 77777 2003-12-12 18:32:00 3896 Sixth Name 66666 2005-06-06 15:30:00 39010 Tenth Name 101010 2005-03-12 12:00:01 3913 Third name 33333 2004-02-14 02:14:00 392SELECT * FROM federated.t1 ORDER BY name DESC; 393id name other created 3943 Third name 33333 2004-02-14 02:14:00 39510 Tenth Name 101010 2005-03-12 12:00:01 3966 Sixth Name 66666 2005-06-06 15:30:00 3977 Seventh Name 77777 2003-12-12 18:32:00 3982 Second Name 22222 2004-01-23 02:43:00 3999 Ninth Name 99999 2005-03-12 11:00:01 4004 Fourth Name 44444 2003-04-05 00:00:00 4011 First Name 11111 2004-01-01 01:01:01 4025 Fifth Name 55555 2001-02-02 02:02:02 4038 Eigth Name 88888 2005-03-12 11:00:00 404SELECT * FROM federated.t1 ORDER BY name ASC; 405id name other created 4068 Eigth Name 88888 2005-03-12 11:00:00 4075 Fifth Name 55555 2001-02-02 02:02:02 4081 First Name 11111 2004-01-01 01:01:01 4094 Fourth Name 44444 2003-04-05 00:00:00 4109 Ninth Name 99999 2005-03-12 11:00:01 4112 Second Name 22222 2004-01-23 02:43:00 4127 Seventh Name 77777 2003-12-12 18:32:00 4136 Sixth Name 66666 2005-06-06 15:30:00 41410 Tenth Name 101010 2005-03-12 12:00:01 4153 Third name 33333 2004-02-14 02:14:00 416SELECT * FROM federated.t1 GROUP BY other; 417id name other created 4181 First Name 11111 2004-01-01 01:01:01 4192 Second Name 22222 2004-01-23 02:43:00 4203 Third name 33333 2004-02-14 02:14:00 4214 Fourth Name 44444 2003-04-05 00:00:00 4225 Fifth Name 55555 2001-02-02 02:02:02 4236 Sixth Name 66666 2005-06-06 15:30:00 4247 Seventh Name 77777 2003-12-12 18:32:00 4258 Eigth Name 88888 2005-03-12 11:00:00 4269 Ninth Name 99999 2005-03-12 11:00:01 42710 Tenth Name 101010 2005-03-12 12:00:01 428DELETE FROM federated.t1 WHERE id = 5; 429SELECT * FROM federated.t1 WHERE id = 5; 430id name other created 431DELETE FROM federated.t1; 432SELECT * FROM federated.t1 WHERE id = 5; 433id name other created 434DROP TABLE IF EXISTS federated.t1; 435CREATE TABLE federated.t1 ( 436`id` int(20) NOT NULL auto_increment, 437`name` varchar(32), 438`other` varchar(20), 439PRIMARY KEY (`id`) ); 440DROP TABLE IF EXISTS federated.t1; 441CREATE TABLE federated.t1 ( 442`id` int(20) NOT NULL auto_increment, 443`name` varchar(32), 444`other` varchar(20), 445PRIMARY KEY (`id`) ) 446ENGINE="FEDERATED" 447 DEFAULT CHARSET=latin1 448CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 449INSERT INTO federated.t1 (name, other) VALUES ('First Name', 11111); 450INSERT INTO federated.t1 (name, other) VALUES ('Second Name', NULL); 451INSERT INTO federated.t1 (name, other) VALUES ('Third Name', 33333); 452INSERT INTO federated.t1 (name, other) VALUES (NULL, NULL); 453INSERT INTO federated.t1 (name, other) VALUES ('Fifth Name', 55555); 454INSERT INTO federated.t1 (name, other) VALUES ('Sixth Name', 66666); 455INSERT INTO federated.t1 (name) VALUES ('Seventh Name'); 456INSERT INTO federated.t1 (name, other) VALUES ('Eigth Name', 88888); 457INSERT INTO federated.t1 (name, other) VALUES ('Ninth Name', 99999); 458INSERT INTO federated.t1 (other) VALUES ('fee fie foe fum'); 459SELECT * FROM federated.t1 WHERE other IS NULL; 460id name other 4612 Second Name NULL 4624 NULL NULL 4637 Seventh Name NULL 464SELECT * FROM federated.t1 WHERE name IS NULL; 465id name other 46610 NULL fee fie foe fum 4674 NULL NULL 468SELECT * FROM federated.t1 WHERE name IS NULL and other IS NULL; 469id name other 4704 NULL NULL 471SELECT * FROM federated.t1 WHERE name IS NULL or other IS NULL; 472id name other 47310 NULL fee fie foe fum 4742 Second Name NULL 4754 NULL NULL 4767 Seventh Name NULL 477UPDATE federated.t1 478SET name = 'Fourth Name', other = 'four four four' 479WHERE name IS NULL AND other IS NULL; 480UPDATE federated.t1 SET other = 'two two two two' WHERE name = 'Second Name'; 481UPDATE federated.t1 SET other = 'seven seven' WHERE name like 'Sev%'; 482UPDATE federated.t1 SET name = 'Tenth Name' WHERE other like 'fee fie%'; 483SELECT * FROM federated.t1 WHERE name IS NULL OR other IS NULL ; 484id name other 485SELECT * FROM federated.t1; 486id name other 4871 First Name 11111 48810 Tenth Name fee fie foe fum 4892 Second Name two two two two 4903 Third Name 33333 4914 Fourth Name four four four 4925 Fifth Name 55555 4936 Sixth Name 66666 4947 Seventh Name seven seven 4958 Eigth Name 88888 4969 Ninth Name 99999 497DROP TABLE IF EXISTS federated.t1; 498CREATE TABLE federated.t1 ( 499`id` int(20) NOT NULL auto_increment, 500`name` varchar(32) NOT NULL DEFAULT '', 501`other` varchar(20) NOT NULL DEFAULT '', 502PRIMARY KEY (`id`), 503KEY nameoth (name, other) ); 504DROP TABLE IF EXISTS federated.t1; 505CREATE TABLE federated.t1 ( 506`id` int(20) NOT NULL auto_increment, 507`name` varchar(32) NOT NULL DEFAULT '', 508`other` varchar(20) NOT NULL DEFAULT '', 509PRIMARY KEY (`id`), 510KEY nameoth (name, other)) 511ENGINE="FEDERATED" DEFAULT 512CHARSET=latin1 513CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 514INSERT INTO federated.t1 (name, other) VALUES ('First Name', '1111'); 515INSERT INTO federated.t1 (name, other) VALUES ('Second Name', '2222'); 516INSERT INTO federated.t1 (name, other) VALUES ('Third Name', '3333'); 517SELECT * FROM federated.t1 WHERE name = 'Second Name'; 518id name other 5192 Second Name 2222 520SELECT * FROM federated.t1 WHERE other = '2222'; 521id name other 5222 Second Name 2222 523SELECT * FROM federated.t1 WHERE name = 'Third Name'; 524id name other 5253 Third Name 3333 526SELECT * FROM federated.t1 WHERE name = 'Third Name' AND other = '3333'; 527id name other 5283 Third Name 3333 529DROP TABLE IF EXISTS federated.t1; 530CREATE TABLE federated.t1 ( 531`id` int NOT NULL auto_increment, 532`name` char(32) NOT NULL DEFAULT '', 533`bincol` binary(1) NOT NULL, 534`floatval` decimal(5,2) NOT NULL DEFAULT 0.0, 535`other` int NOT NULL DEFAULT 0, 536PRIMARY KEY (id), 537KEY nameoth(name, other), 538KEY bincol(bincol), 539KEY floatval(floatval)); 540DROP TABLE IF EXISTS federated.t1; 541CREATE TABLE federated.t1 ( 542`id` int NOT NULL auto_increment, 543`name` char(32) NOT NULL DEFAULT '', 544`bincol` binary(1) NOT NULL, 545`floatval` decimal(5,2) NOT NULL DEFAULT 0.0, 546`other` int NOT NULL DEFAULT 0, 547PRIMARY KEY (id), 548KEY nameoth(name,other), 549KEY bincol(bincol), 550KEY floatval(floatval)) 551ENGINE="FEDERATED" 552 DEFAULT CHARSET=latin1 553CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 554INSERT INTO federated.t1 (name, bincol, floatval, other) 555VALUES ('first', 0x65, 11.11, 1111); 556INSERT INTO federated.t1 (name, bincol, floatval, other) 557VALUES ('second', 0x66, 22.22, 2222); 558INSERT INTO federated.t1 (name, bincol, floatval, other) 559VALUES ('third', 'g', 22.22, 2222); 560SELECT * FROM federated.t1; 561id name bincol floatval other 5621 first e 11.11 1111 5632 second f 22.22 2222 5643 third g 22.22 2222 565SELECT * FROM federated.t1 WHERE name = 'second'; 566id name bincol floatval other 5672 second f 22.22 2222 568SELECT * FROM federated.t1 WHERE bincol= 'f'; 569id name bincol floatval other 5702 second f 22.22 2222 571SELECT * FROM federated.t1 WHERE bincol= 0x66; 572id name bincol floatval other 5732 second f 22.22 2222 574SELECT * FROM federated.t1 WHERE bincol= 0x67; 575id name bincol floatval other 5763 third g 22.22 2222 577SELECT * FROM federated.t1 WHERE bincol= 'g'; 578id name bincol floatval other 5793 third g 22.22 2222 580SELECT * FROM federated.t1 WHERE floatval=11.11; 581id name bincol floatval other 5821 first e 11.11 1111 583SELECT * FROM federated.t1 WHERE name='third'; 584id name bincol floatval other 5853 third g 22.22 2222 586SELECT * FROM federated.t1 WHERE other=2222; 587id name bincol floatval other 5882 second f 22.22 2222 5893 third g 22.22 2222 590SELECT * FROM federated.t1 WHERE name='third' and other=2222; 591id name bincol floatval other 5923 third g 22.22 2222 593DROP TABLE IF EXISTS federated.t1; 594CREATE TABLE federated.t1 ( 595`id` int NOT NULL auto_increment, 596`col1` int(10) NOT NULL DEFAULT 0, 597`col2` varchar(64) NOT NULL DEFAULT '', 598`col3` int(20) NOT NULL, 599`col4` int(40) NOT NULL, 600primary key (`id`, `col1`, `col2`, `col3`, `col4`), 601key col1(col1), 602key col2(col2), 603key col3(col3), 604key col4(col4)); 605DROP TABLE IF EXISTS federated.t1; 606CREATE TABLE federated.t1 ( 607`id` int NOT NULL auto_increment, 608`col1` int(10) NOT NULL DEFAULT 0, 609`col2` varchar(64) NOT NULL DEFAULT '', 610`col3` int(20) NOT NULL, 611`col4` int(40) NOT NULL, 612primary key (`id`, `col1`, `col2`, `col3`, `col4`), 613key col1(col1), 614key col2(col2), 615key col3(col3), 616key col4(col4)) 617ENGINE="FEDERATED" 618 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 619INSERT INTO federated.t1 (col1, col2, col3, col4) 620VALUES (1, 'one One', 11, 1111); 621INSERT INTO federated.t1 (col1, col2, col3, col4) 622VALUES (2, 'Two two', 22, 2222); 623INSERT INTO federated.t1 (col1, col2, col3, col4) 624VALUES (3, 'three Three', 33, 33333); 625INSERT INTO federated.t1 (col1, col2, col3, col4) 626VALUES (4, 'fourfourfour', 444, 4444444); 627INSERT INTO federated.t1 (col1, col2, col3, col4) 628VALUES (5, 'five 5 five five 5', 5, 55555); 629INSERT INTO federated.t1 (col1, col2, col3, col4) 630VALUES (6, 'six six Sixsix', 6666, 6); 631INSERT INTO federated.t1 (col1, col2, col3, col4) 632VALUES (7, 'seven Sevenseven', 77777, 7777); 633INSERT INTO federated.t1 (col1, col2, col3, col4) 634VALUES (8, 'eight eight eight', 88888, 88); 635INSERT INTO federated.t1 (col1, col2, col3, col4) 636VALUES (9, 'nine Nine', 999999, 999999); 637INSERT INTO federated.t1 (col1, col2, col3, col4) 638VALUES (10, 'Tenth ten TEN', 1010101, 1010); 639SELECT * FROM federated.t1 WHERE col2 = 'two two'; 640id col1 col2 col3 col4 6412 2 Two two 22 2222 642SELECT * FROM federated.t1 WHERE col2 = 'two Two'; 643id col1 col2 col3 col4 6442 2 Two two 22 2222 645SELECT * FROM federated.t1 WHERE id = 3; 646id col1 col2 col3 col4 6473 3 three Three 33 33333 648SELECT * FROM federated.t1 WHERE id = 3 AND col1 = 3; 649id col1 col2 col3 col4 6503 3 three Three 33 33333 651SELECT * FROM federated.t1 WHERE id = 4 AND col1 = 4 AND col2 = 'Two two'; 652id col1 col2 col3 col4 653SELECT * FROM federated.t1 WHERE id = 4 AND col1 = 4 AND col2 = 'fourfourfour'; 654id col1 col2 col3 col4 6554 4 fourfourfour 444 4444444 656SELECT * FROM federated.t1 WHERE id = 5 AND col2 = 'five 5 five five 5' 657AND col3 = 5; 658id col1 col2 col3 col4 6595 5 five 5 five five 5 5 55555 660SELECT * FROM federated.t1 WHERE id = 5 AND col2 = 'five 5 five five 5' 661AND col3 = 5 662AND col4 = 55555; 663id col1 col2 col3 col4 6645 5 five 5 five five 5 5 55555 665SELECT * FROM federated.t1 WHERE id = 5 666AND col2 = 'Two two' AND col3 = 22 667AND col4 = 33; 668id col1 col2 col3 col4 669SELECT * FROM federated.t1 WHERE id = 5 670AND col2 = 'five 5 five five 5' AND col3 = 5 671AND col4 = 55555; 672id col1 col2 col3 col4 6735 5 five 5 five five 5 5 55555 674SELECT * FROM federated.t1 WHERE (id = 5 AND col2 = 'five 5 five five 5') 675OR (col2 = 'three Three' AND col3 = 33); 676id col1 col2 col3 col4 6773 3 three Three 33 33333 6785 5 five 5 five five 5 5 55555 679SELECT * FROM federated.t1 WHERE (id = 5 AND col2 = 'Two two') 680OR (col2 = 444 AND col3 = 4444444); 681id col1 col2 col3 col4 682SELECT * FROM federated.t1 WHERE id = 1 683OR col1 = 10 684OR col2 = 'Two two' 685OR col3 = 33 686OR col4 = 4444444; 687id col1 col2 col3 col4 6881 1 one One 11 1111 68910 10 Tenth ten TEN 1010101 1010 6902 2 Two two 22 2222 6913 3 three Three 33 33333 6924 4 fourfourfour 444 4444444 693SELECT * FROM federated.t1 WHERE id > 5; 694id col1 col2 col3 col4 69510 10 Tenth ten TEN 1010101 1010 6966 6 six six Sixsix 6666 6 6977 7 seven Sevenseven 77777 7777 6988 8 eight eight eight 88888 88 6999 9 nine Nine 999999 999999 700SELECT * FROM federated.t1 WHERE id >= 5; 701id col1 col2 col3 col4 70210 10 Tenth ten TEN 1010101 1010 7035 5 five 5 five five 5 5 55555 7046 6 six six Sixsix 6666 6 7057 7 seven Sevenseven 77777 7777 7068 8 eight eight eight 88888 88 7079 9 nine Nine 999999 999999 708SELECT * FROM federated.t1 WHERE id < 5; 709id col1 col2 col3 col4 7101 1 one One 11 1111 7112 2 Two two 22 2222 7123 3 three Three 33 33333 7134 4 fourfourfour 444 4444444 714SELECT * FROM federated.t1 WHERE id <= 5; 715id col1 col2 col3 col4 7161 1 one One 11 1111 7172 2 Two two 22 2222 7183 3 three Three 33 33333 7194 4 fourfourfour 444 4444444 7205 5 five 5 five five 5 5 55555 721SELECT * FROM federated.t1 WHERE id != 5; 722id col1 col2 col3 col4 7231 1 one One 11 1111 72410 10 Tenth ten TEN 1010101 1010 7252 2 Two two 22 2222 7263 3 three Three 33 33333 7274 4 fourfourfour 444 4444444 7286 6 six six Sixsix 6666 6 7297 7 seven Sevenseven 77777 7777 7308 8 eight eight eight 88888 88 7319 9 nine Nine 999999 999999 732SELECT * FROM federated.t1 WHERE id > 3 AND id < 7; 733id col1 col2 col3 col4 7344 4 fourfourfour 444 4444444 7355 5 five 5 five five 5 5 55555 7366 6 six six Sixsix 6666 6 737SELECT * FROM federated.t1 WHERE id > 3 AND id <= 7; 738id col1 col2 col3 col4 7394 4 fourfourfour 444 4444444 7405 5 five 5 five five 5 5 55555 7416 6 six six Sixsix 6666 6 7427 7 seven Sevenseven 77777 7777 743SELECT * FROM federated.t1 WHERE id >= 3 AND id <= 7; 744id col1 col2 col3 col4 7453 3 three Three 33 33333 7464 4 fourfourfour 444 4444444 7475 5 five 5 five five 5 5 55555 7486 6 six six Sixsix 6666 6 7497 7 seven Sevenseven 77777 7777 750SELECT * FROM federated.t1 WHERE id < 3 AND id <= 7; 751id col1 col2 col3 col4 7521 1 one One 11 1111 7532 2 Two two 22 2222 754SELECT * FROM federated.t1 WHERE id < 3 AND id > 7; 755id col1 col2 col3 col4 756SELECT * FROM federated.t1 WHERE id < 3 OR id > 7; 757id col1 col2 col3 col4 7581 1 one One 11 1111 75910 10 Tenth ten TEN 1010101 1010 7602 2 Two two 22 2222 7618 8 eight eight eight 88888 88 7629 9 nine Nine 999999 999999 763SELECT * FROM federated.t1 WHERE col2 = 'three Three'; 764id col1 col2 col3 col4 7653 3 three Three 33 33333 766SELECT * FROM federated.t1 WHERE col2 > 'one'; 767id col1 col2 col3 col4 7681 1 one One 11 1111 76910 10 Tenth ten TEN 1010101 1010 7702 2 Two two 22 2222 7713 3 three Three 33 33333 7726 6 six six Sixsix 6666 6 7737 7 seven Sevenseven 77777 7777 774SELECT * FROM federated.t1 WHERE col2 LIKE 's%'; 775id col1 col2 col3 col4 7766 6 six six Sixsix 6666 6 7777 7 seven Sevenseven 77777 7777 778SELECT * FROM federated.t1 WHERE col2 LIKE 'si%'; 779id col1 col2 col3 col4 7806 6 six six Sixsix 6666 6 781SELECT * FROM federated.t1 WHERE col2 LIKE 'se%'; 782id col1 col2 col3 col4 7837 7 seven Sevenseven 77777 7777 784SELECT * FROM federated.t1 WHERE col2 NOT LIKE 'e%'; 785id col1 col2 col3 col4 7861 1 one One 11 1111 78710 10 Tenth ten TEN 1010101 1010 7882 2 Two two 22 2222 7893 3 three Three 33 33333 7904 4 fourfourfour 444 4444444 7915 5 five 5 five five 5 5 55555 7926 6 six six Sixsix 6666 6 7937 7 seven Sevenseven 77777 7777 7949 9 nine Nine 999999 999999 795SELECT * FROM federated.t1 WHERE col2 <> 'one One'; 796id col1 col2 col3 col4 79710 10 Tenth ten TEN 1010101 1010 7982 2 Two two 22 2222 7993 3 three Three 33 33333 8004 4 fourfourfour 444 4444444 8015 5 five 5 five five 5 5 55555 8026 6 six six Sixsix 6666 6 8037 7 seven Sevenseven 77777 7777 8048 8 eight eight eight 88888 88 8059 9 nine Nine 999999 999999 806DROP TABLE IF EXISTS federated.t1; 807CREATE TABLE federated.t1 ( 808`col1` varchar(8) NOT NULL DEFAULT '', 809`col2` varchar(128) NOT NULL DEFAULT '', 810`col3` varchar(20) NOT NULL DEFAULT '', 811`col4` varchar(40) NOT NULL DEFAULT '', 812primary key (`col1`, `col2`, `col3`, `col4`), 813key 3key(`col2`,`col3`,`col4`), 814key 2key (`col3`,`col4`), 815key col4(col4)); 816DROP TABLE IF EXISTS federated.t1; 817CREATE TABLE federated.t1 ( 818`col1` varchar(8) NOT NULL DEFAULT '', 819`col2` varchar(128) NOT NULL DEFAULT '', 820`col3` varchar(20) NOT NULL DEFAULT '', 821`col4` varchar(40) NOT NULL DEFAULT '', 822primary key (`col1`, `col2`, `col3`, `col4`), 823key 3key(`col2`,`col3`,`col4`), 824key 2key (`col3`,`col4`), 825key col4(col4)) 826ENGINE="FEDERATED" 827 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 828INSERT INTO federated.t1 (col1, col2, col3, col4) 829VALUES ('aaaa', 'aaaaaaaaaaaaaaaaaaa', 'ababababab', 'acacacacacacacac'); 830INSERT INTO federated.t1 (col1, col2, col3, col4) 831VALUES ('bbbb', 'bbbbbbbbbbbbbbbbbbb', 'bababababa', 'bcbcbcbcbcbcbcbc'); 832INSERT INTO federated.t1 (col1, col2, col3, col4) 833VALUES ('cccc', 'ccccccccccccccccccc', 'cacacacaca', 'cbcbcbcbcbcbcbcb'); 834INSERT INTO federated.t1 (col1, col2, col3, col4) 835VALUES ('dddd', 'ddddddddddddddddddd', 'dadadadada', 'dcdcdcdcdcdcdcdc'); 836INSERT INTO federated.t1 (col1, col2, col3, col4) 837VALUES ('eeee', 'eeeeeeeeeeeeeeeeeee', 'eaeaeaeaea', 'ecececececececec'); 838INSERT INTO federated.t1 (col1, col2, col3, col4) 839VALUES ('ffff', 'fffffffffffffffffff', 'fafafafafa', 'fcfcfcfcfcfcfcfc'); 840INSERT INTO federated.t1 (col1, col2, col3, col4) 841VALUES ('gggg', 'ggggggggggggggggggg', 'gagagagaga', 'gcgcgcgcgcgcgcgc'); 842INSERT INTO federated.t1 (col1, col2, col3, col4) 843VALUES ('hhhh', 'hhhhhhhhhhhhhhhhhhh', 'hahahahaha', 'hchchchchchchchc'); 844SELECT * FROM federated.t1 WHERE col1 = 'cccc'; 845col1 col2 col3 col4 846cccc ccccccccccccccccccc cacacacaca cbcbcbcbcbcbcbcb 847SELECT * FROM federated.t1 WHERE col2 = 'eeeeeeeeeeeeeeeeeee'; 848col1 col2 col3 col4 849eeee eeeeeeeeeeeeeeeeeee eaeaeaeaea ecececececececec 850SELECT * FROM federated.t1 WHERE col3 = 'bababababa'; 851col1 col2 col3 col4 852bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 853SELECT * FROM federated.t1 WHERE col1 = 'gggg' AND col2 = 'ggggggggggggggggggg'; 854col1 col2 col3 col4 855gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 856SELECT * FROM federated.t1 WHERE col1 = 'gggg' AND col3 = 'gagagagaga'; 857col1 col2 col3 col4 858gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 859SELECT * FROM federated.t1 WHERE col1 = 'ffff' AND col4 = 'fcfcfcfcfcfcfcfc'; 860col1 col2 col3 col4 861ffff fffffffffffffffffff fafafafafa fcfcfcfcfcfcfcfc 862SELECT * FROM federated.t1 WHERE col1 > 'bbbb'; 863col1 col2 col3 col4 864cccc ccccccccccccccccccc cacacacaca cbcbcbcbcbcbcbcb 865dddd ddddddddddddddddddd dadadadada dcdcdcdcdcdcdcdc 866eeee eeeeeeeeeeeeeeeeeee eaeaeaeaea ecececececececec 867ffff fffffffffffffffffff fafafafafa fcfcfcfcfcfcfcfc 868gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 869hhhh hhhhhhhhhhhhhhhhhhh hahahahaha hchchchchchchchc 870SELECT * FROM federated.t1 WHERE col1 >= 'bbbb'; 871col1 col2 col3 col4 872bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 873cccc ccccccccccccccccccc cacacacaca cbcbcbcbcbcbcbcb 874dddd ddddddddddddddddddd dadadadada dcdcdcdcdcdcdcdc 875eeee eeeeeeeeeeeeeeeeeee eaeaeaeaea ecececececececec 876ffff fffffffffffffffffff fafafafafa fcfcfcfcfcfcfcfc 877gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 878hhhh hhhhhhhhhhhhhhhhhhh hahahahaha hchchchchchchchc 879SELECT * FROM federated.t1 WHERE col1 < 'bbbb'; 880col1 col2 col3 col4 881aaaa aaaaaaaaaaaaaaaaaaa ababababab acacacacacacacac 882SELECT * FROM federated.t1 WHERE col1 <= 'bbbb'; 883col1 col2 col3 col4 884aaaa aaaaaaaaaaaaaaaaaaa ababababab acacacacacacacac 885bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 886SELECT * FROM federated.t1 WHERE col1 <> 'bbbb'; 887col1 col2 col3 col4 888aaaa aaaaaaaaaaaaaaaaaaa ababababab acacacacacacacac 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 LIKE 'b%'; 896col1 col2 col3 col4 897bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 898SELECT * FROM federated.t1 WHERE col4 LIKE '%b%'; 899col1 col2 col3 col4 900bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 901cccc ccccccccccccccccccc cacacacaca cbcbcbcbcbcbcbcb 902SELECT * FROM federated.t1 WHERE col1 NOT LIKE 'c%'; 903col1 col2 col3 col4 904aaaa aaaaaaaaaaaaaaaaaaa ababababab acacacacacacacac 905bbbb bbbbbbbbbbbbbbbbbbb bababababa bcbcbcbcbcbcbcbc 906dddd ddddddddddddddddddd dadadadada dcdcdcdcdcdcdcdc 907eeee eeeeeeeeeeeeeeeeeee eaeaeaeaea ecececececececec 908ffff fffffffffffffffffff fafafafafa fcfcfcfcfcfcfcfc 909gggg ggggggggggggggggggg gagagagaga gcgcgcgcgcgcgcgc 910hhhh hhhhhhhhhhhhhhhhhhh hahahahaha hchchchchchchchc 911SELECT * FROM federated.t1 WHERE col4 NOT LIKE '%c%'; 912col1 col2 col3 col4 913DROP TABLE IF EXISTS federated.t1; 914CREATE TABLE federated.t1 ( 915`col1` varchar(8) NOT NULL DEFAULT '', 916`col2` int(8) NOT NULL DEFAULT 0, 917`col3` varchar(8) NOT NULL DEFAULT '', 918primary key (`col1`, `col2`, `col3`)); 919DROP TABLE IF EXISTS federated.t1; 920CREATE TABLE federated.t1 ( 921`col1` varchar(8) NOT NULL DEFAULT '', 922`col2` varchar(8) NOT NULL DEFAULT '', 923`col3` varchar(8) NOT NULL DEFAULT '', 924primary key (`col1`, `col2`, `col3`)) 925ENGINE="FEDERATED" 926 DEFAULT CHARSET=latin1 927CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 928INSERT INTO federated.t1 VALUES ('a00', '110', 'cc0'); 929INSERT INTO federated.t1 VALUES ('aaa', '111', 'ccc'); 930INSERT INTO federated.t1 VALUES ('bbb', '222', 'yyy'); 931INSERT INTO federated.t1 VALUES ('ccc', '111', 'zzz'); 932INSERT INTO federated.t1 VALUES ('ccd', '112', 'zzzz'); 933SELECT col3 FROM federated.t1 WHERE ( 934(col1 = 'aaa' AND col2 >= '111') OR col1 > 'aaa') AND 935(col1 < 'ccc' OR ( col1 = 'ccc' AND col2 <= '111')); 936col3 937ccc 938yyy 939zzz 940SELECT col3 FROM federated.t1 WHERE ( 941(col1 = 'aaa' AND col2 >= '111') OR col1 > 'aaa') AND 942(col1 < 'ccc' OR ( col1 = 'ccc' AND col2 <= '111')); 943col3 944ccc 945yyy 946zzz 947DROP TABLE IF EXISTS federated.t1; 948CREATE TABLE federated.t1 ( 949`id` int, 950`name` varchar(32), 951`floatval` float, 952`other` int) 953DEFAULT CHARSET=latin1; 954DROP TABLE IF EXISTS federated.t1; 955CREATE TABLE federated.t1 ( 956`id` int, 957`name` varchar(32), 958`floatval` float, 959`other` int) 960ENGINE="FEDERATED" 961DEFAULT CHARSET=latin1 962CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 963INSERT INTO federated.t1 values (NULL, NULL, NULL, NULL); 964INSERT INTO federated.t1 values (); 965INSERT INTO federated.t1 (id) VALUES (1); 966INSERT INTO federated.t1 (name, floatval, other) 967VALUES ('foo', 33.33333332, NULL); 968INSERT INTO federated.t1 (name, floatval, other) 969VALUES (0, 00.3333, NULL); 970SELECT * FROM federated.t1; 971id name floatval other 9721 NULL NULL NULL 973NULL 0 0.3333 NULL 974NULL NULL NULL NULL 975NULL NULL NULL NULL 976NULL foo 33.3333 NULL 977SELECT count(*) FROM federated.t1 978WHERE id IS NULL 979AND name IS NULL 980AND floatval IS NULL 981AND other IS NULL; 982count(*) 9832 984DROP TABLE IF EXISTS federated.t1; 985CREATE TABLE federated.t1 ( 986`blurb_id` int NOT NULL DEFAULT 0, 987`blurb` text default '', 988PRIMARY KEY (blurb_id)) 989DEFAULT CHARSET=latin1; 990Warnings: 991Warning 1101 BLOB/TEXT column 'blurb' can't have a default value 992DROP TABLE IF EXISTS federated.t1; 993CREATE TABLE federated.t1 ( 994`blurb_id` int NOT NULL DEFAULT 0, 995`blurb` text default '', 996PRIMARY KEY (blurb_id)) 997ENGINE="FEDERATED" 998 DEFAULT CHARSET=latin1 999CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1000Warnings: 1001Warning 1101 BLOB/TEXT column 'blurb' can't have a default value 1002INSERT 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."); 1003INSERT 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."); 1004INSERT 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. "); 1005INSERT 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:"); 1006SELECT * FROM federated.t1; 1007blurb_id blurb 10081 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. 10092 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. 10103 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. 10114 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: 1012DROP TABLE IF EXISTS federated.t1; 1013CREATE TABLE federated.t1 ( 1014`a` int NOT NULL, 1015`b` int NOT NULL, 1016`c` int NOT NULL, 1017PRIMARY KEY (a),key(b)); 1018DROP TABLE IF EXISTS federated.t1; 1019CREATE TABLE federated.t1 ( 1020`a` int NOT NULL, 1021`b` int NOT NULL, 1022`c` int NOT NULL, 1023PRIMARY KEY (a), 1024KEY (b)) 1025ENGINE="FEDERATED" 1026 DEFAULT CHARSET=latin1 1027CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1028INSERT INTO federated.t1 VALUES (3,3,3),(1,1,1),(2,2,2),(4,4,4); 1029DROP TABLE IF EXISTS federated.t1; 1030CREATE TABLE federated.t1 (i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8 1031int, i9 int, i10 int, i11 int, i12 int, i13 int, i14 int, i15 int, i16 int, i17 1032int, i18 int, i19 int, i20 int, i21 int, i22 int, i23 int, i24 int, i25 int, 1033i26 int, i27 int, i28 int, i29 int, i30 int, i31 int, i32 int, i33 int, i34 1034int, i35 int, i36 int, i37 int, i38 int, i39 int, i40 int, i41 int, i42 int, 1035i43 int, i44 int, i45 int, i46 int, i47 int, i48 int, i49 int, i50 int, i51 1036int, i52 int, i53 int, i54 int, i55 int, i56 int, i57 int, i58 int, i59 int, 1037i60 int, i61 int, i62 int, i63 int, i64 int, i65 int, i66 int, i67 int, i68 1038int, i69 int, i70 int, i71 int, i72 int, i73 int, i74 int, i75 int, i76 int, 1039i77 int, i78 int, i79 int, i80 int, i81 int, i82 int, i83 int, i84 int, i85 1040int, i86 int, i87 int, i88 int, i89 int, i90 int, i91 int, i92 int, i93 int, 1041i94 int, i95 int, i96 int, i97 int, i98 int, i99 int, i100 int, i101 int, i102 1042int, i103 int, i104 int, i105 int, i106 int, i107 int, i108 int, i109 int, i110 1043int, i111 int, i112 int, i113 int, i114 int, i115 int, i116 int, i117 int, i118 1044int, i119 int, i120 int, i121 int, i122 int, i123 int, i124 int, i125 int, i126 1045int, i127 int, i128 int, i129 int, i130 int, i131 int, i132 int, i133 int, i134 1046int, i135 int, i136 int, i137 int, i138 int, i139 int, i140 int, i141 int, i142 1047int, i143 int, i144 int, i145 int, i146 int, i147 int, i148 int, i149 int, i150 1048int, i151 int, i152 int, i153 int, i154 int, i155 int, i156 int, i157 int, i158 1049int, i159 int, i160 int, i161 int, i162 int, i163 int, i164 int, i165 int, i166 1050int, i167 int, i168 int, i169 int, i170 int, i171 int, i172 int, i173 int, i174 1051int, i175 int, i176 int, i177 int, i178 int, i179 int, i180 int, i181 int, i182 1052int, i183 int, i184 int, i185 int, i186 int, i187 int, i188 int, i189 int, i190 1053int, i191 int, i192 int, i193 int, i194 int, i195 int, i196 int, i197 int, i198 1054int, i199 int, i200 int, i201 int, i202 int, i203 int, i204 int, i205 int, i206 1055int, i207 int, i208 int, i209 int, i210 int, i211 int, i212 int, i213 int, i214 1056int, i215 int, i216 int, i217 int, i218 int, i219 int, i220 int, i221 int, i222 1057int, i223 int, i224 int, i225 int, i226 int, i227 int, i228 int, i229 int, i230 1058int, i231 int, i232 int, i233 int, i234 int, i235 int, i236 int, i237 int, i238 1059int, i239 int, i240 int, i241 int, i242 int, i243 int, i244 int, i245 int, i246 1060int, i247 int, i248 int, i249 int, i250 int, i251 int, i252 int, i253 int, i254 1061int, i255 int, i256 int, i257 int, i258 int, i259 int, i260 int, i261 int, i262 1062int, i263 int, i264 int, i265 int, i266 int, i267 int, i268 int, i269 int, i270 1063int, i271 int, i272 int, i273 int, i274 int, i275 int, i276 int, i277 int, i278 1064int, i279 int, i280 int, i281 int, i282 int, i283 int, i284 int, i285 int, i286 1065int, i287 int, i288 int, i289 int, i290 int, i291 int, i292 int, i293 int, i294 1066int, i295 int, i296 int, i297 int, i298 int, i299 int, i300 int, i301 int, i302 1067int, i303 int, i304 int, i305 int, i306 int, i307 int, i308 int, i309 int, i310 1068int, i311 int, i312 int, i313 int, i314 int, i315 int, i316 int, i317 int, i318 1069int, i319 int, i320 int, i321 int, i322 int, i323 int, i324 int, i325 int, i326 1070int, i327 int, i328 int, i329 int, i330 int, i331 int, i332 int, i333 int, i334 1071int, i335 int, i336 int, i337 int, i338 int, i339 int, i340 int, i341 int, i342 1072int, i343 int, i344 int, i345 int, i346 int, i347 int, i348 int, i349 int, i350 1073int, i351 int, i352 int, i353 int, i354 int, i355 int, i356 int, i357 int, i358 1074int, i359 int, i360 int, i361 int, i362 int, i363 int, i364 int, i365 int, i366 1075int, i367 int, i368 int, i369 int, i370 int, i371 int, i372 int, i373 int, i374 1076int, i375 int, i376 int, i377 int, i378 int, i379 int, i380 int, i381 int, i382 1077int, i383 int, i384 int, i385 int, i386 int, i387 int, i388 int, i389 int, i390 1078int, i391 int, i392 int, i393 int, i394 int, i395 int, i396 int, i397 int, i398 1079int, i399 int, i400 int, i401 int, i402 int, i403 int, i404 int, i405 int, i406 1080int, i407 int, i408 int, i409 int, i410 int, i411 int, i412 int, i413 int, i414 1081int, i415 int, i416 int, i417 int, i418 int, i419 int, i420 int, i421 int, i422 1082int, i423 int, i424 int, i425 int, i426 int, i427 int, i428 int, i429 int, i430 1083int, i431 int, i432 int, i433 int, i434 int, i435 int, i436 int, i437 int, i438 1084int, i439 int, i440 int, i441 int, i442 int, i443 int, i444 int, i445 int, i446 1085int, i447 int, i448 int, i449 int, i450 int, i451 int, i452 int, i453 int, i454 1086int, i455 int, i456 int, i457 int, i458 int, i459 int, i460 int, i461 int, i462 1087int, i463 int, i464 int, i465 int, i466 int, i467 int, i468 int, i469 int, i470 1088int, i471 int, i472 int, i473 int, i474 int, i475 int, i476 int, i477 int, i478 1089int, i479 int, i480 int, i481 int, i482 int, i483 int, i484 int, i485 int, i486 1090int, i487 int, i488 int, i489 int, i490 int, i491 int, i492 int, i493 int, i494 1091int, i495 int, i496 int, i497 int, i498 int, i499 int, i500 int, i501 int, i502 1092int, i503 int, i504 int, i505 int, i506 int, i507 int, i508 int, i509 int, i510 1093int, i511 int, i512 int, i513 int, i514 int, i515 int, i516 int, i517 int, i518 1094int, i519 int, i520 int, i521 int, i522 int, i523 int, i524 int, i525 int, i526 1095int, i527 int, i528 int, i529 int, i530 int, i531 int, i532 int, i533 int, i534 1096int, i535 int, i536 int, i537 int, i538 int, i539 int, i540 int, i541 int, i542 1097int, i543 int, i544 int, i545 int, i546 int, i547 int, i548 int, i549 int, i550 1098int, i551 int, i552 int, i553 int, i554 int, i555 int, i556 int, i557 int, i558 1099int, i559 int, i560 int, i561 int, i562 int, i563 int, i564 int, i565 int, i566 1100int, i567 int, i568 int, i569 int, i570 int, i571 int, i572 int, i573 int, i574 1101int, i575 int, i576 int, i577 int, i578 int, i579 int, i580 int, i581 int, i582 1102int, i583 int, i584 int, i585 int, i586 int, i587 int, i588 int, i589 int, i590 1103int, i591 int, i592 int, i593 int, i594 int, i595 int, i596 int, i597 int, i598 1104int, i599 int, i600 int, i601 int, i602 int, i603 int, i604 int, i605 int, i606 1105int, i607 int, i608 int, i609 int, i610 int, i611 int, i612 int, i613 int, i614 1106int, i615 int, i616 int, i617 int, i618 int, i619 int, i620 int, i621 int, i622 1107int, i623 int, i624 int, i625 int, i626 int, i627 int, i628 int, i629 int, i630 1108int, i631 int, i632 int, i633 int, i634 int, i635 int, i636 int, i637 int, i638 1109int, i639 int, i640 int, i641 int, i642 int, i643 int, i644 int, i645 int, i646 1110int, i647 int, i648 int, i649 int, i650 int, i651 int, i652 int, i653 int, i654 1111int, i655 int, i656 int, i657 int, i658 int, i659 int, i660 int, i661 int, i662 1112int, i663 int, i664 int, i665 int, i666 int, i667 int, i668 int, i669 int, i670 1113int, i671 int, i672 int, i673 int, i674 int, i675 int, i676 int, i677 int, i678 1114int, i679 int, i680 int, i681 int, i682 int, i683 int, i684 int, i685 int, i686 1115int, i687 int, i688 int, i689 int, i690 int, i691 int, i692 int, i693 int, i694 1116int, i695 int, i696 int, i697 int, i698 int, i699 int, i700 int, i701 int, i702 1117int, i703 int, i704 int, i705 int, i706 int, i707 int, i708 int, i709 int, i710 1118int, i711 int, i712 int, i713 int, i714 int, i715 int, i716 int, i717 int, i718 1119int, i719 int, i720 int, i721 int, i722 int, i723 int, i724 int, i725 int, i726 1120int, i727 int, i728 int, i729 int, i730 int, i731 int, i732 int, i733 int, i734 1121int, i735 int, i736 int, i737 int, i738 int, i739 int, i740 int, i741 int, i742 1122int, i743 int, i744 int, i745 int, i746 int, i747 int, i748 int, i749 int, i750 1123int, i751 int, i752 int, i753 int, i754 int, i755 int, i756 int, i757 int, i758 1124int, i759 int, i760 int, i761 int, i762 int, i763 int, i764 int, i765 int, i766 1125int, i767 int, i768 int, i769 int, i770 int, i771 int, i772 int, i773 int, i774 1126int, i775 int, i776 int, i777 int, i778 int, i779 int, i780 int, i781 int, i782 1127int, i783 int, i784 int, i785 int, i786 int, i787 int, i788 int, i789 int, i790 1128int, i791 int, i792 int, i793 int, i794 int, i795 int, i796 int, i797 int, i798 1129int, i799 int, i800 int, i801 int, i802 int, i803 int, i804 int, i805 int, i806 1130int, i807 int, i808 int, i809 int, i810 int, i811 int, i812 int, i813 int, i814 1131int, i815 int, i816 int, i817 int, i818 int, i819 int, i820 int, i821 int, i822 1132int, i823 int, i824 int, i825 int, i826 int, i827 int, i828 int, i829 int, i830 1133int, i831 int, i832 int, i833 int, i834 int, i835 int, i836 int, i837 int, i838 1134int, i839 int, i840 int, i841 int, i842 int, i843 int, i844 int, i845 int, i846 1135int, i847 int, i848 int, i849 int, i850 int, i851 int, i852 int, i853 int, i854 1136int, i855 int, i856 int, i857 int, i858 int, i859 int, i860 int, i861 int, i862 1137int, i863 int, i864 int, i865 int, i866 int, i867 int, i868 int, i869 int, i870 1138int, i871 int, i872 int, i873 int, i874 int, i875 int, i876 int, i877 int, i878 1139int, i879 int, i880 int, i881 int, i882 int, i883 int, i884 int, i885 int, i886 1140int, i887 int, i888 int, i889 int, i890 int, i891 int, i892 int, i893 int, i894 1141int, i895 int, i896 int, i897 int, i898 int, i899 int, i900 int, i901 int, i902 1142int, i903 int, i904 int, i905 int, i906 int, i907 int, i908 int, i909 int, i910 1143int, i911 int, i912 int, i913 int, i914 int, i915 int, i916 int, i917 int, i918 1144int, i919 int, i920 int, i921 int, i922 int, i923 int, i924 int, i925 int, i926 1145int, i927 int, i928 int, i929 int, i930 int, i931 int, i932 int, i933 int, i934 1146int, i935 int, i936 int, i937 int, i938 int, i939 int, i940 int, i941 int, i942 1147int, i943 int, i944 int, i945 int, i946 int, i947 int, i948 int, i949 int, i950 1148int, i951 int, i952 int, i953 int, i954 int, i955 int, i956 int, i957 int, i958 1149int, i959 int, i960 int, i961 int, i962 int, i963 int, i964 int, i965 int, i966 1150int, i967 int, i968 int, i969 int, i970 int, i971 int, i972 int, i973 int, i974 1151int, i975 int, i976 int, i977 int, i978 int, i979 int, i980 int, i981 int, i982 1152int, i983 int, i984 int, i985 int, i986 int, i987 int, i988 int, i989 int, i990 1153int, i991 int, i992 int, i993 int, i994 int, i995 int, i996 int, i997 int, i998 1154int, i999 int, i1000 int, b varchar(256)) row_format=dynamic; 1155DROP TABLE IF EXISTS federated.t1; 1156CREATE TABLE federated.t1 1157(i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8 1158int, i9 int, i10 int, i11 int, i12 int, i13 int, i14 int, i15 int, i16 int, 1159i17 int, i18 int, i19 int, i20 int, i21 int, i22 int, i23 int, i24 int, i25 int, 1160i26 int, i27 int, i28 int, i29 int, i30 int, i31 int, i32 int, i33 int, i34 1161int, i35 int, i36 int, i37 int, i38 int, i39 int, i40 int, i41 int, i42 int, 1162i43 int, i44 int, i45 int, i46 int, i47 int, i48 int, i49 int, i50 int, i51 1163int, i52 int, i53 int, i54 int, i55 int, i56 int, i57 int, i58 int, i59 int, 1164i60 int, i61 int, i62 int, i63 int, i64 int, i65 int, i66 int, i67 int, i68 1165int, i69 int, i70 int, i71 int, i72 int, i73 int, i74 int, i75 int, i76 int, 1166i77 int, i78 int, i79 int, i80 int, i81 int, i82 int, i83 int, i84 int, i85 1167int, i86 int, i87 int, i88 int, i89 int, i90 int, i91 int, i92 int, i93 int, 1168i94 int, i95 int, i96 int, i97 int, i98 int, i99 int, i100 int, i101 int, i102 1169int, i103 int, i104 int, i105 int, i106 int, i107 int, i108 int, i109 int, i110 1170int, i111 int, i112 int, i113 int, i114 int, i115 int, i116 int, i117 int, i118 1171int, i119 int, i120 int, i121 int, i122 int, i123 int, i124 int, i125 int, i126 1172int, i127 int, i128 int, i129 int, i130 int, i131 int, i132 int, i133 int, i134 1173int, i135 int, i136 int, i137 int, i138 int, i139 int, i140 int, i141 int, i142 1174int, i143 int, i144 int, i145 int, i146 int, i147 int, i148 int, i149 int, i150 1175int, i151 int, i152 int, i153 int, i154 int, i155 int, i156 int, i157 int, i158 1176int, i159 int, i160 int, i161 int, i162 int, i163 int, i164 int, i165 int, i166 1177int, i167 int, i168 int, i169 int, i170 int, i171 int, i172 int, i173 int, i174 1178int, i175 int, i176 int, i177 int, i178 int, i179 int, i180 int, i181 int, i182 1179int, i183 int, i184 int, i185 int, i186 int, i187 int, i188 int, i189 int, i190 1180int, i191 int, i192 int, i193 int, i194 int, i195 int, i196 int, i197 int, i198 1181int, i199 int, i200 int, i201 int, i202 int, i203 int, i204 int, i205 int, i206 1182int, i207 int, i208 int, i209 int, i210 int, i211 int, i212 int, i213 int, i214 1183int, i215 int, i216 int, i217 int, i218 int, i219 int, i220 int, i221 int, i222 1184int, i223 int, i224 int, i225 int, i226 int, i227 int, i228 int, i229 int, i230 1185int, i231 int, i232 int, i233 int, i234 int, i235 int, i236 int, i237 int, i238 1186int, i239 int, i240 int, i241 int, i242 int, i243 int, i244 int, i245 int, i246 1187int, i247 int, i248 int, i249 int, i250 int, i251 int, i252 int, i253 int, i254 1188int, i255 int, i256 int, i257 int, i258 int, i259 int, i260 int, i261 int, i262 1189int, i263 int, i264 int, i265 int, i266 int, i267 int, i268 int, i269 int, i270 1190int, i271 int, i272 int, i273 int, i274 int, i275 int, i276 int, i277 int, i278 1191int, i279 int, i280 int, i281 int, i282 int, i283 int, i284 int, i285 int, i286 1192int, i287 int, i288 int, i289 int, i290 int, i291 int, i292 int, i293 int, i294 1193int, i295 int, i296 int, i297 int, i298 int, i299 int, i300 int, i301 int, i302 1194int, i303 int, i304 int, i305 int, i306 int, i307 int, i308 int, i309 int, i310 1195int, i311 int, i312 int, i313 int, i314 int, i315 int, i316 int, i317 int, i318 1196int, i319 int, i320 int, i321 int, i322 int, i323 int, i324 int, i325 int, i326 1197int, i327 int, i328 int, i329 int, i330 int, i331 int, i332 int, i333 int, i334 1198int, i335 int, i336 int, i337 int, i338 int, i339 int, i340 int, i341 int, i342 1199int, i343 int, i344 int, i345 int, i346 int, i347 int, i348 int, i349 int, i350 1200int, i351 int, i352 int, i353 int, i354 int, i355 int, i356 int, i357 int, i358 1201int, i359 int, i360 int, i361 int, i362 int, i363 int, i364 int, i365 int, i366 1202int, i367 int, i368 int, i369 int, i370 int, i371 int, i372 int, i373 int, i374 1203int, i375 int, i376 int, i377 int, i378 int, i379 int, i380 int, i381 int, i382 1204int, i383 int, i384 int, i385 int, i386 int, i387 int, i388 int, i389 int, i390 1205int, i391 int, i392 int, i393 int, i394 int, i395 int, i396 int, i397 int, i398 1206int, i399 int, i400 int, i401 int, i402 int, i403 int, i404 int, i405 int, i406 1207int, i407 int, i408 int, i409 int, i410 int, i411 int, i412 int, i413 int, i414 1208int, i415 int, i416 int, i417 int, i418 int, i419 int, i420 int, i421 int, i422 1209int, i423 int, i424 int, i425 int, i426 int, i427 int, i428 int, i429 int, i430 1210int, i431 int, i432 int, i433 int, i434 int, i435 int, i436 int, i437 int, i438 1211int, i439 int, i440 int, i441 int, i442 int, i443 int, i444 int, i445 int, i446 1212int, i447 int, i448 int, i449 int, i450 int, i451 int, i452 int, i453 int, i454 1213int, i455 int, i456 int, i457 int, i458 int, i459 int, i460 int, i461 int, i462 1214int, i463 int, i464 int, i465 int, i466 int, i467 int, i468 int, i469 int, i470 1215int, i471 int, i472 int, i473 int, i474 int, i475 int, i476 int, i477 int, i478 1216int, i479 int, i480 int, i481 int, i482 int, i483 int, i484 int, i485 int, i486 1217int, i487 int, i488 int, i489 int, i490 int, i491 int, i492 int, i493 int, i494 1218int, i495 int, i496 int, i497 int, i498 int, i499 int, i500 int, i501 int, i502 1219int, i503 int, i504 int, i505 int, i506 int, i507 int, i508 int, i509 int, i510 1220int, i511 int, i512 int, i513 int, i514 int, i515 int, i516 int, i517 int, i518 1221int, i519 int, i520 int, i521 int, i522 int, i523 int, i524 int, i525 int, i526 1222int, i527 int, i528 int, i529 int, i530 int, i531 int, i532 int, i533 int, i534 1223int, i535 int, i536 int, i537 int, i538 int, i539 int, i540 int, i541 int, i542 1224int, i543 int, i544 int, i545 int, i546 int, i547 int, i548 int, i549 int, i550 1225int, i551 int, i552 int, i553 int, i554 int, i555 int, i556 int, i557 int, i558 1226int, i559 int, i560 int, i561 int, i562 int, i563 int, i564 int, i565 int, i566 1227int, i567 int, i568 int, i569 int, i570 int, i571 int, i572 int, i573 int, i574 1228int, i575 int, i576 int, i577 int, i578 int, i579 int, i580 int, i581 int, i582 1229int, i583 int, i584 int, i585 int, i586 int, i587 int, i588 int, i589 int, i590 1230int, i591 int, i592 int, i593 int, i594 int, i595 int, i596 int, i597 int, i598 1231int, i599 int, i600 int, i601 int, i602 int, i603 int, i604 int, i605 int, i606 1232int, i607 int, i608 int, i609 int, i610 int, i611 int, i612 int, i613 int, i614 1233int, i615 int, i616 int, i617 int, i618 int, i619 int, i620 int, i621 int, i622 1234int, i623 int, i624 int, i625 int, i626 int, i627 int, i628 int, i629 int, i630 1235int, i631 int, i632 int, i633 int, i634 int, i635 int, i636 int, i637 int, i638 1236int, i639 int, i640 int, i641 int, i642 int, i643 int, i644 int, i645 int, i646 1237int, i647 int, i648 int, i649 int, i650 int, i651 int, i652 int, i653 int, i654 1238int, i655 int, i656 int, i657 int, i658 int, i659 int, i660 int, i661 int, i662 1239int, i663 int, i664 int, i665 int, i666 int, i667 int, i668 int, i669 int, i670 1240int, i671 int, i672 int, i673 int, i674 int, i675 int, i676 int, i677 int, i678 1241int, i679 int, i680 int, i681 int, i682 int, i683 int, i684 int, i685 int, i686 1242int, i687 int, i688 int, i689 int, i690 int, i691 int, i692 int, i693 int, i694 1243int, i695 int, i696 int, i697 int, i698 int, i699 int, i700 int, i701 int, i702 1244int, i703 int, i704 int, i705 int, i706 int, i707 int, i708 int, i709 int, i710 1245int, i711 int, i712 int, i713 int, i714 int, i715 int, i716 int, i717 int, i718 1246int, i719 int, i720 int, i721 int, i722 int, i723 int, i724 int, i725 int, i726 1247int, i727 int, i728 int, i729 int, i730 int, i731 int, i732 int, i733 int, i734 1248int, i735 int, i736 int, i737 int, i738 int, i739 int, i740 int, i741 int, i742 1249int, i743 int, i744 int, i745 int, i746 int, i747 int, i748 int, i749 int, i750 1250int, i751 int, i752 int, i753 int, i754 int, i755 int, i756 int, i757 int, i758 1251int, i759 int, i760 int, i761 int, i762 int, i763 int, i764 int, i765 int, i766 1252int, i767 int, i768 int, i769 int, i770 int, i771 int, i772 int, i773 int, i774 1253int, i775 int, i776 int, i777 int, i778 int, i779 int, i780 int, i781 int, i782 1254int, i783 int, i784 int, i785 int, i786 int, i787 int, i788 int, i789 int, i790 1255int, i791 int, i792 int, i793 int, i794 int, i795 int, i796 int, i797 int, i798 1256int, i799 int, i800 int, i801 int, i802 int, i803 int, i804 int, i805 int, i806 1257int, i807 int, i808 int, i809 int, i810 int, i811 int, i812 int, i813 int, i814 1258int, i815 int, i816 int, i817 int, i818 int, i819 int, i820 int, i821 int, i822 1259int, i823 int, i824 int, i825 int, i826 int, i827 int, i828 int, i829 int, i830 1260int, i831 int, i832 int, i833 int, i834 int, i835 int, i836 int, i837 int, i838 1261int, i839 int, i840 int, i841 int, i842 int, i843 int, i844 int, i845 int, i846 1262int, i847 int, i848 int, i849 int, i850 int, i851 int, i852 int, i853 int, i854 1263int, i855 int, i856 int, i857 int, i858 int, i859 int, i860 int, i861 int, i862 1264int, i863 int, i864 int, i865 int, i866 int, i867 int, i868 int, i869 int, i870 1265int, i871 int, i872 int, i873 int, i874 int, i875 int, i876 int, i877 int, i878 1266int, i879 int, i880 int, i881 int, i882 int, i883 int, i884 int, i885 int, i886 1267int, i887 int, i888 int, i889 int, i890 int, i891 int, i892 int, i893 int, i894 1268int, i895 int, i896 int, i897 int, i898 int, i899 int, i900 int, i901 int, i902 1269int, i903 int, i904 int, i905 int, i906 int, i907 int, i908 int, i909 int, i910 1270int, i911 int, i912 int, i913 int, i914 int, i915 int, i916 int, i917 int, i918 1271int, i919 int, i920 int, i921 int, i922 int, i923 int, i924 int, i925 int, i926 1272int, i927 int, i928 int, i929 int, i930 int, i931 int, i932 int, i933 int, i934 1273int, i935 int, i936 int, i937 int, i938 int, i939 int, i940 int, i941 int, i942 1274int, i943 int, i944 int, i945 int, i946 int, i947 int, i948 int, i949 int, i950 1275int, i951 int, i952 int, i953 int, i954 int, i955 int, i956 int, i957 int, i958 1276int, i959 int, i960 int, i961 int, i962 int, i963 int, i964 int, i965 int, i966 1277int, i967 int, i968 int, i969 int, i970 int, i971 int, i972 int, i973 int, i974 1278int, i975 int, i976 int, i977 int, i978 int, i979 int, i980 int, i981 int, i982 1279int, i983 int, i984 int, i985 int, i986 int, i987 int, i988 int, i989 int, i990 1280int, i991 int, i992 int, i993 int, i994 int, i995 int, i996 int, i997 int, i998 1281int, i999 int, i1000 int, b varchar(256)) 1282row_format=dynamic 1283ENGINE="FEDERATED" 1284DEFAULT CHARSET=latin1 1285CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1286INSERT INTO federated.t1 1287values (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12881, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12891, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12901, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12911, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12921, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12931, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12941, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12951, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12961, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12971, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12981, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 12991, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13001, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13011, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13021, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13031, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13041, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13051, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13061, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13071, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13081, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13091, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13101, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13111, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13121, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13131, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13141, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13151, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13161, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13171, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13181, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13191, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13201, 1, 1, 1, 1, 1, 1, 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, "PatrickG"); 1326UPDATE federated.t1 SET b=repeat('a',256); 1327UPDATE federated.t1 SET i1=0, i2=0, i3=0, i4=0, i5=0, i6=0, i7=0, i8=0, i9=0, i10=0; 1328SELECT * FROM federated.t1 WHERE i9=0 and i10=0; 1329i1 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 13300 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 1331UPDATE federated.t1 SET i50=20; 1332SELECT * FROM federated.t1; 1333i1 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 13340 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 1335DELETE FROM federated.t1 WHERE i51=20; 1336SELECT * FROM federated.t1; 1337i1 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 13380 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 1339DELETE FROM federated.t1 WHERE i50=20; 1340SELECT * FROM federated.t1; 1341i1 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 1342DROP TABLE IF EXISTS federated.t1; 1343CREATE 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; 1344DROP TABLE IF EXISTS federated.t1; 1345CREATE TABLE federated.t1 ( 1346id int NOT NULL auto_increment, 1347code char(20) NOT NULL, 1348fileguts blob NOT NULL, 1349creation_date datetime, 1350entered_time datetime default '2004-04-04 04:04:04', 1351PRIMARY KEY(id), 1352index(code), 1353index(fileguts(10))) 1354ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1355CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1356INSERT 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'); 1357INSERT 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'); 1358INSERT INTO federated.t1 (code, fileguts, creation_date) VALUES ('DEUEUEUEUEUEUEUEUEU', 'jimbob', '2004-04-04 04:04:04'); 1359SELECT * FROM federated.t1; 1360id code fileguts creation_date entered_time 13611 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 13622 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 13633 DEUEUEUEUEUEUEUEUEU jimbob 2004-04-04 04:04:04 2004-04-04 04:04:04 1364SELECT * FROM federated.t1 WHERE fileguts = 'jimbob'; 1365id code fileguts creation_date entered_time 13663 DEUEUEUEUEUEUEUEUEU jimbob 2004-04-04 04:04:04 2004-04-04 04:04:04 1367DROP TABLE IF EXISTS federated.t1; 1368CREATE TABLE federated.t1 (`a` BLOB); 1369DROP TABLE IF EXISTS federated.t1; 1370CREATE TABLE federated.t1 ( 1371`a` BLOB) 1372ENGINE="FEDERATED" 1373CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1374INSERT INTO federated.t1 VALUES (0x00); 1375INSERT INTO federated.t1 VALUES (0x0001); 1376INSERT INTO federated.t1 VALUES (0x0100); 1377SELECT HEX(a) FROM federated.t1; 1378HEX(a) 137900 13800001 13810100 1382DROP TABLE IF EXISTS federated.t1; 1383CREATE TABLE federated.t1 ( 1384`id` int(20) NOT NULL auto_increment, 1385`country_id` int(20) NOT NULL DEFAULT 0, 1386`name` varchar(32), 1387`other` varchar(20), 1388PRIMARY KEY (`id`), 1389key (country_id)); 1390DROP TABLE IF EXISTS federated.countries; 1391Warnings: 1392Note 1051 Unknown table 'federated.countries' 1393CREATE TABLE federated.countries ( 1394`id` int(20) NOT NULL auto_increment, 1395`country` varchar(32), 1396PRIMARY KEY (id)); 1397INSERT INTO federated.countries (country) VALUES ('India'); 1398INSERT INTO federated.countries (country) VALUES ('Germany'); 1399INSERT INTO federated.countries (country) VALUES ('Italy'); 1400INSERT INTO federated.countries (country) VALUES ('Finland'); 1401INSERT INTO federated.countries (country) VALUES ('Ukraine'); 1402DROP TABLE IF EXISTS federated.t1; 1403CREATE TABLE federated.t1 ( 1404`id` int(20) NOT NULL auto_increment, 1405`country_id` int(20) NOT NULL DEFAULT 0, 1406`name` varchar(32), 1407`other` varchar(20), 1408PRIMARY KEY (`id`), 1409KEY (country_id) ) 1410ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1411CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1412INSERT INTO federated.t1 (name, country_id, other) VALUES ('Kumar', 1, 11111); 1413INSERT INTO federated.t1 (name, country_id, other) VALUES ('Lenz', 2, 22222); 1414INSERT INTO federated.t1 (name, country_id, other) VALUES ('Marizio', 3, 33333); 1415INSERT INTO federated.t1 (name, country_id, other) VALUES ('Monty', 4, 33333); 1416INSERT INTO federated.t1 (name, country_id, other) VALUES ('Sanja', 5, 33333); 1417SELECT federated.t1.name AS name, federated.t1.country_id AS country_id, 1418federated.t1.other AS other, federated.countries.country AS country 1419FROM federated.t1, federated.countries WHERE 1420federated.t1.country_id = federated.countries.id; 1421name country_id other country 1422Kumar 1 11111 India 1423Lenz 2 22222 Germany 1424Marizio 3 33333 Italy 1425Monty 4 33333 Finland 1426Sanja 5 33333 Ukraine 1427SELECT federated.t1.name AS name, federated.t1.country_id AS country_id, 1428federated.t1.other AS other, federated.countries.country AS country 1429FROM federated.t1 INNER JOIN federated.countries ON 1430federated.t1.country_id = federated.countries.id; 1431name country_id other country 1432Kumar 1 11111 India 1433Lenz 2 22222 Germany 1434Marizio 3 33333 Italy 1435Monty 4 33333 Finland 1436Sanja 5 33333 Ukraine 1437SELECT federated.t1.name AS name, federated.t1.country_id AS country_id, 1438federated.t1.other AS other, federated.countries.country AS country 1439FROM federated.t1 INNER JOIN federated.countries ON 1440federated.t1.country_id = federated.countries.id 1441WHERE federated.t1.name = 'Monty'; 1442name country_id other country 1443Monty 4 33333 Finland 1444SELECT federated.t1.*, federated.countries.country 1445FROM federated.t1 LEFT JOIN federated.countries 1446ON federated.t1.country_id = federated.countries.id 1447ORDER BY federated.countries.id; 1448id country_id name other country 14491 1 Kumar 11111 India 14502 2 Lenz 22222 Germany 14513 3 Marizio 33333 Italy 14524 4 Monty 33333 Finland 14535 5 Sanja 33333 Ukraine 1454SELECT federated.t1.*, federated.countries.country 1455FROM federated.t1 LEFT JOIN federated.countries 1456ON federated.t1.country_id = federated.countries.id 1457ORDER BY federated.countries.country; 1458id country_id name other country 14594 4 Monty 33333 Finland 14602 2 Lenz 22222 Germany 14611 1 Kumar 11111 India 14623 3 Marizio 33333 Italy 14635 5 Sanja 33333 Ukraine 1464SELECT federated.t1.*, federated.countries.country 1465FROM federated.t1 RIGHT JOIN federated.countries 1466ON federated.t1.country_id = federated.countries.id 1467ORDER BY federated.t1.country_id; 1468id country_id name other country 14691 1 Kumar 11111 India 14702 2 Lenz 22222 Germany 14713 3 Marizio 33333 Italy 14724 4 Monty 33333 Finland 14735 5 Sanja 33333 Ukraine 1474DROP TABLE federated.countries; 1475OPTIMIZE TABLE federated.t1; 1476Table Op Msg_type Msg_text 1477federated.t1 optimize status OK 1478REPAIR TABLE federated.t1; 1479Table Op Msg_type Msg_text 1480federated.t1 repair status OK 1481REPAIR TABLE federated.t1 QUICK; 1482Table Op Msg_type Msg_text 1483federated.t1 repair status OK 1484REPAIR TABLE federated.t1 EXTENDED; 1485Table Op Msg_type Msg_text 1486federated.t1 repair status OK 1487REPAIR TABLE federated.t1 USE_FRM; 1488Table Op Msg_type Msg_text 1489federated.t1 repair status OK 1490DROP TABLE IF EXISTS federated.normal_table; 1491CREATE TABLE federated.normal_table ( 1492`id` int(4) NOT NULL, 1493`name` varchar(10) default NULL 1494) DEFAULT CHARSET=latin1; 1495DROP TABLE IF EXISTS federated.alter_me; 1496CREATE TABLE federated.alter_me ( 1497`id` int(4) NOT NULL, 1498`name` varchar(10) default NULL, 1499PRIMARY KEY (`id`) 1500) ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1501CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/normal_table'; 1502INSERT INTO federated.alter_me (id, name) VALUES (1, 'Monty'); 1503INSERT INTO federated.alter_me (id, name) VALUES (2, 'David'); 1504SELECT * FROM federated.alter_me; 1505id name 15061 Monty 15072 David 1508ALTER TABLE federated.alter_me MODIFY COLUMN id int(16) NOT NULL; 1509ERROR HY000: Table storage engine for 'alter_me' doesn't have this option 1510SELECT * FROM federated.alter_me; 1511id name 15121 Monty 15132 David 1514DROP TABLE federated.alter_me; 1515DROP TABLE federated.normal_table; 1516DROP TABLE IF EXISTS federated.t1; 1517CREATE TABLE federated.t1 ( 1518`bitty` bit(3) 1519) DEFAULT CHARSET=latin1; 1520DROP TABLE IF EXISTS federated.t1; 1521CREATE TABLE federated.t1 ( 1522`bitty` bit(3) 1523) ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1524CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1525INSERT INTO federated.t1 VALUES (b'001'); 1526INSERT INTO federated.t1 VALUES (b'010'); 1527INSERT INTO federated.t1 VALUES (b'011'); 1528INSERT INTO federated.t1 VALUES (b'100'); 1529INSERT INTO federated.t1 VALUES (b'101'); 1530INSERT INTO federated.t1 VALUES (b'110'); 1531INSERT INTO federated.t1 VALUES (b'111'); 1532select * FROM federated.t1; 1533bitty 1534 1535 1536 1537 1538 1539 1540 1541drop table federated.t1; 1542drop table federated.t1; 1543DROP TABLE IF EXISTS federated.t1; 1544Warnings: 1545Note 1051 Unknown table 'federated.t1' 1546CREATE TABLE federated.t1 ( 1547`id` int(20) NOT NULL auto_increment, 1548PRIMARY KEY (`id`)); 1549DROP TABLE IF EXISTS federated.t1; 1550Warnings: 1551Note 1051 Unknown table 'federated.t1' 1552CREATE TABLE federated.t1 ( 1553`id` int(20) NOT NULL auto_increment, 1554PRIMARY KEY (`id`) 1555) 1556ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1557CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1558INSERT INTO federated.t1 VALUES (); 1559SELECT LAST_INSERT_ID(); 1560LAST_INSERT_ID() 15611 1562INSERT INTO federated.t1 VALUES (); 1563SELECT LAST_INSERT_ID(); 1564LAST_INSERT_ID() 15652 1566INSERT INTO federated.t1 VALUES (); 1567SELECT LAST_INSERT_ID(); 1568LAST_INSERT_ID() 15693 1570INSERT INTO federated.t1 VALUES (); 1571SELECT LAST_INSERT_ID(); 1572LAST_INSERT_ID() 15734 1574INSERT INTO federated.t1 VALUES (); 1575SELECT LAST_INSERT_ID(); 1576LAST_INSERT_ID() 15775 1578SELECT * FROM federated.t1; 1579id 15801 15812 15823 15834 15845 1585DROP TABLE federated.t1; 1586DROP TABLE federated.t1; 1587DROP TABLE IF EXISTS federated.bug_17377_table; 1588CREATE TABLE federated.bug_17377_table ( 1589`fld_cid` bigint(20) NOT NULL auto_increment, 1590`fld_name` varchar(255) NOT NULL default '', 1591`fld_parentid` bigint(20) NOT NULL default '0', 1592`fld_delt` int(1) NOT NULL default '0', 1593PRIMARY KEY (`fld_cid`), 1594KEY `fld_parentid` (`fld_parentid`), 1595KEY `fld_delt` (`fld_delt`), 1596KEY `fld_cid` (`fld_cid`) 1597) ENGINE=MyISAM; 1598insert into federated.bug_17377_table( fld_name ) 1599values 1600("Mats"), ("Sivert"), ("Sigvard"), ("Torgny"), ("Torkel"); 1601DROP TABLE IF EXISTS federated.t1; 1602CREATE TABLE federated.t1 ( 1603`fld_cid` bigint(20) NOT NULL auto_increment, 1604`fld_name` varchar(255) NOT NULL default '', 1605`fld_parentid` bigint(20) NOT NULL default '0', 1606`fld_delt` int(1) NOT NULL default '0', 1607PRIMARY KEY (`fld_cid`), 1608KEY `fld_parentid` (`fld_parentid`), 1609KEY `fld_delt` (`fld_delt`), 1610KEY `fld_cid` (`fld_cid`) 1611) ENGINE=FEDERATED 1612CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/bug_17377_table'; 1613select * from federated.t1 where fld_parentid=0 and fld_delt=0 1614order by fld_name; 1615fld_cid fld_name fld_parentid fld_delt 16161 Mats 0 0 16173 Sigvard 0 0 16182 Sivert 0 0 16194 Torgny 0 0 16205 Torkel 0 0 1621select * from federated.t1 where fld_parentid=0 and fld_delt=0; 1622fld_cid fld_name fld_parentid fld_delt 16231 Mats 0 0 16242 Sivert 0 0 16253 Sigvard 0 0 16264 Torgny 0 0 16275 Torkel 0 0 1628DROP TABLE federated.t1; 1629DROP TABLE federated.bug_17377_table; 1630DROP TABLE IF EXISTS federated.test; 1631CREATE TABLE federated.test ( 1632`id` int(11) NOT NULL, 1633`val1` varchar(255) NOT NULL, 1634`val2` varchar(255) NOT NULL, 1635PRIMARY KEY (`id`) 1636) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1637DROP TABLE IF EXISTS federated.test_local; 1638DROP TABLE IF EXISTS federated.test_remote; 1639CREATE TABLE federated.test_local ( 1640`id` int(11) NOT NULL, 1641`val1` varchar(255) NOT NULL, 1642`val2` varchar(255) NOT NULL, 1643PRIMARY KEY (`id`) 1644) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1645INSERT INTO federated.test_local VALUES (1, 'foo', 'bar'), 1646(2, 'bar', 'foo'); 1647CREATE TABLE federated.test_remote ( 1648`id` int(11) NOT NULL, 1649`val1` varchar(255) NOT NULL, 1650`val2` varchar(255) NOT NULL, 1651PRIMARY KEY (`id`) 1652) ENGINE=FEDERATED DEFAULT CHARSET=latin1 1653CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/test'; 1654insert into federated.test_remote select * from federated.test_local; 1655select * from federated.test_remote; 1656id val1 val2 16571 foo bar 16582 bar foo 1659delete from federated.test_remote where id in (1,2); 1660insert into federated.test_remote select * from federated.test_local; 1661select * from federated.test_remote; 1662id val1 val2 16632 bar foo 16641 foo bar 1665DROP TABLE federated.test_local; 1666DROP TABLE federated.test_remote; 1667DROP TABLE federated.test; 1668drop table if exists federated.t1; 1669create table federated.t1 (a int, b int, c int); 1670drop table if exists federated.t1; 1671drop table if exists federated.t2; 1672create table federated.t1 (a int, b int, c int) engine=federated connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1673create trigger federated.t1_bi before insert on federated.t1 for each row set new.c= new.a * new.b; 1674create table federated.t2 (a int, b int); 1675insert into federated.t2 values (13, 17), (19, 23); 1676insert into federated.t1 (a, b) values (1, 2), (3, 5), (7, 11); 1677select * from federated.t1 order by a; 1678a b c 16791 2 2 16803 5 15 16817 11 77 1682delete from federated.t1; 1683insert into federated.t1 (a, b) select * from federated.t2; 1684select * from federated.t1 order by a; 1685a b c 168613 17 221 168719 23 437 1688delete from federated.t1; 1689load data infile '../../std_data/loaddata5.dat' into table federated.t1 fields terminated by '' enclosed by '' ignore 1 lines (a, b); 1690select * from federated.t1 order by a; 1691a b c 16923 4 12 16935 6 30 1694drop tables federated.t1, federated.t2; 1695drop table federated.t1; 1696create table federated.t1 (i1 int, i2 int, i3 int); 1697create table federated.t2 (id int, c1 varchar(20), c2 varchar(20)); 1698create table federated.t1 (i1 int, i2 int, i3 int) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1699create table federated.t2 (id int, c1 varchar(20), c2 varchar(20)) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t2'; 1700insert into federated.t1 values (1,5,10),(3,7,12),(4,5,2),(9,10,15),(2,2,2); 1701insert into federated.t2 values (9,"abc","def"),(5,"opq","lmn"),(2,"test t","t test"); 1702select * from federated.t1 order by i1; 1703i1 i2 i3 17041 5 10 17052 2 2 17063 7 12 17074 5 2 17089 10 15 1709select * from federated.t2; 1710id c1 c2 17119 abc def 17125 opq lmn 17132 test t t test 1714update federated.t1,federated.t2 set t1.i2=15, t2.c2="ppc" where t1.i1=t2.id; 1715select * from federated.t1 order by i1; 1716i1 i2 i3 17171 5 10 17182 15 2 17193 7 12 17204 5 2 17219 15 15 1722select * from federated.t2 order by id; 1723id c1 c2 17242 test t ppc 17255 opq lmn 17269 abc ppc 1727delete federated.t1.*,federated.t2.* from federated.t1,federated.t2 where t1.i2=t2.id; 1728select * from federated.t1 order by i1; 1729i1 i2 i3 17302 15 2 17313 7 12 17329 15 15 1733select * from federated.t2 order by id; 1734id c1 c2 17352 test t ppc 17369 abc ppc 1737drop table federated.t1, federated.t2; 1738drop table federated.t1, federated.t2; 1739create table federated.t1 (i1 int, i2 int, i3 int, primary key (i1)); 1740create table federated.t2 (id int, c1 varchar(20), c2 varchar(20), primary key (id)); 1741create 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'; 1742create 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'; 1743insert into federated.t1 values (1,5,10),(3,7,12),(4,5,2),(9,10,15),(2,2,2); 1744insert into federated.t2 values (9,"abc","def"),(5,"opq","lmn"),(2,"test t","t test"); 1745select * from federated.t1 order by i1; 1746i1 i2 i3 17471 5 10 17482 2 2 17493 7 12 17504 5 2 17519 10 15 1752select * from federated.t2 order by id; 1753id c1 c2 17542 test t t test 17555 opq lmn 17569 abc def 1757update federated.t1,federated.t2 set t1.i2=15, t2.c2="ppc" where t1.i1=t2.id; 1758select * from federated.t1 order by i1; 1759i1 i2 i3 17601 5 10 17612 15 2 17623 7 12 17634 5 2 17649 15 15 1765select * from federated.t2 order by id; 1766id c1 c2 17672 test t ppc 17685 opq lmn 17699 abc ppc 1770delete federated.t1.*,federated.t2.* from federated.t1,federated.t2 where t1.i2=t2.id; 1771select * from federated.t1 order by i1; 1772i1 i2 i3 17732 15 2 17743 7 12 17759 15 15 1776select * from federated.t2 order by id; 1777id c1 c2 17782 test t ppc 17799 abc ppc 1780drop table federated.t1, federated.t2; 1781drop table federated.t1, federated.t2; 1782create table t1 (id int not null auto_increment primary key, val int); 1783create table t1 1784(id int not null auto_increment primary key, val int) engine=federated 1785connection='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 1786insert into t1 values (1,0),(2,0); 1787update t1 set val = NULL where id = 1; 1788select * from t1; 1789id val 17901 NULL 17912 0 1792select * from t1; 1793id val 17941 NULL 17952 0 1796drop table t1; 1797drop table t1; 1798create table t1 (a longblob not null); 1799create table t1 1800(a longblob not null) engine=federated 1801connection='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 1802insert into t1 values (repeat('a',5000)); 1803select length(a) from t1; 1804length(a) 18055000 1806select length(a) from t1; 1807length(a) 18085000 1809drop table t1; 1810drop table t1; 1811DROP TABLE IF EXISTS federated.test; 1812CREATE TABLE federated.test ( 1813`i` int(11) NOT NULL, 1814`j` int(11) NOT NULL, 1815`c` varchar(30) default NULL, 1816PRIMARY KEY (`i`,`j`), 1817UNIQUE KEY `i` (`i`,`c`) 1818) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1819DROP TABLE IF EXISTS federated.test1; 1820DROP TABLE IF EXISTS federated.test2; 1821create table federated.test1 ( 1822i int not null, 1823j int not null, 1824c varchar(30), 1825primary key (i,j), 1826unique key (i, c)) 1827engine = federated 1828connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/test'; 1829create table federated.test2 ( 1830i int default null, 1831j int not null, 1832c varchar(30), 1833key (i)) 1834engine = federated 1835connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/test'; 1836drop table federated.test1, federated.test2; 1837drop table federated.test; 1838set names utf8; 1839create table federated.t1 (a varchar(64)) DEFAULT CHARSET=utf8; 1840insert into federated.t1 values (0x6DC3A56E6164); 1841select hex(a) from federated.t1; 1842hex(a) 18436DC3A56E6164 1844create table federated.t1 (a varchar(64)) 1845ENGINE=FEDERATED 1846connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1847DEFAULT CHARSET=utf8; 1848set names utf8; 1849select hex(a) from federated.t1; 1850hex(a) 18516DC3A56E6164 1852insert into federated.t1 values (0xC3A4C3B6C3BCC39F); 1853insert into federated.t1 values (0xD18DD184D184D0B5D0BAD182D0B8D0B2D0BDD183D18E); 1854select hex(a) from federated.t1; 1855hex(a) 18566DC3A56E6164 1857C3A4C3B6C3BCC39F 1858D18DD184D184D0B5D0BAD182D0B8D0B2D0BDD183D18E 1859select hex(a) from federated.t1; 1860hex(a) 18616DC3A56E6164 1862C3A4C3B6C3BCC39F 1863D18DD184D184D0B5D0BAD182D0B8D0B2D0BDD183D18E 1864drop table federated.t1; 1865drop table federated.t1; 1866CREATE TABLE federated.t1 ( 1867categoryId int(11) NOT NULL AUTO_INCREMENT, 1868domainId varchar(745) NOT NULL DEFAULT '', 1869categoryName varchar(255) NOT NULL DEFAULT '', 1870PRIMARY KEY (categoryId), 1871UNIQUE KEY idx_unique_category_categoryName (domainId, categoryName), 1872KEY idx_category_domainId (domainId) 1873) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1874CREATE TABLE federated.t1 ( 1875categoryId int(11) NOT NULL AUTO_INCREMENT, 1876domainId varchar(745) NOT NULL DEFAULT '', 1877categoryName varchar(255) NOT NULL DEFAULT '', 1878PRIMARY KEY (categoryId), 1879UNIQUE KEY idx_unique_category_categoryName (domainId, categoryName), 1880KEY idx_category_domainId (domainId) 1881) ENGINE=FEDERATED DEFAULT CHARSET=latin1 1882CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1883insert into federated.t1 (domainId, categoryName) values ( '1231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231 300', '1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345 250'); 1884insert into federated.t1 (domainId, categoryName) values ( '12312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312 301', '12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456 250'); 1885insert into federated.t1 (domainId, categoryName) values ('a', 'b'); 1886select categoryId from federated.t1 order by domainId, categoryName; 1887categoryId 18881 18892 18903 1891select categoryId from federated.t1 where domainId='a' and categoryName='b' order by categoryId; 1892categoryId 18933 1894select categoryId from federated.t1 where domainId='a' and categoryName='b' order by categoryId; 1895categoryId 18963 1897select categoryId from federated.t1 where domainId<>'a' and categoryName<>'b' order by categoryId; 1898categoryId 18991 19002 1901drop table federated.t1; 1902drop table federated.t1; 1903create table federated.t1 (a int primary key, b varchar(64)) 1904DEFAULT CHARSET=utf8; 1905create table federated.t1 (a int primary key, b varchar(64)) 1906ENGINE=FEDERATED 1907connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1908 DEFAULT CHARSET=utf8; 1909insert ignore into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe"); 1910select * from federated.t1; 1911a b 19121 Larry 19132 Curly 1914truncate federated.t1; 1915replace into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe"); 1916select * from federated.t1; 1917a b 19181 Moe 19192 Curly 1920update ignore federated.t1 set a=a+1; 1921select * from federated.t1; 1922a b 19231 Moe 19243 Curly 1925drop table federated.t1; 1926drop table federated.t1; 1927create table federated.t1 (a int primary key, b varchar(64)) 1928DEFAULT CHARSET=utf8; 1929create table federated.t1 (a int primary key, b varchar(64)) 1930ENGINE=FEDERATED 1931connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1932 DEFAULT CHARSET=utf8; 1933insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe") 1934on duplicate key update a=a+100; 1935ERROR 23000: Can't write; duplicate key in table 't1' 1936select * from federated.t1; 1937a b 19381 Larry 19392 Curly 1940drop table federated.t1; 1941drop table federated.t1; 1942 1943Bug#18287 create federated table always times out, error 1159 ' ' 1944 1945Test that self-references work 1946 1947create table federated.t1 (a int primary key); 1948create table federated.t2 (a int primary key) 1949ENGINE=FEDERATED 1950connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1951insert into federated.t1 (a) values (1); 1952select * from federated.t2; 1953a 19541 1955drop table federated.t1, federated.t2; 1956CREATE TABLE federated.t1 (a INT PRIMARY KEY) DEFAULT CHARSET=utf8; 1957CREATE TABLE federated.t1 (a INT PRIMARY KEY) 1958ENGINE=FEDERATED 1959CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1960 DEFAULT CHARSET=utf8; 1961SELECT transactions FROM information_schema.engines WHERE engine="FEDERATED"; 1962transactions 1963NO 1964INSERT INTO federated.t1 VALUES (1); 1965SET autocommit=0; 1966INSERT INTO federated.t1 VALUES (2); 1967ROLLBACK; 1968Warnings: 1969Warning 1196 Some non-transactional changed tables couldn't be rolled back 1970SET autocommit=1; 1971SELECT * FROM federated.t1; 1972a 19731 19742 1975DROP TABLE federated.t1; 1976DROP TABLE federated.t1; 1977create table t1 (a varchar(256)); 1978drop view if exists v1; 1979create view v1 as select a from t1; 1980create table t1 1981(a varchar(256)) engine=federated 1982connection='mysql://root@127.0.0.1:SLAVE_PORT/test/v1'; 1983select 1 from t1 order by a; 19841 19851 19861 19871 19881 19891 19901 19911 19921 19931 19941 19951 19961 19971 19981 19991 20001 20011 20021 20031 20041 20051 20061 20071 20081 20091 20101 20111 20121 20131 20141 20151 20161 20171 20181 20191 20201 20211 20221 20231 20241 20251 20261 20271 20281 20291 20301 20311 20321 20331 20341 20351 20361 20371 20381 20391 20401 20411 20421 20431 20441 20451 20461 20471 20481 20491 20501 20511 20521 20531 20541 20551 20561 20571 20581 20591 20601 20611 20621 20631 20641 20651 20661 20671 20681 20691 20701 20711 20721 20731 20741 20751 20761 20771 20781 20791 20801 20811 20821 20831 20841 2085drop table t1; 2086drop table t1; 2087drop view v1; 2088CREATE TABLE t1 (a INT, b INT, KEY(a,b)); 2089INSERT INTO t1 VALUES(NULL,1),(1,NULL),(NULL,NULL),(1,1),(2,2); 2090CREATE TABLE t1 (a INT, b INT, KEY(a,b)) ENGINE=federated 2091CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2092SELECT * FROM t1 WHERE a IS NULL; 2093a b 2094NULL NULL 2095NULL 1 2096SELECT * FROM t1 WHERE a IS NOT NULL; 2097a b 20981 NULL 20991 1 21002 2 2101SELECT * FROM t1 WHERE a=1 AND b=1; 2102a b 21031 1 2104SELECT * FROM t1 WHERE a IS NULL AND b=1; 2105a b 2106NULL 1 2107SELECT * FROM t1 WHERE a IS NOT NULL AND b=1; 2108a b 21091 1 2110DROP TABLE t1; 2111DROP TABLE t1; 2112CREATE TABLE t1 (a INT) ENGINE=federated CONNECTION='mysql://@:://'; 2113DROP TABLE t1; 2114CREATE TABLE t1 (a LONGBLOB, b LONGBLOB); 2115INSERT INTO t1 VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaa', NULL); 2116CREATE TABLE t1 2117(a LONGBLOB, b LONGBLOB) ENGINE=FEDERATED 2118CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2119CHECKSUM TABLE t1; 2120Table Checksum 2121test.t1 2465757603 2122DROP TABLE t1; 2123DROP TABLE t1; 2124CREATE TABLE t1 (a TEXT, b TEXT, KEY(b(1))); 2125INSERT INTO t1 VALUES (NULL, NULL), (NULL, NULL), (NULL, NULL), (NULL, NULL); 2126CREATE TABLE t1 2127(a TEXT, b TEXT, KEY(b(1))) ENGINE=FEDERATED 2128CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2129SELECT t1.a FROM t1, t1 as t2 WHERE t2.b NOT LIKE t1.b; 2130a 2131DROP TABLE t1; 2132DROP TABLE t1; 2133# 2134# BUG#21360 - mysqldump error on federated tables 2135# 2136#Switch to Connection Slave 2137CREATE TABLE t1(id VARCHAR(20) NOT NULL, PRIMARY KEY(id)); 2138INSERT INTO t1 VALUES ('text1'),('text2'),('text3'),('text4'); 2139#Switch to Connection Master 2140CREATE TABLE t1(id VARCHAR(20) NOT NULL, PRIMARY KEY(id)) ENGINE=FEDERATED 2141CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2142# Dump table t1 using mysqldump tool 2143/*!40101 SET @saved_cs_client = @@character_set_client */; 2144/*!40101 SET character_set_client = utf8 */; 2145CREATE TABLE `t1` ( 2146 `id` varchar(20) NOT NULL, 2147 PRIMARY KEY (`id`) 2148) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2149/*!40101 SET character_set_client = @saved_cs_client */; 2150DROP TABLE t1; 2151#Switch to Connection Slave 2152DROP TABLE t1; 2153End of 5.0 tests 2154create server 's1' foreign data wrapper 'mysql' options (port 3306); 2155drop server 's1'; 2156# 2157# Bug #32426: FEDERATED query returns corrupt results for ORDER BY on a TEXT 2158# 2159CREATE TABLE federated.t1(a TEXT); 2160INSERT INTO federated.t1 VALUES('abc'), ('gh'), ('f'), ('ijk'), ('de'); 2161CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED 2162CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 2163SELECT * FROM federated.t1 ORDER BY A; 2164a 2165abc 2166de 2167f 2168gh 2169ijk 2170SELECT * FROM federated.t1 ORDER BY A DESC; 2171a 2172ijk 2173gh 2174f 2175de 2176abc 2177DROP TABLE federated.t1; 2178DROP TABLE federated.t1; 2179End of 5.1 tests 2180SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT; 2181SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT; 2182DROP TABLE IF EXISTS federated.t1; 2183DROP DATABASE federated; 2184DROP TABLE IF EXISTS federated.t1; 2185DROP DATABASE federated; 2186