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; |