1# this test needs multithreaded mysqltest 2-- source include/not_embedded.inc 3 4# Test sleeps for long times 5--source include/big_test.inc 6 7# check that CSV engine was compiled in 8--source include/have_csv.inc 9 10set @log_output.saved = @@global.log_output; 11set @@global.log_output = 'TABLE'; 12 13connect (con1,localhost,root,,); 14connect (con2,localhost,root,,); 15 16# 17# Bug #27638: slow logging to CSV table inserts bad query_time and lock_time values 18# 19connection con1; 20set session long_query_time=10; 21select get_lock('bug27638', 1); 22connection con2; 23set session long_query_time=1; 24select get_lock('bug27638', 2); 25select if (query_time >= '00:00:01', 'OK', concat('WRONG: ',query_time)) as qt, sql_text from mysql.slow_log 26 where sql_text = 'select get_lock(\'bug27638\', 2)'; 27select get_lock('bug27638', 60); 28select if (query_time >= '00:00:59', 'OK', concat('WRONG: ',query_time)) as qt, sql_text from mysql.slow_log 29 where sql_text = 'select get_lock(\'bug27638\', 60)'; 30select get_lock('bug27638', 101); 31select if (query_time >= '00:01:40', 'OK', concat('WRONG: ',query_time)) as qt, sql_text from mysql.slow_log 32 where sql_text = 'select get_lock(\'bug27638\', 101)'; 33connection con1; 34select release_lock('bug27638'); 35connection default; 36 37disconnect con1; 38disconnect con2; 39 40set @@global.log_output = @log_output.saved; 41