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; 985SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; 986Warnings: 987Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. 988CREATE TABLE federated.t1 ( 989`blurb_id` int NOT NULL DEFAULT 0, 990`blurb` text default '', 991PRIMARY KEY (blurb_id)) 992DEFAULT CHARSET=latin1; 993Warnings: 994Warning 1101 BLOB, TEXT, GEOMETRY or JSON column 'blurb' can't have a default value 995SET sql_mode = default; 996DROP TABLE IF EXISTS federated.t1; 997SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; 998Warnings: 999Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. 1000CREATE TABLE federated.t1 ( 1001`blurb_id` int NOT NULL DEFAULT 0, 1002`blurb` text default '', 1003PRIMARY KEY (blurb_id)) 1004ENGINE="FEDERATED" 1005 DEFAULT CHARSET=latin1 1006CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1007Warnings: 1008Warning 1101 BLOB, TEXT, GEOMETRY or JSON column 'blurb' can't have a default value 1009SET sql_mode = default; 1010INSERT 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."); 1011INSERT 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."); 1012INSERT 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. "); 1013INSERT 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:"); 1014SELECT * FROM federated.t1; 1015blurb_id blurb 10161 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. 10172 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. 10183 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. 10194 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: 1020DROP TABLE IF EXISTS federated.t1; 1021CREATE TABLE federated.t1 ( 1022`a` int NOT NULL, 1023`b` int NOT NULL, 1024`c` int NOT NULL, 1025PRIMARY KEY (a),key(b)); 1026DROP TABLE IF EXISTS federated.t1; 1027CREATE TABLE federated.t1 ( 1028`a` int NOT NULL, 1029`b` int NOT NULL, 1030`c` int NOT NULL, 1031PRIMARY KEY (a), 1032KEY (b)) 1033ENGINE="FEDERATED" 1034 DEFAULT CHARSET=latin1 1035CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1036INSERT INTO federated.t1 VALUES (3,3,3),(1,1,1),(2,2,2),(4,4,4); 1037DROP TABLE IF EXISTS federated.t1; 1038CREATE TABLE federated.t1 (i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8 1039int, i9 int, i10 int, i11 int, i12 int, i13 int, i14 int, i15 int, i16 int, i17 1040int, i18 int, i19 int, i20 int, i21 int, i22 int, i23 int, i24 int, i25 int, 1041i26 int, i27 int, i28 int, i29 int, i30 int, i31 int, i32 int, i33 int, i34 1042int, i35 int, i36 int, i37 int, i38 int, i39 int, i40 int, i41 int, i42 int, 1043i43 int, i44 int, i45 int, i46 int, i47 int, i48 int, i49 int, i50 int, i51 1044int, i52 int, i53 int, i54 int, i55 int, i56 int, i57 int, i58 int, i59 int, 1045i60 int, i61 int, i62 int, i63 int, i64 int, i65 int, i66 int, i67 int, i68 1046int, i69 int, i70 int, i71 int, i72 int, i73 int, i74 int, i75 int, i76 int, 1047i77 int, i78 int, i79 int, i80 int, i81 int, i82 int, i83 int, i84 int, i85 1048int, i86 int, i87 int, i88 int, i89 int, i90 int, i91 int, i92 int, i93 int, 1049i94 int, i95 int, i96 int, i97 int, i98 int, i99 int, i100 int, i101 int, i102 1050int, i103 int, i104 int, i105 int, i106 int, i107 int, i108 int, i109 int, i110 1051int, i111 int, i112 int, i113 int, i114 int, i115 int, i116 int, i117 int, i118 1052int, i119 int, i120 int, i121 int, i122 int, i123 int, i124 int, i125 int, i126 1053int, i127 int, i128 int, i129 int, i130 int, i131 int, i132 int, i133 int, i134 1054int, i135 int, i136 int, i137 int, i138 int, i139 int, i140 int, i141 int, i142 1055int, i143 int, i144 int, i145 int, i146 int, i147 int, i148 int, i149 int, i150 1056int, i151 int, i152 int, i153 int, i154 int, i155 int, i156 int, i157 int, i158 1057int, i159 int, i160 int, i161 int, i162 int, i163 int, i164 int, i165 int, i166 1058int, i167 int, i168 int, i169 int, i170 int, i171 int, i172 int, i173 int, i174 1059int, i175 int, i176 int, i177 int, i178 int, i179 int, i180 int, i181 int, i182 1060int, i183 int, i184 int, i185 int, i186 int, i187 int, i188 int, i189 int, i190 1061int, i191 int, i192 int, i193 int, i194 int, i195 int, i196 int, i197 int, i198 1062int, i199 int, i200 int, i201 int, i202 int, i203 int, i204 int, i205 int, i206 1063int, i207 int, i208 int, i209 int, i210 int, i211 int, i212 int, i213 int, i214 1064int, i215 int, i216 int, i217 int, i218 int, i219 int, i220 int, i221 int, i222 1065int, i223 int, i224 int, i225 int, i226 int, i227 int, i228 int, i229 int, i230 1066int, i231 int, i232 int, i233 int, i234 int, i235 int, i236 int, i237 int, i238 1067int, i239 int, i240 int, i241 int, i242 int, i243 int, i244 int, i245 int, i246 1068int, i247 int, i248 int, i249 int, i250 int, i251 int, i252 int, i253 int, i254 1069int, i255 int, i256 int, i257 int, i258 int, i259 int, i260 int, i261 int, i262 1070int, i263 int, i264 int, i265 int, i266 int, i267 int, i268 int, i269 int, i270 1071int, i271 int, i272 int, i273 int, i274 int, i275 int, i276 int, i277 int, i278 1072int, i279 int, i280 int, i281 int, i282 int, i283 int, i284 int, i285 int, i286 1073int, i287 int, i288 int, i289 int, i290 int, i291 int, i292 int, i293 int, i294 1074int, i295 int, i296 int, i297 int, i298 int, i299 int, i300 int, i301 int, i302 1075int, i303 int, i304 int, i305 int, i306 int, i307 int, i308 int, i309 int, i310 1076int, i311 int, i312 int, i313 int, i314 int, i315 int, i316 int, i317 int, i318 1077int, i319 int, i320 int, i321 int, i322 int, i323 int, i324 int, i325 int, i326 1078int, i327 int, i328 int, i329 int, i330 int, i331 int, i332 int, i333 int, i334 1079int, i335 int, i336 int, i337 int, i338 int, i339 int, i340 int, i341 int, i342 1080int, i343 int, i344 int, i345 int, i346 int, i347 int, i348 int, i349 int, i350 1081int, i351 int, i352 int, i353 int, i354 int, i355 int, i356 int, i357 int, i358 1082int, i359 int, i360 int, i361 int, i362 int, i363 int, i364 int, i365 int, i366 1083int, i367 int, i368 int, i369 int, i370 int, i371 int, i372 int, i373 int, i374 1084int, i375 int, i376 int, i377 int, i378 int, i379 int, i380 int, i381 int, i382 1085int, i383 int, i384 int, i385 int, i386 int, i387 int, i388 int, i389 int, i390 1086int, i391 int, i392 int, i393 int, i394 int, i395 int, i396 int, i397 int, i398 1087int, i399 int, i400 int, i401 int, i402 int, i403 int, i404 int, i405 int, i406 1088int, i407 int, i408 int, i409 int, i410 int, i411 int, i412 int, i413 int, i414 1089int, i415 int, i416 int, i417 int, i418 int, i419 int, i420 int, i421 int, i422 1090int, i423 int, i424 int, i425 int, i426 int, i427 int, i428 int, i429 int, i430 1091int, i431 int, i432 int, i433 int, i434 int, i435 int, i436 int, i437 int, i438 1092int, i439 int, i440 int, i441 int, i442 int, i443 int, i444 int, i445 int, i446 1093int, i447 int, i448 int, i449 int, i450 int, i451 int, i452 int, i453 int, i454 1094int, i455 int, i456 int, i457 int, i458 int, i459 int, i460 int, i461 int, i462 1095int, i463 int, i464 int, i465 int, i466 int, i467 int, i468 int, i469 int, i470 1096int, i471 int, i472 int, i473 int, i474 int, i475 int, i476 int, i477 int, i478 1097int, i479 int, i480 int, i481 int, i482 int, i483 int, i484 int, i485 int, i486 1098int, i487 int, i488 int, i489 int, i490 int, i491 int, i492 int, i493 int, i494 1099int, i495 int, i496 int, i497 int, i498 int, i499 int, i500 int, i501 int, i502 1100int, i503 int, i504 int, i505 int, i506 int, i507 int, i508 int, i509 int, i510 1101int, i511 int, i512 int, i513 int, i514 int, i515 int, i516 int, i517 int, i518 1102int, i519 int, i520 int, i521 int, i522 int, i523 int, i524 int, i525 int, i526 1103int, i527 int, i528 int, i529 int, i530 int, i531 int, i532 int, i533 int, i534 1104int, i535 int, i536 int, i537 int, i538 int, i539 int, i540 int, i541 int, i542 1105int, i543 int, i544 int, i545 int, i546 int, i547 int, i548 int, i549 int, i550 1106int, i551 int, i552 int, i553 int, i554 int, i555 int, i556 int, i557 int, i558 1107int, i559 int, i560 int, i561 int, i562 int, i563 int, i564 int, i565 int, i566 1108int, i567 int, i568 int, i569 int, i570 int, i571 int, i572 int, i573 int, i574 1109int, i575 int, i576 int, i577 int, i578 int, i579 int, i580 int, i581 int, i582 1110int, i583 int, i584 int, i585 int, i586 int, i587 int, i588 int, i589 int, i590 1111int, i591 int, i592 int, i593 int, i594 int, i595 int, i596 int, i597 int, i598 1112int, i599 int, i600 int, i601 int, i602 int, i603 int, i604 int, i605 int, i606 1113int, i607 int, i608 int, i609 int, i610 int, i611 int, i612 int, i613 int, i614 1114int, i615 int, i616 int, i617 int, i618 int, i619 int, i620 int, i621 int, i622 1115int, i623 int, i624 int, i625 int, i626 int, i627 int, i628 int, i629 int, i630 1116int, i631 int, i632 int, i633 int, i634 int, i635 int, i636 int, i637 int, i638 1117int, i639 int, i640 int, i641 int, i642 int, i643 int, i644 int, i645 int, i646 1118int, i647 int, i648 int, i649 int, i650 int, i651 int, i652 int, i653 int, i654 1119int, i655 int, i656 int, i657 int, i658 int, i659 int, i660 int, i661 int, i662 1120int, i663 int, i664 int, i665 int, i666 int, i667 int, i668 int, i669 int, i670 1121int, i671 int, i672 int, i673 int, i674 int, i675 int, i676 int, i677 int, i678 1122int, i679 int, i680 int, i681 int, i682 int, i683 int, i684 int, i685 int, i686 1123int, i687 int, i688 int, i689 int, i690 int, i691 int, i692 int, i693 int, i694 1124int, i695 int, i696 int, i697 int, i698 int, i699 int, i700 int, i701 int, i702 1125int, i703 int, i704 int, i705 int, i706 int, i707 int, i708 int, i709 int, i710 1126int, i711 int, i712 int, i713 int, i714 int, i715 int, i716 int, i717 int, i718 1127int, i719 int, i720 int, i721 int, i722 int, i723 int, i724 int, i725 int, i726 1128int, i727 int, i728 int, i729 int, i730 int, i731 int, i732 int, i733 int, i734 1129int, i735 int, i736 int, i737 int, i738 int, i739 int, i740 int, i741 int, i742 1130int, i743 int, i744 int, i745 int, i746 int, i747 int, i748 int, i749 int, i750 1131int, i751 int, i752 int, i753 int, i754 int, i755 int, i756 int, i757 int, i758 1132int, i759 int, i760 int, i761 int, i762 int, i763 int, i764 int, i765 int, i766 1133int, i767 int, i768 int, i769 int, i770 int, i771 int, i772 int, i773 int, i774 1134int, i775 int, i776 int, i777 int, i778 int, i779 int, i780 int, i781 int, i782 1135int, i783 int, i784 int, i785 int, i786 int, i787 int, i788 int, i789 int, i790 1136int, i791 int, i792 int, i793 int, i794 int, i795 int, i796 int, i797 int, i798 1137int, i799 int, i800 int, i801 int, i802 int, i803 int, i804 int, i805 int, i806 1138int, i807 int, i808 int, i809 int, i810 int, i811 int, i812 int, i813 int, i814 1139int, i815 int, i816 int, i817 int, i818 int, i819 int, i820 int, i821 int, i822 1140int, i823 int, i824 int, i825 int, i826 int, i827 int, i828 int, i829 int, i830 1141int, i831 int, i832 int, i833 int, i834 int, i835 int, i836 int, i837 int, i838 1142int, i839 int, i840 int, i841 int, i842 int, i843 int, i844 int, i845 int, i846 1143int, i847 int, i848 int, i849 int, i850 int, i851 int, i852 int, i853 int, i854 1144int, i855 int, i856 int, i857 int, i858 int, i859 int, i860 int, i861 int, i862 1145int, i863 int, i864 int, i865 int, i866 int, i867 int, i868 int, i869 int, i870 1146int, i871 int, i872 int, i873 int, i874 int, i875 int, i876 int, i877 int, i878 1147int, i879 int, i880 int, i881 int, i882 int, i883 int, i884 int, i885 int, i886 1148int, i887 int, i888 int, i889 int, i890 int, i891 int, i892 int, i893 int, i894 1149int, i895 int, i896 int, i897 int, i898 int, i899 int, i900 int, i901 int, i902 1150int, i903 int, i904 int, i905 int, i906 int, i907 int, i908 int, i909 int, i910 1151int, i911 int, i912 int, i913 int, i914 int, i915 int, i916 int, i917 int, i918 1152int, i919 int, i920 int, i921 int, i922 int, i923 int, i924 int, i925 int, i926 1153int, i927 int, i928 int, i929 int, i930 int, i931 int, i932 int, i933 int, i934 1154int, i935 int, i936 int, i937 int, i938 int, i939 int, i940 int, i941 int, i942 1155int, i943 int, i944 int, i945 int, i946 int, i947 int, i948 int, i949 int, i950 1156int, i951 int, i952 int, i953 int, i954 int, i955 int, i956 int, i957 int, i958 1157int, i959 int, i960 int, i961 int, i962 int, i963 int, i964 int, i965 int, i966 1158int, i967 int, i968 int, i969 int, i970 int, i971 int, i972 int, i973 int, i974 1159int, i975 int, i976 int, i977 int, i978 int, i979 int, i980 int, i981 int, i982 1160int, i983 int, i984 int, i985 int, i986 int, i987 int, i988 int, i989 int, i990 1161int, i991 int, i992 int, i993 int, i994 int, i995 int, i996 int, i997 int, i998 1162int, i999 int, i1000 int, b varchar(256)) 1163row_format=dynamic; 1164DROP TABLE IF EXISTS federated.t1; 1165CREATE TABLE federated.t1 1166(i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8 1167int, i9 int, i10 int, i11 int, i12 int, i13 int, i14 int, i15 int, i16 int, 1168i17 int, i18 int, i19 int, i20 int, i21 int, i22 int, i23 int, i24 int, i25 int, 1169i26 int, i27 int, i28 int, i29 int, i30 int, i31 int, i32 int, i33 int, i34 1170int, i35 int, i36 int, i37 int, i38 int, i39 int, i40 int, i41 int, i42 int, 1171i43 int, i44 int, i45 int, i46 int, i47 int, i48 int, i49 int, i50 int, i51 1172int, i52 int, i53 int, i54 int, i55 int, i56 int, i57 int, i58 int, i59 int, 1173i60 int, i61 int, i62 int, i63 int, i64 int, i65 int, i66 int, i67 int, i68 1174int, i69 int, i70 int, i71 int, i72 int, i73 int, i74 int, i75 int, i76 int, 1175i77 int, i78 int, i79 int, i80 int, i81 int, i82 int, i83 int, i84 int, i85 1176int, i86 int, i87 int, i88 int, i89 int, i90 int, i91 int, i92 int, i93 int, 1177i94 int, i95 int, i96 int, i97 int, i98 int, i99 int, i100 int, i101 int, i102 1178int, i103 int, i104 int, i105 int, i106 int, i107 int, i108 int, i109 int, i110 1179int, i111 int, i112 int, i113 int, i114 int, i115 int, i116 int, i117 int, i118 1180int, i119 int, i120 int, i121 int, i122 int, i123 int, i124 int, i125 int, i126 1181int, i127 int, i128 int, i129 int, i130 int, i131 int, i132 int, i133 int, i134 1182int, i135 int, i136 int, i137 int, i138 int, i139 int, i140 int, i141 int, i142 1183int, i143 int, i144 int, i145 int, i146 int, i147 int, i148 int, i149 int, i150 1184int, i151 int, i152 int, i153 int, i154 int, i155 int, i156 int, i157 int, i158 1185int, i159 int, i160 int, i161 int, i162 int, i163 int, i164 int, i165 int, i166 1186int, i167 int, i168 int, i169 int, i170 int, i171 int, i172 int, i173 int, i174 1187int, i175 int, i176 int, i177 int, i178 int, i179 int, i180 int, i181 int, i182 1188int, i183 int, i184 int, i185 int, i186 int, i187 int, i188 int, i189 int, i190 1189int, i191 int, i192 int, i193 int, i194 int, i195 int, i196 int, i197 int, i198 1190int, i199 int, i200 int, i201 int, i202 int, i203 int, i204 int, i205 int, i206 1191int, i207 int, i208 int, i209 int, i210 int, i211 int, i212 int, i213 int, i214 1192int, i215 int, i216 int, i217 int, i218 int, i219 int, i220 int, i221 int, i222 1193int, i223 int, i224 int, i225 int, i226 int, i227 int, i228 int, i229 int, i230 1194int, i231 int, i232 int, i233 int, i234 int, i235 int, i236 int, i237 int, i238 1195int, i239 int, i240 int, i241 int, i242 int, i243 int, i244 int, i245 int, i246 1196int, i247 int, i248 int, i249 int, i250 int, i251 int, i252 int, i253 int, i254 1197int, i255 int, i256 int, i257 int, i258 int, i259 int, i260 int, i261 int, i262 1198int, i263 int, i264 int, i265 int, i266 int, i267 int, i268 int, i269 int, i270 1199int, i271 int, i272 int, i273 int, i274 int, i275 int, i276 int, i277 int, i278 1200int, i279 int, i280 int, i281 int, i282 int, i283 int, i284 int, i285 int, i286 1201int, i287 int, i288 int, i289 int, i290 int, i291 int, i292 int, i293 int, i294 1202int, i295 int, i296 int, i297 int, i298 int, i299 int, i300 int, i301 int, i302 1203int, i303 int, i304 int, i305 int, i306 int, i307 int, i308 int, i309 int, i310 1204int, i311 int, i312 int, i313 int, i314 int, i315 int, i316 int, i317 int, i318 1205int, i319 int, i320 int, i321 int, i322 int, i323 int, i324 int, i325 int, i326 1206int, i327 int, i328 int, i329 int, i330 int, i331 int, i332 int, i333 int, i334 1207int, i335 int, i336 int, i337 int, i338 int, i339 int, i340 int, i341 int, i342 1208int, i343 int, i344 int, i345 int, i346 int, i347 int, i348 int, i349 int, i350 1209int, i351 int, i352 int, i353 int, i354 int, i355 int, i356 int, i357 int, i358 1210int, i359 int, i360 int, i361 int, i362 int, i363 int, i364 int, i365 int, i366 1211int, i367 int, i368 int, i369 int, i370 int, i371 int, i372 int, i373 int, i374 1212int, i375 int, i376 int, i377 int, i378 int, i379 int, i380 int, i381 int, i382 1213int, i383 int, i384 int, i385 int, i386 int, i387 int, i388 int, i389 int, i390 1214int, i391 int, i392 int, i393 int, i394 int, i395 int, i396 int, i397 int, i398 1215int, i399 int, i400 int, i401 int, i402 int, i403 int, i404 int, i405 int, i406 1216int, i407 int, i408 int, i409 int, i410 int, i411 int, i412 int, i413 int, i414 1217int, i415 int, i416 int, i417 int, i418 int, i419 int, i420 int, i421 int, i422 1218int, i423 int, i424 int, i425 int, i426 int, i427 int, i428 int, i429 int, i430 1219int, i431 int, i432 int, i433 int, i434 int, i435 int, i436 int, i437 int, i438 1220int, i439 int, i440 int, i441 int, i442 int, i443 int, i444 int, i445 int, i446 1221int, i447 int, i448 int, i449 int, i450 int, i451 int, i452 int, i453 int, i454 1222int, i455 int, i456 int, i457 int, i458 int, i459 int, i460 int, i461 int, i462 1223int, i463 int, i464 int, i465 int, i466 int, i467 int, i468 int, i469 int, i470 1224int, i471 int, i472 int, i473 int, i474 int, i475 int, i476 int, i477 int, i478 1225int, i479 int, i480 int, i481 int, i482 int, i483 int, i484 int, i485 int, i486 1226int, i487 int, i488 int, i489 int, i490 int, i491 int, i492 int, i493 int, i494 1227int, i495 int, i496 int, i497 int, i498 int, i499 int, i500 int, i501 int, i502 1228int, i503 int, i504 int, i505 int, i506 int, i507 int, i508 int, i509 int, i510 1229int, i511 int, i512 int, i513 int, i514 int, i515 int, i516 int, i517 int, i518 1230int, i519 int, i520 int, i521 int, i522 int, i523 int, i524 int, i525 int, i526 1231int, i527 int, i528 int, i529 int, i530 int, i531 int, i532 int, i533 int, i534 1232int, i535 int, i536 int, i537 int, i538 int, i539 int, i540 int, i541 int, i542 1233int, i543 int, i544 int, i545 int, i546 int, i547 int, i548 int, i549 int, i550 1234int, i551 int, i552 int, i553 int, i554 int, i555 int, i556 int, i557 int, i558 1235int, i559 int, i560 int, i561 int, i562 int, i563 int, i564 int, i565 int, i566 1236int, i567 int, i568 int, i569 int, i570 int, i571 int, i572 int, i573 int, i574 1237int, i575 int, i576 int, i577 int, i578 int, i579 int, i580 int, i581 int, i582 1238int, i583 int, i584 int, i585 int, i586 int, i587 int, i588 int, i589 int, i590 1239int, i591 int, i592 int, i593 int, i594 int, i595 int, i596 int, i597 int, i598 1240int, i599 int, i600 int, i601 int, i602 int, i603 int, i604 int, i605 int, i606 1241int, i607 int, i608 int, i609 int, i610 int, i611 int, i612 int, i613 int, i614 1242int, i615 int, i616 int, i617 int, i618 int, i619 int, i620 int, i621 int, i622 1243int, i623 int, i624 int, i625 int, i626 int, i627 int, i628 int, i629 int, i630 1244int, i631 int, i632 int, i633 int, i634 int, i635 int, i636 int, i637 int, i638 1245int, i639 int, i640 int, i641 int, i642 int, i643 int, i644 int, i645 int, i646 1246int, i647 int, i648 int, i649 int, i650 int, i651 int, i652 int, i653 int, i654 1247int, i655 int, i656 int, i657 int, i658 int, i659 int, i660 int, i661 int, i662 1248int, i663 int, i664 int, i665 int, i666 int, i667 int, i668 int, i669 int, i670 1249int, i671 int, i672 int, i673 int, i674 int, i675 int, i676 int, i677 int, i678 1250int, i679 int, i680 int, i681 int, i682 int, i683 int, i684 int, i685 int, i686 1251int, i687 int, i688 int, i689 int, i690 int, i691 int, i692 int, i693 int, i694 1252int, i695 int, i696 int, i697 int, i698 int, i699 int, i700 int, i701 int, i702 1253int, i703 int, i704 int, i705 int, i706 int, i707 int, i708 int, i709 int, i710 1254int, i711 int, i712 int, i713 int, i714 int, i715 int, i716 int, i717 int, i718 1255int, i719 int, i720 int, i721 int, i722 int, i723 int, i724 int, i725 int, i726 1256int, i727 int, i728 int, i729 int, i730 int, i731 int, i732 int, i733 int, i734 1257int, i735 int, i736 int, i737 int, i738 int, i739 int, i740 int, i741 int, i742 1258int, i743 int, i744 int, i745 int, i746 int, i747 int, i748 int, i749 int, i750 1259int, i751 int, i752 int, i753 int, i754 int, i755 int, i756 int, i757 int, i758 1260int, i759 int, i760 int, i761 int, i762 int, i763 int, i764 int, i765 int, i766 1261int, i767 int, i768 int, i769 int, i770 int, i771 int, i772 int, i773 int, i774 1262int, i775 int, i776 int, i777 int, i778 int, i779 int, i780 int, i781 int, i782 1263int, i783 int, i784 int, i785 int, i786 int, i787 int, i788 int, i789 int, i790 1264int, i791 int, i792 int, i793 int, i794 int, i795 int, i796 int, i797 int, i798 1265int, i799 int, i800 int, i801 int, i802 int, i803 int, i804 int, i805 int, i806 1266int, i807 int, i808 int, i809 int, i810 int, i811 int, i812 int, i813 int, i814 1267int, i815 int, i816 int, i817 int, i818 int, i819 int, i820 int, i821 int, i822 1268int, i823 int, i824 int, i825 int, i826 int, i827 int, i828 int, i829 int, i830 1269int, i831 int, i832 int, i833 int, i834 int, i835 int, i836 int, i837 int, i838 1270int, i839 int, i840 int, i841 int, i842 int, i843 int, i844 int, i845 int, i846 1271int, i847 int, i848 int, i849 int, i850 int, i851 int, i852 int, i853 int, i854 1272int, i855 int, i856 int, i857 int, i858 int, i859 int, i860 int, i861 int, i862 1273int, i863 int, i864 int, i865 int, i866 int, i867 int, i868 int, i869 int, i870 1274int, i871 int, i872 int, i873 int, i874 int, i875 int, i876 int, i877 int, i878 1275int, i879 int, i880 int, i881 int, i882 int, i883 int, i884 int, i885 int, i886 1276int, i887 int, i888 int, i889 int, i890 int, i891 int, i892 int, i893 int, i894 1277int, i895 int, i896 int, i897 int, i898 int, i899 int, i900 int, i901 int, i902 1278int, i903 int, i904 int, i905 int, i906 int, i907 int, i908 int, i909 int, i910 1279int, i911 int, i912 int, i913 int, i914 int, i915 int, i916 int, i917 int, i918 1280int, i919 int, i920 int, i921 int, i922 int, i923 int, i924 int, i925 int, i926 1281int, i927 int, i928 int, i929 int, i930 int, i931 int, i932 int, i933 int, i934 1282int, i935 int, i936 int, i937 int, i938 int, i939 int, i940 int, i941 int, i942 1283int, i943 int, i944 int, i945 int, i946 int, i947 int, i948 int, i949 int, i950 1284int, i951 int, i952 int, i953 int, i954 int, i955 int, i956 int, i957 int, i958 1285int, i959 int, i960 int, i961 int, i962 int, i963 int, i964 int, i965 int, i966 1286int, i967 int, i968 int, i969 int, i970 int, i971 int, i972 int, i973 int, i974 1287int, i975 int, i976 int, i977 int, i978 int, i979 int, i980 int, i981 int, i982 1288int, i983 int, i984 int, i985 int, i986 int, i987 int, i988 int, i989 int, i990 1289int, i991 int, i992 int, i993 int, i994 int, i995 int, i996 int, i997 int, i998 1290int, i999 int, i1000 int, b varchar(256)) 1291row_format=dynamic 1292ENGINE="FEDERATED" 1293DEFAULT CHARSET=latin1 1294CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1295INSERT INTO federated.t1 1296values (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, 1, 1, 1, 1, 1, 1, 1, 13261, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13271, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13281, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13291, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13301, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13311, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13321, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13331, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 13341, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, "PatrickG"); 1335UPDATE federated.t1 SET b=repeat('a',256); 1336UPDATE federated.t1 SET i1=0, i2=0, i3=0, i4=0, i5=0, i6=0, i7=0, i8=0, i9=0, i10=0; 1337SELECT * FROM federated.t1 WHERE i9=0 and i10=0; 1338i1 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 13390 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 1340UPDATE federated.t1 SET i50=20; 1341SELECT * FROM federated.t1; 1342i1 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 13430 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 1344DELETE FROM federated.t1 WHERE i51=20; 1345SELECT * FROM federated.t1; 1346i1 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 13470 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 1348DELETE FROM federated.t1 WHERE i50=20; 1349SELECT * FROM federated.t1; 1350i1 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 1351DROP TABLE IF EXISTS federated.t1; 1352CREATE 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; 1353DROP TABLE IF EXISTS federated.t1; 1354CREATE TABLE federated.t1 ( 1355id int NOT NULL auto_increment, 1356code char(20) NOT NULL, 1357fileguts blob NOT NULL, 1358creation_date datetime, 1359entered_time datetime default '2004-04-04 04:04:04', 1360PRIMARY KEY(id), 1361index(code), 1362index(fileguts(10))) 1363ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1364CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1365INSERT 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'); 1366INSERT 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'); 1367INSERT INTO federated.t1 (code, fileguts, creation_date) VALUES ('DEUEUEUEUEUEUEUEUEU', 'jimbob', '2004-04-04 04:04:04'); 1368SELECT * FROM federated.t1; 1369id code fileguts creation_date entered_time 13701 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 13712 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 13723 DEUEUEUEUEUEUEUEUEU jimbob 2004-04-04 04:04:04 2004-04-04 04:04:04 1373SELECT * FROM federated.t1 WHERE fileguts = 'jimbob'; 1374id code fileguts creation_date entered_time 13753 DEUEUEUEUEUEUEUEUEU jimbob 2004-04-04 04:04:04 2004-04-04 04:04:04 1376DROP TABLE IF EXISTS federated.t1; 1377CREATE TABLE federated.t1 (`a` BLOB); 1378DROP TABLE IF EXISTS federated.t1; 1379CREATE TABLE federated.t1 ( 1380`a` BLOB) 1381ENGINE="FEDERATED" 1382CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1383INSERT INTO federated.t1 VALUES (0x00); 1384INSERT INTO federated.t1 VALUES (0x0001); 1385INSERT INTO federated.t1 VALUES (0x0100); 1386SELECT HEX(a) FROM federated.t1; 1387HEX(a) 138800 13890001 13900100 1391DROP TABLE IF EXISTS federated.t1; 1392CREATE TABLE federated.t1 ( 1393`id` int(20) NOT NULL auto_increment, 1394`country_id` int(20) NOT NULL DEFAULT 0, 1395`name` varchar(32), 1396`other` varchar(20), 1397PRIMARY KEY (`id`), 1398key (country_id)); 1399DROP TABLE IF EXISTS federated.countries; 1400Warnings: 1401Note 1051 Unknown table 'federated.countries' 1402CREATE TABLE federated.countries ( 1403`id` int(20) NOT NULL auto_increment, 1404`country` varchar(32), 1405PRIMARY KEY (id)); 1406INSERT INTO federated.countries (country) VALUES ('India'); 1407INSERT INTO federated.countries (country) VALUES ('Germany'); 1408INSERT INTO federated.countries (country) VALUES ('Italy'); 1409INSERT INTO federated.countries (country) VALUES ('Finland'); 1410INSERT INTO federated.countries (country) VALUES ('Ukraine'); 1411DROP TABLE IF EXISTS federated.t1; 1412CREATE TABLE federated.t1 ( 1413`id` int(20) NOT NULL auto_increment, 1414`country_id` int(20) NOT NULL DEFAULT 0, 1415`name` varchar(32), 1416`other` varchar(20), 1417PRIMARY KEY (`id`), 1418KEY (country_id) ) 1419ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1420CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1421INSERT INTO federated.t1 (name, country_id, other) VALUES ('Kumar', 1, 11111); 1422INSERT INTO federated.t1 (name, country_id, other) VALUES ('Lenz', 2, 22222); 1423INSERT INTO federated.t1 (name, country_id, other) VALUES ('Marizio', 3, 33333); 1424INSERT INTO federated.t1 (name, country_id, other) VALUES ('Monty', 4, 33333); 1425INSERT INTO federated.t1 (name, country_id, other) VALUES ('Sanja', 5, 33333); 1426SELECT federated.t1.name AS name, federated.t1.country_id AS country_id, 1427federated.t1.other AS other, federated.countries.country AS country 1428FROM federated.t1, federated.countries WHERE 1429federated.t1.country_id = federated.countries.id; 1430name country_id other country 1431Kumar 1 11111 India 1432Lenz 2 22222 Germany 1433Marizio 3 33333 Italy 1434Monty 4 33333 Finland 1435Sanja 5 33333 Ukraine 1436SELECT federated.t1.name AS name, federated.t1.country_id AS country_id, 1437federated.t1.other AS other, federated.countries.country AS country 1438FROM federated.t1 INNER JOIN federated.countries ON 1439federated.t1.country_id = federated.countries.id; 1440name country_id other country 1441Kumar 1 11111 India 1442Lenz 2 22222 Germany 1443Marizio 3 33333 Italy 1444Monty 4 33333 Finland 1445Sanja 5 33333 Ukraine 1446SELECT federated.t1.name AS name, federated.t1.country_id AS country_id, 1447federated.t1.other AS other, federated.countries.country AS country 1448FROM federated.t1 INNER JOIN federated.countries ON 1449federated.t1.country_id = federated.countries.id 1450WHERE federated.t1.name = 'Monty'; 1451name country_id other country 1452Monty 4 33333 Finland 1453SELECT federated.t1.*, federated.countries.country 1454FROM federated.t1 LEFT JOIN federated.countries 1455ON federated.t1.country_id = federated.countries.id 1456ORDER BY federated.countries.id; 1457id country_id name other country 14581 1 Kumar 11111 India 14592 2 Lenz 22222 Germany 14603 3 Marizio 33333 Italy 14614 4 Monty 33333 Finland 14625 5 Sanja 33333 Ukraine 1463SELECT federated.t1.*, federated.countries.country 1464FROM federated.t1 LEFT JOIN federated.countries 1465ON federated.t1.country_id = federated.countries.id 1466ORDER BY federated.countries.country; 1467id country_id name other country 14684 4 Monty 33333 Finland 14692 2 Lenz 22222 Germany 14701 1 Kumar 11111 India 14713 3 Marizio 33333 Italy 14725 5 Sanja 33333 Ukraine 1473SELECT federated.t1.*, federated.countries.country 1474FROM federated.t1 RIGHT JOIN federated.countries 1475ON federated.t1.country_id = federated.countries.id 1476ORDER BY federated.t1.country_id; 1477id country_id name other country 14781 1 Kumar 11111 India 14792 2 Lenz 22222 Germany 14803 3 Marizio 33333 Italy 14814 4 Monty 33333 Finland 14825 5 Sanja 33333 Ukraine 1483DROP TABLE federated.countries; 1484OPTIMIZE TABLE federated.t1; 1485Table Op Msg_type Msg_text 1486federated.t1 optimize status OK 1487REPAIR TABLE federated.t1; 1488Table Op Msg_type Msg_text 1489federated.t1 repair status OK 1490REPAIR TABLE federated.t1 QUICK; 1491Table Op Msg_type Msg_text 1492federated.t1 repair status OK 1493REPAIR TABLE federated.t1 EXTENDED; 1494Table Op Msg_type Msg_text 1495federated.t1 repair status OK 1496REPAIR TABLE federated.t1 USE_FRM; 1497Table Op Msg_type Msg_text 1498federated.t1 repair status OK 1499DROP TABLE IF EXISTS federated.normal_table; 1500CREATE TABLE federated.normal_table ( 1501`id` int(4) NOT NULL, 1502`name` varchar(10) default NULL 1503) DEFAULT CHARSET=latin1; 1504DROP TABLE IF EXISTS federated.alter_me; 1505CREATE TABLE federated.alter_me ( 1506`id` int(4) NOT NULL, 1507`name` varchar(10) default NULL, 1508PRIMARY KEY (`id`) 1509) ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1510CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/normal_table'; 1511INSERT INTO federated.alter_me (id, name) VALUES (1, 'Monty'); 1512INSERT INTO federated.alter_me (id, name) VALUES (2, 'David'); 1513SELECT * FROM federated.alter_me; 1514id name 15151 Monty 15162 David 1517ALTER TABLE federated.alter_me MODIFY COLUMN id int(16) NOT NULL; 1518ERROR HY000: Table storage engine for 'alter_me' doesn't have this option 1519SELECT * FROM federated.alter_me; 1520id name 15211 Monty 15222 David 1523DROP TABLE federated.alter_me; 1524DROP TABLE federated.normal_table; 1525DROP TABLE IF EXISTS federated.t1; 1526CREATE TABLE federated.t1 ( 1527`bitty` bit(3) 1528) DEFAULT CHARSET=latin1; 1529DROP TABLE IF EXISTS federated.t1; 1530CREATE TABLE federated.t1 ( 1531`bitty` bit(3) 1532) ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1533CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1534INSERT INTO federated.t1 VALUES (b'001'); 1535INSERT INTO federated.t1 VALUES (b'010'); 1536INSERT INTO federated.t1 VALUES (b'011'); 1537INSERT INTO federated.t1 VALUES (b'100'); 1538INSERT INTO federated.t1 VALUES (b'101'); 1539INSERT INTO federated.t1 VALUES (b'110'); 1540INSERT INTO federated.t1 VALUES (b'111'); 1541select * FROM federated.t1; 1542bitty 1543 1544 1545 1546 1547 1548 1549 1550drop table federated.t1; 1551drop table federated.t1; 1552DROP TABLE IF EXISTS federated.t1; 1553Warnings: 1554Note 1051 Unknown table 'federated.t1' 1555CREATE TABLE federated.t1 ( 1556`id` int(20) NOT NULL auto_increment, 1557PRIMARY KEY (`id`)); 1558DROP TABLE IF EXISTS federated.t1; 1559Warnings: 1560Note 1051 Unknown table 'federated.t1' 1561CREATE TABLE federated.t1 ( 1562`id` int(20) NOT NULL auto_increment, 1563PRIMARY KEY (`id`) 1564) 1565ENGINE="FEDERATED" DEFAULT CHARSET=latin1 1566CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1567INSERT INTO federated.t1 VALUES (); 1568SELECT LAST_INSERT_ID(); 1569LAST_INSERT_ID() 15701 1571INSERT INTO federated.t1 VALUES (); 1572SELECT LAST_INSERT_ID(); 1573LAST_INSERT_ID() 15742 1575INSERT INTO federated.t1 VALUES (); 1576SELECT LAST_INSERT_ID(); 1577LAST_INSERT_ID() 15783 1579INSERT INTO federated.t1 VALUES (); 1580SELECT LAST_INSERT_ID(); 1581LAST_INSERT_ID() 15824 1583INSERT INTO federated.t1 VALUES (); 1584SELECT LAST_INSERT_ID(); 1585LAST_INSERT_ID() 15865 1587SELECT * FROM federated.t1; 1588id 15891 15902 15913 15924 15935 1594DROP TABLE federated.t1; 1595DROP TABLE federated.t1; 1596DROP TABLE IF EXISTS federated.bug_17377_table; 1597CREATE TABLE federated.bug_17377_table ( 1598`fld_cid` bigint(20) NOT NULL auto_increment, 1599`fld_name` varchar(255) NOT NULL default '', 1600`fld_parentid` bigint(20) NOT NULL default '0', 1601`fld_delt` int(1) NOT NULL default '0', 1602PRIMARY KEY (`fld_cid`), 1603KEY `fld_parentid` (`fld_parentid`), 1604KEY `fld_delt` (`fld_delt`), 1605KEY `fld_cid` (`fld_cid`) 1606) ENGINE=MyISAM; 1607insert into federated.bug_17377_table( fld_name ) 1608values 1609("Mats"), ("Sivert"), ("Sigvard"), ("Torgny"), ("Torkel"); 1610DROP TABLE IF EXISTS federated.t1; 1611CREATE TABLE federated.t1 ( 1612`fld_cid` bigint(20) NOT NULL auto_increment, 1613`fld_name` varchar(255) NOT NULL default '', 1614`fld_parentid` bigint(20) NOT NULL default '0', 1615`fld_delt` int(1) NOT NULL default '0', 1616PRIMARY KEY (`fld_cid`), 1617KEY `fld_parentid` (`fld_parentid`), 1618KEY `fld_delt` (`fld_delt`), 1619KEY `fld_cid` (`fld_cid`) 1620) ENGINE=FEDERATED 1621CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/bug_17377_table'; 1622select * from federated.t1 where fld_parentid=0 and fld_delt=0 1623order by fld_name; 1624fld_cid fld_name fld_parentid fld_delt 16251 Mats 0 0 16263 Sigvard 0 0 16272 Sivert 0 0 16284 Torgny 0 0 16295 Torkel 0 0 1630select * from federated.t1 where fld_parentid=0 and fld_delt=0; 1631fld_cid fld_name fld_parentid fld_delt 16321 Mats 0 0 16332 Sivert 0 0 16343 Sigvard 0 0 16354 Torgny 0 0 16365 Torkel 0 0 1637DROP TABLE federated.t1; 1638DROP TABLE federated.bug_17377_table; 1639DROP TABLE IF EXISTS federated.test; 1640CREATE TABLE federated.test ( 1641`id` int(11) NOT NULL, 1642`val1` varchar(255) NOT NULL, 1643`val2` varchar(255) NOT NULL, 1644PRIMARY KEY (`id`) 1645) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1646DROP TABLE IF EXISTS federated.test_local; 1647DROP TABLE IF EXISTS federated.test_remote; 1648CREATE TABLE federated.test_local ( 1649`id` int(11) NOT NULL, 1650`val1` varchar(255) NOT NULL, 1651`val2` varchar(255) NOT NULL, 1652PRIMARY KEY (`id`) 1653) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1654INSERT INTO federated.test_local VALUES (1, 'foo', 'bar'), 1655(2, 'bar', 'foo'); 1656CREATE TABLE federated.test_remote ( 1657`id` int(11) NOT NULL, 1658`val1` varchar(255) NOT NULL, 1659`val2` varchar(255) NOT NULL, 1660PRIMARY KEY (`id`) 1661) ENGINE=FEDERATED DEFAULT CHARSET=latin1 1662CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/test'; 1663insert into federated.test_remote select * from federated.test_local; 1664select * from federated.test_remote; 1665id val1 val2 16661 foo bar 16672 bar foo 1668delete from federated.test_remote where id in (1,2); 1669insert into federated.test_remote select * from federated.test_local; 1670select * from federated.test_remote; 1671id val1 val2 16722 bar foo 16731 foo bar 1674DROP TABLE federated.test_local; 1675DROP TABLE federated.test_remote; 1676DROP TABLE federated.test; 1677drop table if exists federated.t1; 1678create table federated.t1 (a int, b int, c int); 1679drop table if exists federated.t1; 1680drop table if exists federated.t2; 1681create table federated.t1 (a int, b int, c int) engine=federated connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1682create trigger federated.t1_bi before insert on federated.t1 for each row set new.c= new.a * new.b; 1683create table federated.t2 (a int, b int); 1684insert into federated.t2 values (13, 17), (19, 23); 1685insert into federated.t1 (a, b) values (1, 2), (3, 5), (7, 11); 1686select * from federated.t1 order by a; 1687a b c 16881 2 2 16893 5 15 16907 11 77 1691delete from federated.t1; 1692insert into federated.t1 (a, b) select * from federated.t2; 1693select * from federated.t1 order by a; 1694a b c 169513 17 221 169619 23 437 1697delete from federated.t1; 1698load data infile '../../std_data/loaddata5.dat' into table federated.t1 fields terminated by '' enclosed by '' ignore 1 lines (a, b); 1699select * from federated.t1 order by a; 1700a b c 17013 4 12 17025 6 30 1703drop tables federated.t1, federated.t2; 1704drop table federated.t1; 1705create table federated.t1 (i1 int, i2 int, i3 int); 1706create table federated.t2 (id int, c1 varchar(20), c2 varchar(20)); 1707create table federated.t1 (i1 int, i2 int, i3 int) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1708create table federated.t2 (id int, c1 varchar(20), c2 varchar(20)) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t2'; 1709insert into federated.t1 values (1,5,10),(3,7,12),(4,5,2),(9,10,15),(2,2,2); 1710insert into federated.t2 values (9,"abc","def"),(5,"opq","lmn"),(2,"test t","t test"); 1711select * from federated.t1 order by i1; 1712i1 i2 i3 17131 5 10 17142 2 2 17153 7 12 17164 5 2 17179 10 15 1718select * from federated.t2; 1719id c1 c2 17209 abc def 17215 opq lmn 17222 test t t test 1723update federated.t1,federated.t2 set t1.i2=15, t2.c2="ppc" where t1.i1=t2.id; 1724select * from federated.t1 order by i1; 1725i1 i2 i3 17261 5 10 17272 15 2 17283 7 12 17294 5 2 17309 15 15 1731select * from federated.t2 order by id; 1732id c1 c2 17332 test t ppc 17345 opq lmn 17359 abc ppc 1736delete federated.t1.*,federated.t2.* from federated.t1,federated.t2 where t1.i2=t2.id; 1737select * from federated.t1 order by i1; 1738i1 i2 i3 17392 15 2 17403 7 12 17419 15 15 1742select * from federated.t2 order by id; 1743id c1 c2 17442 test t ppc 17459 abc ppc 1746drop table federated.t1, federated.t2; 1747drop table federated.t1, federated.t2; 1748create table federated.t1 (i1 int, i2 int, i3 int, primary key (i1)); 1749create table federated.t2 (id int, c1 varchar(20), c2 varchar(20), primary key (id)); 1750create 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'; 1751create 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'; 1752insert into federated.t1 values (1,5,10),(3,7,12),(4,5,2),(9,10,15),(2,2,2); 1753insert into federated.t2 values (9,"abc","def"),(5,"opq","lmn"),(2,"test t","t test"); 1754select * from federated.t1 order by i1; 1755i1 i2 i3 17561 5 10 17572 2 2 17583 7 12 17594 5 2 17609 10 15 1761select * from federated.t2 order by id; 1762id c1 c2 17632 test t t test 17645 opq lmn 17659 abc def 1766update federated.t1,federated.t2 set t1.i2=15, t2.c2="ppc" where t1.i1=t2.id; 1767select * from federated.t1 order by i1; 1768i1 i2 i3 17691 5 10 17702 15 2 17713 7 12 17724 5 2 17739 15 15 1774select * from federated.t2 order by id; 1775id c1 c2 17762 test t ppc 17775 opq lmn 17789 abc ppc 1779delete federated.t1.*,federated.t2.* from federated.t1,federated.t2 where t1.i2=t2.id; 1780select * from federated.t1 order by i1; 1781i1 i2 i3 17822 15 2 17833 7 12 17849 15 15 1785select * from federated.t2 order by id; 1786id c1 c2 17872 test t ppc 17889 abc ppc 1789drop table federated.t1, federated.t2; 1790drop table federated.t1, federated.t2; 1791create table t1 (id int not null auto_increment primary key, val int); 1792create table t1 1793(id int not null auto_increment primary key, val int) engine=federated 1794connection='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 1795insert into t1 values (1,0),(2,0); 1796update t1 set val = NULL where id = 1; 1797select * from t1; 1798id val 17991 NULL 18002 0 1801select * from t1; 1802id val 18031 NULL 18042 0 1805drop table t1; 1806drop table t1; 1807create table t1 (a longblob not null); 1808create table t1 1809(a longblob not null) engine=federated 1810connection='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 1811insert into t1 values (repeat('a',5000)); 1812select length(a) from t1; 1813length(a) 18145000 1815select length(a) from t1; 1816length(a) 18175000 1818drop table t1; 1819drop table t1; 1820DROP TABLE IF EXISTS federated.test; 1821CREATE TABLE federated.test ( 1822`i` int(11) NOT NULL, 1823`j` int(11) NOT NULL, 1824`c` varchar(30) default NULL, 1825PRIMARY KEY (`i`,`j`), 1826UNIQUE KEY `i` (`i`,`c`) 1827) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1828DROP TABLE IF EXISTS federated.test1; 1829DROP TABLE IF EXISTS federated.test2; 1830create table federated.test1 ( 1831i int not null, 1832j int not null, 1833c varchar(30), 1834primary key (i,j), 1835unique key (i, c)) 1836engine = federated 1837connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/test'; 1838create table federated.test2 ( 1839i int default null, 1840j int not null, 1841c varchar(30), 1842key (i)) 1843engine = federated 1844connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/test'; 1845drop table federated.test1, federated.test2; 1846drop table federated.test; 1847set names utf8; 1848create table federated.t1 (a varchar(64)) DEFAULT CHARSET=utf8; 1849insert into federated.t1 values (0x6DC3A56E6164); 1850select hex(a) from federated.t1; 1851hex(a) 18526DC3A56E6164 1853create table federated.t1 (a varchar(64)) 1854ENGINE=FEDERATED 1855connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1856DEFAULT CHARSET=utf8; 1857set names utf8; 1858select hex(a) from federated.t1; 1859hex(a) 18606DC3A56E6164 1861insert into federated.t1 values (0xC3A4C3B6C3BCC39F); 1862insert into federated.t1 values (0xD18DD184D184D0B5D0BAD182D0B8D0B2D0BDD183D18E); 1863select hex(a) from federated.t1; 1864hex(a) 18656DC3A56E6164 1866C3A4C3B6C3BCC39F 1867D18DD184D184D0B5D0BAD182D0B8D0B2D0BDD183D18E 1868select hex(a) from federated.t1; 1869hex(a) 18706DC3A56E6164 1871C3A4C3B6C3BCC39F 1872D18DD184D184D0B5D0BAD182D0B8D0B2D0BDD183D18E 1873drop table federated.t1; 1874drop table federated.t1; 1875CREATE TABLE federated.t1 ( 1876categoryId int(11) NOT NULL AUTO_INCREMENT, 1877domainId varchar(745) NOT NULL DEFAULT '', 1878categoryName varchar(255) NOT NULL DEFAULT '', 1879PRIMARY KEY (categoryId), 1880UNIQUE KEY idx_unique_category_categoryName (domainId, categoryName), 1881KEY idx_category_domainId (domainId) 1882) ENGINE=MyISAM DEFAULT CHARSET=latin1; 1883CREATE TABLE federated.t1 ( 1884categoryId int(11) NOT NULL AUTO_INCREMENT, 1885domainId varchar(745) NOT NULL DEFAULT '', 1886categoryName varchar(255) NOT NULL DEFAULT '', 1887PRIMARY KEY (categoryId), 1888UNIQUE KEY idx_unique_category_categoryName (domainId, categoryName), 1889KEY idx_category_domainId (domainId) 1890) ENGINE=FEDERATED DEFAULT CHARSET=latin1 1891CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1892insert into federated.t1 (domainId, categoryName) values ( '1231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231231 300', '1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345 250'); 1893insert into federated.t1 (domainId, categoryName) values ( '12312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312312 301', '12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456 250'); 1894insert into federated.t1 (domainId, categoryName) values ('a', 'b'); 1895select categoryId from federated.t1 order by domainId, categoryName; 1896categoryId 18971 18982 18993 1900select categoryId from federated.t1 where domainId='a' and categoryName='b' order by categoryId; 1901categoryId 19023 1903select categoryId from federated.t1 where domainId='a' and categoryName='b' order by categoryId; 1904categoryId 19053 1906select categoryId from federated.t1 where domainId<>'a' and categoryName<>'b' order by categoryId; 1907categoryId 19081 19092 1910drop table federated.t1; 1911drop table federated.t1; 1912create table federated.t1 (a int primary key, b varchar(64)) 1913DEFAULT CHARSET=utf8; 1914create table federated.t1 (a int primary key, b varchar(64)) 1915ENGINE=FEDERATED 1916connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1917 DEFAULT CHARSET=utf8; 1918insert ignore into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe"); 1919select * from federated.t1; 1920a b 19211 Larry 19222 Curly 1923truncate federated.t1; 1924replace into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe"); 1925select * from federated.t1; 1926a b 19271 Moe 19282 Curly 1929update ignore federated.t1 set a=a+1; 1930select * from federated.t1; 1931a b 19321 Moe 19333 Curly 1934drop table federated.t1; 1935drop table federated.t1; 1936create table federated.t1 (a int primary key, b varchar(64)) 1937DEFAULT CHARSET=utf8; 1938create table federated.t1 (a int primary key, b varchar(64)) 1939ENGINE=FEDERATED 1940connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1941 DEFAULT CHARSET=utf8; 1942insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe") 1943on duplicate key update a=a+100; 1944ERROR 23000: Can't write; duplicate key in table 't1' 1945select * from federated.t1; 1946a b 19471 Larry 19482 Curly 1949drop table federated.t1; 1950drop table federated.t1; 1951 1952Bug#18287 create federated table always times out, error 1159 ' ' 1953 1954Test that self-references work 1955 1956create table federated.t1 (a int primary key); 1957create table federated.t2 (a int primary key) 1958ENGINE=FEDERATED 1959connection='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 1960insert into federated.t1 (a) values (1); 1961select * from federated.t2; 1962a 19631 1964drop table federated.t1, federated.t2; 1965CREATE TABLE federated.t1 (a INT PRIMARY KEY) DEFAULT CHARSET=utf8; 1966CREATE TABLE federated.t1 (a INT PRIMARY KEY) 1967ENGINE=FEDERATED 1968CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1' 1969 DEFAULT CHARSET=utf8; 1970SELECT transactions FROM information_schema.engines WHERE engine="FEDERATED"; 1971transactions 1972NO 1973INSERT INTO federated.t1 VALUES (1); 1974SET autocommit=0; 1975INSERT INTO federated.t1 VALUES (2); 1976ROLLBACK; 1977Warnings: 1978Warning 1196 Some non-transactional changed tables couldn't be rolled back 1979SET autocommit=1; 1980SELECT * FROM federated.t1; 1981a 19821 19832 1984DROP TABLE federated.t1; 1985DROP TABLE federated.t1; 1986create table t1 (a varchar(256)); 1987drop view if exists v1; 1988create view v1 as select a from t1; 1989create table t1 1990(a varchar(256)) engine=federated 1991connection='mysql://root@127.0.0.1:SLAVE_PORT/test/v1'; 1992select 1 from t1 order by a; 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 20851 20861 20871 20881 20891 20901 20911 20921 20931 2094drop table t1; 2095drop table t1; 2096drop view v1; 2097CREATE TABLE t1 (a INT, b INT, KEY(a,b)); 2098INSERT INTO t1 VALUES(NULL,1),(1,NULL),(NULL,NULL),(1,1),(2,2); 2099CREATE TABLE t1 (a INT, b INT, KEY(a,b)) ENGINE=federated 2100CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2101SELECT * FROM t1 WHERE a IS NULL; 2102a b 2103NULL NULL 2104NULL 1 2105SELECT * FROM t1 WHERE a IS NOT NULL; 2106a b 21071 NULL 21081 1 21092 2 2110SELECT * FROM t1 WHERE a=1 AND b=1; 2111a b 21121 1 2113SELECT * FROM t1 WHERE a IS NULL AND b=1; 2114a b 2115NULL 1 2116SELECT * FROM t1 WHERE a IS NOT NULL AND b=1; 2117a b 21181 1 2119DROP TABLE t1; 2120DROP TABLE t1; 2121CREATE TABLE t1 (a INT) ENGINE=federated CONNECTION='mysql://@:://'; 2122DROP TABLE t1; 2123CREATE TABLE t1 (a LONGBLOB, b LONGBLOB); 2124INSERT INTO t1 VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaa', NULL); 2125CREATE TABLE t1 2126(a LONGBLOB, b LONGBLOB) ENGINE=FEDERATED 2127CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2128CHECKSUM TABLE t1; 2129Table Checksum 2130test.t1 2465757603 2131DROP TABLE t1; 2132DROP TABLE t1; 2133CREATE TABLE t1 (a TEXT, b TEXT, KEY(b(1))); 2134INSERT INTO t1 VALUES (NULL, NULL), (NULL, NULL), (NULL, NULL), (NULL, NULL); 2135CREATE TABLE t1 2136(a TEXT, b TEXT, KEY(b(1))) ENGINE=FEDERATED 2137CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2138SELECT t1.a FROM t1, t1 as t2 WHERE t2.b NOT LIKE t1.b; 2139a 2140DROP TABLE t1; 2141DROP TABLE t1; 2142# 2143# BUG#21360 - mysqldump error on federated tables 2144# 2145#Switch to Connection Slave 2146CREATE TABLE t1(id VARCHAR(20) NOT NULL, PRIMARY KEY(id)); 2147INSERT INTO t1 VALUES ('text1'),('text2'),('text3'),('text4'); 2148#Switch to Connection Master 2149CREATE TABLE t1(id VARCHAR(20) NOT NULL, PRIMARY KEY(id)) ENGINE=FEDERATED 2150CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2151# Dump table t1 using mysqldump tool 2152/*!40101 SET @saved_cs_client = @@character_set_client */; 2153/*!40101 SET character_set_client = utf8 */; 2154CREATE TABLE `t1` ( 2155 `id` varchar(20) NOT NULL, 2156 PRIMARY KEY (`id`) 2157) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/test/t1'; 2158/*!40101 SET character_set_client = @saved_cs_client */; 2159DROP TABLE t1; 2160#Switch to Connection Slave 2161DROP TABLE t1; 2162End of 5.0 tests 2163create server 's1' foreign data wrapper 'mysql' options (port 3306); 2164drop server 's1'; 2165# 2166# Bug #32426: FEDERATED query returns corrupt results for ORDER BY on a TEXT 2167# 2168CREATE TABLE federated.t1(a TEXT); 2169INSERT INTO federated.t1 VALUES('abc'), ('gh'), ('f'), ('ijk'), ('de'); 2170CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED 2171CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; 2172SELECT * FROM federated.t1 ORDER BY A; 2173a 2174abc 2175de 2176f 2177gh 2178ijk 2179SELECT * FROM federated.t1 ORDER BY A DESC; 2180a 2181ijk 2182gh 2183f 2184de 2185abc 2186DROP TABLE federated.t1; 2187DROP TABLE federated.t1; 2188End of 5.1 tests 2189# 2190# BUG#11751864 - FEDERATED DOESN'T DISTINGUISH BETWEEN DELETE FROM 2191# T1 AND TRUNCATE T1 NOT NULL NOT SPECIFIED 2192# BUG#17564775 - FEDERATED DOES NOT SUPPORT DELETE IGNORE 2193connection master; 2194CREATE TABLE federated.t1 (a INT PRIMARY KEY, b varchar(64)) ENGINE=InnoDB; 2195connection slave; 2196CREATE TABLE federated.t2 (a INT PRIMARY KEY, b varchar(64)) 2197ENGINE=FEDERATED 2198connection='mysql://root@127.0.0.1:MASTER_PORT/federated/t1' 2199 DEFAULT CHARSET=utf8; 2200connection master; 2201INSERT INTO federated.t1 VALUES (1,"Larry"), (2,"Curly"), (3,"Moe"); 2202CREATE TABLE federated.t1_child(a int); 2203ALTER TABLE federated.t1_child ADD CONSTRAINT dc FOREIGN KEY (a) REFERENCES federated.t1(a); 2204INSERT INTO federated.t1_child VALUES (1), (3); 2205connection slave; 2206SELECT * FROM federated.t2; 2207a b 22081 Larry 22092 Curly 22103 Moe 2211#We will use the error message returned from server to differentiate between DELETE and TRUNCATE 2212DELETE FROM federated.t2; 2213ERROR HY000: Got error 10000 'Error on remote system: 1451: Cannot delete or update a parent row: a foreign key constraint fails (' from FEDERATED 2214TRUNCATE TABLE federated.t2; 2215ERROR HY000: Got error 10000 'Error on remote system: 1701: Cannot truncate a table referenced in a foreign key constraint (`feder' from FEDERATED 2216SELECT * FROM federated.t2; 2217a b 22181 Larry 22192 Curly 22203 Moe 2221DELETE IGNORE FROM federated.t2; 2222SELECT * FROM federated.t2; 2223a b 22241 Larry 22253 Moe 2226DELETE IGNORE FROM federated.t2 where a>1; 2227SELECT * FROM federated.t2; 2228a b 22291 Larry 22303 Moe 2231INSERT INTO federated.t2 VALUES (2,"Curly"),(6,"James"); 2232SELECT * FROM federated.t2; 2233a b 22341 Larry 22352 Curly 22363 Moe 22376 James 2238DELETE IGNORE federated.t2.* FROM federated.t2 where federated.t2.a<5; 2239SELECT * FROM federated.t2; 2240a b 22411 Larry 22423 Moe 22436 James 2244DROP TABLE federated.t2; 2245connection master; 2246DROP TABLE federated.t1_child; 2247DROP TABLE federated.t1; 2248### 2249### Bug#27509959: EXCEPTION NOT CAUGHT W/IN SPROC ADDING A ROW 2250### THAT FAILS FK CHECK IN FED TABLE 2251### 2252CREATE TABLE federated.parent(a INT, PRIMARY KEY(a)) ENGINE=InnoDB; 2253CREATE TABLE federated.child(a INT, b INT, PRIMARY KEY(b),FOREIGN KEY(a) REFERENCES federated.parent(a))ENGINE=InnoDB; 2254INSERT federated.parent VALUES (1); 2255INSERT federated.child VALUES (1,1); 2256CREATE TABLE federated.child(a INT, b INT, PRIMARY KEY(b), 2257FOREIGN KEY(a) REFERENCES federated.parent(a)) 2258ENGINE=FEDERATED 2259CONNECTION='mysql://root@127.0.0.1:MASTER_PORT/federated/child'; 2260SELECT * FROM federated.child; 2261a b 22621 1 2263DROP PROCEDURE IF EXISTS add_child; 2264Warnings: 2265Note 1305 PROCEDURE test.add_child does not exist 2266CREATE PROCEDURE add_child(IN new_a INT, IN new_b INT) 2267DETERMINISTIC MODIFIES SQL DATA 2268BEGIN 2269DECLARE CONTINUE HANDLER FOR SQLEXCEPTION 2270BEGIN 2271GET DIAGNOSTICS @p1 = NUMBER, @p2 = ROW_COUNT; 2272GET DIAGNOSTICS CONDITION 1 @p3=CLASS_ORIGIN, @p4=SUBCLASS_ORIGIN, @p5=RETURNED_SQLSTATE, @p6=MESSAGE_TEXT, @p7=MYSQL_ERRNO; 2273SELECT 2274@p1 as 'NUMBER' 2275 , @p2 as 'ROW_COUNT' 2276 , @p3 as 'CLASS_ORIGIN' 2277 , @p4 as 'SUBCLASS_ORIGIN' 2278 , @p5 as 'RETURNED_SQLSTATE' 2279 , @p6 as 'MESSAGE_TEXT' 2280 , @p7 as 'MYSQL_ERRNO'; 2281END; 2282INSERT federated.child(a, b) VALUES(new_a, new_b); 2283END| 2284CALL add_child(2,2); 2285NUMBER ROW_COUNT CLASS_ORIGIN SUBCLASS_ORIGIN RETURNED_SQLSTATE MESSAGE_TEXT MYSQL_ERRNO 22861 -1 ISO 9075 ISO 9075 23000 Cannot add or update a child row: a foreign key constraint fails () 1452 2287CALL add_child(1,1); 2288NUMBER ROW_COUNT CLASS_ORIGIN SUBCLASS_ORIGIN RETURNED_SQLSTATE MESSAGE_TEXT MYSQL_ERRNO 22891 -1 ISO 9075 ISO 9075 23000 Can't write; duplicate key in table 'child' 1022 2290DROP TABLE federated.child; 2291DROP PROCEDURE add_child; 2292DROP TABLE federated.child; 2293DROP TABLE federated.parent; 2294SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT; 2295SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT; 2296DROP TABLE IF EXISTS federated.t1; 2297DROP DATABASE federated; 2298DROP TABLE IF EXISTS federated.t1; 2299DROP DATABASE federated; 2300