# RQG grammar (bug.yy): query: handler_open_close | handler_read ; thread1: UPDATE IGNORE _table SET _field = value where ; thread2: ALTER TABLE _table ADD COLUMN filler VARCHAR(255) DEFAULT ' filler ' | ALTER TABLE _table DROP COLUMN filler ; handler_open_close: HANDLER alias1 CLOSE ; HANDLER _table OPEN AS alias1 ; handler_read: HANDLER alias1 READ `PRIMARY` index_op where ; comp_op: = | <= | >= | < | > ; index_op: FIRST | NEXT | PREV | LAST ; value: _digit | _tinyint_unsigned | _varchar(1) ; where: | WHERE _field comp_op value ; # End of RQG grammar ######################### # RQG data template (bug.zz): $tables = { rows => [1000], engines => [ 'InnoDB' ] }; $fields = { types => [ 'int', 'char(32)' ], indexes => [ 'key', 'unique' ], null => [undef, 'not null'], }; $data = { numbers => [ 'digit', 'null', undef , 'tinyint_unsigned' ], strings => [ 'letter', 'english', 'varchar(3)' ] } # End of RQG data template ############################## RQG command line: perl runall.pl --grammar=bug.yy --gendata=bug.zz --basedir=mysql-5.6 --queries=100K --duration=600 --threads=3 --mysqld=--innodb-lock-wait-timeout=1 --mysqld=--lock-wait-timeout=1 # It fails within a minute after start for me, # but if it doesn't for you, try to increase the number of threads