Hi!
percona 5.7.17-13 (check CentOS, Ubuntu on default config) crash on UPDATE ON DUPLICATE KEY percona 5.6 All ok
How to reproduce: <---Structure DB-----> create database buk;
use buk;
CREATE TABLE tablica_s_govnom ( pri1 int(11) UNSIGNED NOT NULL, DT datetime DEFAULT NULL, dop1 text DEFAULT NULL , PRIMARY KEY (pri1), INDEX UK_tablica_s_govnom (DT) ) ENGINE = INNODB AVG_ROW_LENGTH = 16384 CHARACTER SET utf8 COLLATE utf8_general_ci ROW_FORMAT = DYNAMIC;
INSERT INTO tablica_s_govnom(pri1,DT,dop1) VALUES(1,NOW(),'2222'); DELIMITER // CREATE PROCEDURE Sucks_test() BEGIN DECLARE pri1,pri3 int; DECLARE pri2,comment VARCHAR(255); DECLARE dop1_1,dop2,dop3 VARCHAR(255) DEFAULT '222';
set pri1=1,pri2='1',pri3=1,comment='123';
INSERT INTO tablica_s_govnom(pri1, DT, dop1) VALUES(pri1, NOW() ,dop1_1) ON DUPLICATE KEY UPDATE DT=NOW(), dop1=VALUES(dop1); END//
</---Structure DB----->
<---test----> use buk;
CALL Sucks_test(); CALL Sucks_test();
</---test---->
run test in loop wait 5-10sec and mysql DIE with "mysqld got signal 11 ;"
Hi!
percona 5.7.17-13 (check CentOS, Ubuntu on default config) crash on UPDATE ON DUPLICATE KEY
percona 5.6 All ok
How to reproduce:
<---Structure DB----->
create database buk;
use buk;
CREATE TABLE tablica_s_govnom (
pri1 int(11) UNSIGNED NOT NULL,
DT datetime DEFAULT NULL,
dop1 text DEFAULT NULL ,
PRIMARY KEY (pri1),
INDEX UK_tablica_s_govnom (DT)
)
ENGINE = INNODB
AVG_ROW_LENGTH = 16384
CHARACTER SET utf8
COLLATE utf8_general_ci
ROW_FORMAT = DYNAMIC;
INSERT INTO tablica_ s_govnom( pri1,DT, dop1) VALUES( 1,NOW() ,'2222' );
DELIMITER //
CREATE PROCEDURE Sucks_test()
BEGIN
DECLARE pri1,pri3 int;
DECLARE pri2,comment VARCHAR(255);
DECLARE dop1_1,dop2,dop3 VARCHAR(255) DEFAULT '222';
set pri1=1, pri2='1' ,pri3=1, comment= '123';
INSERT INTO tablica_ s_govnom( pri1, DT, dop1)
VALUES(pri1, NOW() ,dop1_1)
ON DUPLICATE KEY UPDATE DT=NOW(), dop1=VALUES(dop1);
END//
</---Structure DB----->
<---test---->
use buk;
CALL Sucks_test();
CALL Sucks_test();
</---test---->
run test in loop wait 5-10sec and mysql DIE with "mysqld got signal 11 ;"