From a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 Mon Sep 17 00:00:00 2001 From: Michael Widenius Date: Fri, 9 Mar 2018 14:05:35 +0200 Subject: Create 'main' test directory and move 't' and 'r' there --- mysql-test/main/default_debug.test | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 mysql-test/main/default_debug.test (limited to 'mysql-test/main/default_debug.test') diff --git a/mysql-test/main/default_debug.test b/mysql-test/main/default_debug.test new file mode 100644 index 00000000000..cdde26569ca --- /dev/null +++ b/mysql-test/main/default_debug.test @@ -0,0 +1,22 @@ +# +# Race condition in DEFAULT() with expressions +# + +source include/have_debug_sync.inc; + +create table t1 (a int, b int default (a+1)); +insert t1 values (1,10), (2,20), (3,30); +connect (con1, localhost, root); +select a,b,default(b) from t1; +set debug_sync='after_Item_default_value_calculate WAIT_FOR go'; +send select a,b,default(b) from t1; +connection default; +let $wait_condition=select count(*) from information_schema.processlist where state like 'debug sync%'; +source include/wait_condition.inc; +set debug_sync='ha_write_row_start SIGNAL go'; +insert t1 values (100,default(b)); +connection con1; +reap; +connection default; +drop table t1; +set debug_sync='RESET'; -- cgit v1.2.1