Debian Codegraph @

mysql-test/suite/maria/insert_select-7314.result

raw
1 drop table if exists t1;
2 Warnings:
3 Note 1051 Unknown table 'test.t1'
4 #
5 # MDEV-7314
6 # Concurrent "INSERT INTO table SELECT MAX(id)+1 FROM table" are
7 # hitting deadlocks on Aria tables using ROW_FORMAT=PAGE
8 #
9 create table t1 (pk int primary key) engine=Aria;
10 insert into t1 values (1);
11 insert into t1 select sleep(2)+1 from t1;
12 connect con1,localhost,root,,;
13 insert into t1 select 2 from t1;
14 connection default;
15 select * from t1;
16 pk
17 1
18 2
19 drop table t1;