mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
10 lines
383 B
Text
10 lines
383 B
Text
START TRANSACTION WITH CONSISTENT SNAPSHOT;
|
|
connect con1,localhost,root,,test;
|
|
CREATE TABLE IF NOT EXISTS t1 (pk INT PRIMARY KEY, i INT, KEY(i)) ENGINE=InnoDB;
|
|
connection default;
|
|
UPDATE t1 SET i = 0;
|
|
ERROR HY000: Table definition has changed, please retry transaction
|
|
UPDATE t1 SET pk = 0;
|
|
ERROR HY000: Table definition has changed, please retry transaction
|
|
commit;
|
|
drop table t1;
|