SET storage_engine=InnoDB; INSERT INTO bug38231 VALUES (1), (10), (300); SET autocommit=0; SELECT * FROM bug38231 FOR UPDATE; a 1 10 300 TRUNCATE TABLE bug38231; COMMIT; DROP TABLE bug38231;