1SET @global_start_value = @@global.innodb_concurrency_tickets; 2SELECT @global_start_value; 3@global_start_value 45000 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_concurrency_tickets = 0; 7Warnings: 8Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '0' 9SET @@global.innodb_concurrency_tickets = DEFAULT; 10SELECT @@global.innodb_concurrency_tickets; 11@@global.innodb_concurrency_tickets 125000 13'#---------------------FN_DYNVARS_046_02-------------------------#' 14SET innodb_concurrency_tickets = 1; 15ERROR HY000: Variable 'innodb_concurrency_tickets' is a GLOBAL variable and should be set with SET GLOBAL 16SELECT @@innodb_concurrency_tickets; 17@@innodb_concurrency_tickets 185000 19SELECT local.innodb_concurrency_tickets; 20ERROR 42S02: Unknown table 'local' in field list 21SET global innodb_concurrency_tickets = 0; 22Warnings: 23Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '0' 24SELECT @@global.innodb_concurrency_tickets; 25@@global.innodb_concurrency_tickets 261 27'#--------------------FN_DYNVARS_046_03------------------------#' 28SET @@global.innodb_concurrency_tickets = 1; 29SELECT @@global.innodb_concurrency_tickets; 30@@global.innodb_concurrency_tickets 311 32SET @@global.innodb_concurrency_tickets = 1000; 33SELECT @@global.innodb_concurrency_tickets; 34@@global.innodb_concurrency_tickets 351000 36SET @@global.innodb_concurrency_tickets = 4294967295; 37SELECT @@global.innodb_concurrency_tickets; 38@@global.innodb_concurrency_tickets 394294967295 40'#--------------------FN_DYNVARS_046_04-------------------------#' 41SET @@global.innodb_concurrency_tickets = 4294967296; 42SELECT @@global.innodb_concurrency_tickets IN (4294967296,4294967295); 43@@global.innodb_concurrency_tickets IN (4294967296,4294967295) 441 45SET @@global.innodb_concurrency_tickets = 12345678901; 46SELECT @@global.innodb_concurrency_tickets IN (12345678901,4294967295); 47@@global.innodb_concurrency_tickets IN (12345678901,4294967295) 481 49SET @@global.innodb_concurrency_tickets = 18446744073709551615; 50SELECT @@global.innodb_concurrency_tickets IN (18446744073709551615,4294967295); 51@@global.innodb_concurrency_tickets IN (18446744073709551615,4294967295) 521 53'#--------------------FN_DYNVARS_046_05-------------------------#' 54SET @@global.innodb_concurrency_tickets = -1; 55Warnings: 56Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '-1' 57SELECT @@global.innodb_concurrency_tickets; 58@@global.innodb_concurrency_tickets 591 60SET @@global.innodb_concurrency_tickets = -1024; 61Warnings: 62Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '-1024' 63SELECT @@global.innodb_concurrency_tickets; 64@@global.innodb_concurrency_tickets 651 66SET @@global.innodb_concurrency_tickets = "T"; 67ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets' 68SELECT @@global.innodb_concurrency_tickets; 69@@global.innodb_concurrency_tickets 701 71SET @@global.innodb_concurrency_tickets = "Y"; 72ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets' 73SELECT @@global.innodb_concurrency_tickets; 74@@global.innodb_concurrency_tickets 751 76SET @@global.innodb_concurrency_tickets = 1.1; 77ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets' 78SELECT @@global.innodb_concurrency_tickets; 79@@global.innodb_concurrency_tickets 801 81SET @@global.innodb_concurrency_tickets = " "; 82ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets' 83SELECT @@global.innodb_concurrency_tickets; 84@@global.innodb_concurrency_tickets 851 86SET @@global.innodb_concurrency_tickets = ' '; 87ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets' 88SELECT @@global.innodb_concurrency_tickets; 89@@global.innodb_concurrency_tickets 901 91'#----------------------FN_DYNVARS_046_06------------------------#' 92SELECT @@global.innodb_concurrency_tickets = 93VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 94WHERE VARIABLE_NAME='innodb_concurrency_tickets'; 95@@global.innodb_concurrency_tickets = 96VARIABLE_VALUE 971 98SELECT @@global.innodb_concurrency_tickets; 99@@global.innodb_concurrency_tickets 1001 101SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 102WHERE VARIABLE_NAME='innodb_concurrency_tickets'; 103VARIABLE_VALUE 1041 105'#---------------------FN_DYNVARS_046_07-------------------------#' 106SET @@global.innodb_concurrency_tickets = OFF; 107ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets' 108SELECT @@global.innodb_concurrency_tickets; 109@@global.innodb_concurrency_tickets 1101 111SET @@global.innodb_concurrency_tickets = ON; 112ERROR 42000: Incorrect argument type to variable 'innodb_concurrency_tickets' 113SELECT @@global.innodb_concurrency_tickets; 114@@global.innodb_concurrency_tickets 1151 116'#---------------------FN_DYNVARS_046_08----------------------#' 117SET @@global.innodb_concurrency_tickets = TRUE; 118SELECT @@global.innodb_concurrency_tickets; 119@@global.innodb_concurrency_tickets 1201 121SET @@global.innodb_concurrency_tickets = FALSE; 122Warnings: 123Warning 1292 Truncated incorrect innodb_concurrency_tickets value: '0' 124SELECT @@global.innodb_concurrency_tickets; 125@@global.innodb_concurrency_tickets 1261 127SET @@global.innodb_concurrency_tickets = @global_start_value; 128SELECT @@global.innodb_concurrency_tickets; 129@@global.innodb_concurrency_tickets 1305000 131