Latest PXC 5.5 version is not affected:
mysql> select @@version,@@version_comment; +----------------+-----------------------------------------------------------------------------------------------------+ | @@version | @@version_comment | +----------------+-----------------------------------------------------------------------------------------------------+ | 5.5.37-35.0-55 | Percona XtraDB Cluster (GPL), Release rel35.0, Revision 756, WSREP version 25.10, wsrep_25.10.r3985 | +----------------+-----------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
mysql> CREATE TABLE `r8kmb_redirect_links` ( -> `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -> `old_url` varchar(255) DEFAULT NULL, -> `new_url` varchar(255) NOT NULL, -> `referer` varchar(150) NOT NULL, -> `comment` varchar(255) NOT NULL, -> `published` tinyint(4) NOT NULL, -> `created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -> `modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -> PRIMARY KEY (`id`), -> UNIQUE KEY `idx_link_old` (`old_url`), -> KEY `idx_link_modifed` (`modified_date`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.35 sec)
mysql> INSERT INTO r8kmb_redirect_links VALUES (550,'http://mysite.com/images/download/ßуñûічýøù_ôþóþòір_þфõÑ.doc','','','',0,'2013-07-15 14:29:42','0000-00-00 00:00:00'); Query OK, 1 row affected (0.15 sec)
Latest PXC 5.5 version is not affected:
mysql> select @@version, @@version_ comment; ------- ---+--- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + ------- ---+--- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- + ------- ---+--- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- +
+------
| @@version | @@version_comment |
+------
| 5.5.37-35.0-55 | Percona XtraDB Cluster (GPL), Release rel35.0, Revision 756, WSREP version 25.10, wsrep_25.10.r3985 |
+------
1 row in set (0.00 sec)
mysql> CREATE TABLE `r8kmb_ redirect_ links` (
-> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-> `old_url` varchar(255) DEFAULT NULL,
-> `new_url` varchar(255) NOT NULL,
-> `referer` varchar(150) NOT NULL,
-> `comment` varchar(255) NOT NULL,
-> `published` tinyint(4) NOT NULL,
-> `created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
-> `modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
-> PRIMARY KEY (`id`),
-> UNIQUE KEY `idx_link_old` (`old_url`),
-> KEY `idx_link_modifed` (`modified_date`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.35 sec)
mysql> INSERT INTO r8kmb_redirect_ links VALUES (550,'http:// mysite. com/images/ download/ß ÑÆ ’à±Ã »Ã‘  œÃƒâ€˜Ã¢ €¡Ã ½Ã ¸Ã ¹_à´Ã ¾Ã ³Ã ¾Ã ²Ã‘  œÃƒâ€˜Ã¢ ‚¬_à¾Ã‘ „àµÃ‘ .doc',' ','','' ,0,'2013- 07-15 14:29:42' ,'0000- 00-00 00:00:00');
Query OK, 1 row affected (0.15 sec)