Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_semaphore_wait_timeout_debug_basic.result

raw
1 #
2 # Basic test for innodb_semaphore_wait_timeout_debug
3 #
4 SELECT @@global.innodb_semaphore_wait_timeout_debug;
5 @@global.innodb_semaphore_wait_timeout_debug
6 600
7 SET GLOBAL innodb_semaphore_wait_timeout_debug = 10;
8 Warnings:
9 Warning 1292 Truncated incorrect innodb_semaphore_wait_timeout_debug value: '10'
10 SELECT @@global.innodb_semaphore_wait_timeout_debug;
11 @@global.innodb_semaphore_wait_timeout_debug
12 25
13 SET GLOBAL innodb_semaphore_wait_timeout_debug = 200;
14 SELECT @@global.innodb_semaphore_wait_timeout_debug;
15 @@global.innodb_semaphore_wait_timeout_debug
16 200
17 SET GLOBAL innodb_semaphore_wait_timeout_debug = dummy;
18 ERROR 42000: Incorrect argument type to variable 'innodb_semaphore_wait_timeout_debug'
19 SET innodb_semaphore_wait_timeout_debug = 100;
20 ERROR HY000: Variable 'innodb_semaphore_wait_timeout_debug' is a GLOBAL variable and should be set with SET GLOBAL
21 SET GLOBAL innodb_semaphore_wait_timeout_debug = 6000;
22 Warnings:
23 Warning 1292 Truncated incorrect innodb_semaphore_wait_timeout_debug value: '6000'
24 SELECT @@global.innodb_semaphore_wait_timeout_debug;
25 @@global.innodb_semaphore_wait_timeout_debug
26 600
27 SET GLOBAL innodb_semaphore_wait_timeout_debug = -1;
28 Warnings:
29 Warning 1292 Truncated incorrect innodb_semaphore_wait_timeout_debug value: '-1'
30 SELECT @@global.innodb_semaphore_wait_timeout_debug;
31 @@global.innodb_semaphore_wait_timeout_debug
32 25
33 SET GLOBAL innodb_semaphore_wait_timeout_debug = default;
34 SELECT @@global.innodb_semaphore_wait_timeout_debug;
35 @@global.innodb_semaphore_wait_timeout_debug
36 600