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