1set @saved_slave_rows_search_algorithms = @@global.slave_rows_search_algorithms; 2SELECT @@global.slave_rows_search_algorithms; 3@@global.slave_rows_search_algorithms 4TABLE_SCAN,INDEX_SCAN 5SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS=DEFAULT; 6SELECT @@global.slave_rows_search_algorithms; 7@@global.slave_rows_search_algorithms 8TABLE_SCAN,INDEX_SCAN 9SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN'; 10SELECT @@global.slave_rows_search_algorithms; 11@@global.slave_rows_search_algorithms 12TABLE_SCAN 13SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='HASH_SCAN'; 14SELECT @@global.slave_rows_search_algorithms; 15@@global.slave_rows_search_algorithms 16HASH_SCAN 17SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='INDEX_SCAN'; 18SELECT @@global.slave_rows_search_algorithms; 19@@global.slave_rows_search_algorithms 20INDEX_SCAN 21SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN,HASH_SCAN'; 22SELECT @@global.slave_rows_search_algorithms; 23@@global.slave_rows_search_algorithms 24TABLE_SCAN,HASH_SCAN 25SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN,HASH_SCAN,INDEX_SCAN'; 26SELECT @@global.slave_rows_search_algorithms; 27@@global.slave_rows_search_algorithms 28TABLE_SCAN,INDEX_SCAN,HASH_SCAN 29SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_SCAN,INDEX_SCAN'; 30SELECT @@global.slave_rows_search_algorithms; 31@@global.slave_rows_search_algorithms 32TABLE_SCAN,INDEX_SCAN 33SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='HASH_SCAN,INDEX_SCAN'; 34SELECT @@global.slave_rows_search_algorithms; 35@@global.slave_rows_search_algorithms 36INDEX_SCAN,HASH_SCAN 37SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='TABLE_5CAN'; 38ERROR 42000: Variable 'slave_rows_search_algorithms' can't be set to the value of 'TABLE_5CAN' 39SELECT @@global.slave_rows_search_algorithms; 40@@global.slave_rows_search_algorithms 41INDEX_SCAN,HASH_SCAN 42SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS=''; 43ERROR 42000: Variable 'slave_rows_search_algorithms' can't be set to the value of '' 44SELECT @@global.slave_rows_search_algorithms; 45@@global.slave_rows_search_algorithms 46INDEX_SCAN,HASH_SCAN 47SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS='1'; 48ERROR 42000: Variable 'slave_rows_search_algorithms' can't be set to the value of '1' 49SELECT @@global.slave_rows_search_algorithms; 50@@global.slave_rows_search_algorithms 51INDEX_SCAN,HASH_SCAN 52SET GLOBAL SLAVE_ROWS_SEARCH_ALGORITHMS=NULL; 53ERROR 42000: Variable 'slave_rows_search_algorithms' can't be set to the value of 'NULL' 54SELECT @@global.slave_rows_search_algorithms; 55@@global.slave_rows_search_algorithms 56INDEX_SCAN,HASH_SCAN 57set global slave_rows_search_algorithms = @saved_slave_rows_search_algorithms; 58SELECT @@global.slave_rows_search_algorithms; 59@@global.slave_rows_search_algorithms 60TABLE_SCAN,INDEX_SCAN 61