# # The purpose of this test is to exercise anything related to table locking: # # DDL, DML # # query: ddl | dml ; ddl: ALTER online TABLE table1_int_autoinc ENGINE = engine ; # ALTER online TABLE _table COMMENT = 'BLUB' ; lets the deadlock and the # error messages about non supported ONLINE disappear online: ONLINE | ; # Attention: ONLINE | is necessary for the deadlock. dml: select | update ; select: SELECT A . _field FROM table1_int_autoinc AS A LEFT JOIN table1_int_autoinc AS B USING (`pk`) FOR UPDATE ; # The "FOR UPDATE" and the JOIN seems to be needed for the deadlock. # Please note that I also get the deadlock if the JOIN is between # two different tables. update: UPDATE table1_int_autoinc SET `int` = _digit WHERE `pk` > _digit; engine: MEMORY | InnoDB ; # MEMORY | MyISAM ; or only MEMORY is harmless