August 24, 2012

[MySQL Bug]bug#66301(Percona Bug#1035225)简析

转载请署名:印风 ——————————— 先跑test case 1.创建测试表 CREATE TABLE t(        id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,        k INT,        c CHAR(1),        UNIQUE KEY(k)) ENGINE=InnoDB; 2.当顺序执行如下SQL时 SQL1–INSERT INTO t(k) VALUES (1), (2), (3) ON DUPLICATE KEY UPDATE c=’1′; SQL2–INSERT INTO t(k) VALUES (2), (4), (5) ON […]