CREATE TABLE t1_p(c1 INT NOT NULL PRIMARY KEY, c2 INT) PARTITION BY RANGE COLUMNS (c1) (
   PARTITION p0 VALUES LESS THAN (10),
   PARTITION p1 VALUES LESS THAN (50),
   PARTITION p2 VALUES LESS THAN (MAXVALUE)
);
INSERT INTO t1_p VALUES(0, 0);
INSERT INTO t1_p VALUES(1, 1);
INSERT INTO t1_p VALUES(2, 2);
INSERT INTO t1_p VALUES(3, 3);
INSERT INTO t1_p VALUES(20, 20);
INSERT INTO t1_p VALUES(30, 30);

SET autocommit=OFF;
connect (con1,localhost,root);
--echo Connection: con1
connect (con2,localhost,root);
--echo Connection: con2

connection con1;
--echo Connection: con1
BEGIN;
SELECT * FROM t1_p WHERE c1<=1 FOR UPDATE;

connection con2;
--echo Connection: con2
BEGIN;
--error 1205
DELETE FROM t1_p WHERE c1=2;

connection con1;
ROLLBACK;

disconnect con1;
disconnect con2;