# Bug#45067 Assertion `stmt_da->is_error()' in Delayed_insert::open_and_lock_table # # We use 'send' and 'reap' which is not supported by the embedded server. --source include/not_embedded.inc # # We do not protocoll anything because the test ends in case of failure with a # server crash. --disable_query_log --disable_result_log # Generate prerequisites SET SESSION SQL_MODE='NO_ENGINE_SUBSTITUTION'; SET SESSION AUTOCOMMIT=1; --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 (f1 BIGINT) ENGINE = MyISAM; COMMIT; connect (con_b,localhost,root,,test); # Two parallel sessions with # - INSERT DELAYED INTO t1 # and a DDL command for t1 let $num= 100; while ($num) { connection default; send; eval INSERT DELAYED INTO t1 (f1) VALUES ( $num ); connection con_b; send; eval ALTER TABLE t1 COMMENT = '$num'; # Statements like ANALYZE get the same effect like ALTER # eval ANALYZE TABLE t1; connection default; reap; connection con_b; reap; dec $num; } # Cleanup connection con_b; disconnect con_b; --source include/wait_until_disconnected.inc # include/wait_until_disconnected.inc enables the logging, switch it off --disable_query_log connection default; DROP TABLE t1; # MTR insists in some output. --echo Test does not hit Bug#45067 (server crash).