以前使用percona
5.0系列版本,一直顺风顺水的,没碰到什么问题。最近尝试了一下5.5.10(以及5.5.12)版本,结果碰到bug了
:(
问题现象简述:
1. 有两个数据表
CREATE TABLE `t1` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `guid` bigint(20) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `charguid` bigint(20) unsigned NOT NULL DEFAULT '0', `charname` varchar(255) NOT NULL DEFAULT '', `level` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_charguid` (`charguid`), KEY `idx_guid` (`guid`) ) ENGINE=InnoDB; CREATE TABLE `t2` ( `aid` bigint(20) NOT NULL AUTO_INCREMENT, `guid` bigint(20) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `level` int(10) unsigned NOT NULL DEFAULT '0', `charguid` bigint(20) unsigned NOT NULL DEFAULT '0', `charname` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`aid`), KEY `idx_guid` (`guid`), KEY `idx_charguid` …[获取更多]