1** Setup ** 2 3SET @original_sql_buffer_result = @@sql_buffer_result; 4CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20)); 5INSERT INTO t1 VALUES('aa','bb'); 6INSERT INTO t1 VALUES('aa','bb'); 7INSERT INTO t1 VALUES('aa','bb'); 8INSERT INTO t1 VALUES('aa','bb'); 9INSERT INTO t1 VALUES('aa','bb'); 10'#--------------------FN_DYNVARS_156_01-------------------------#' 11SET SESSION sql_buffer_result = 1; 12SHOW STATUS LIKE 'Created_tmp_tables'; 13Variable_name Value 14Created_tmp_tables 0 15Expected value : 0. 16SELECT * FROM t1; 17a b 18aa bb 19aa bb 20aa bb 21aa bb 22aa bb 23SHOW STATUS LIKE 'Created_tmp_tables'; 24Variable_name Value 25Created_tmp_tables 1 26Expected value : 1. 27SELECT * FROM t1; 28a b 29aa bb 30aa bb 31aa bb 32aa bb 33aa bb 34SHOW STATUS LIKE 'Created_tmp_tables'; 35Variable_name Value 36Created_tmp_tables 2 37Expected value : 2. 38'#--------------------FN_DYNVARS_156_02-------------------------#' 39SET SESSION sql_buffer_result = 0; 40SHOW STATUS LIKE 'Created_tmp_tables'; 41Variable_name Value 42Created_tmp_tables 2 43Expected value : 2. 44SELECT * FROM t1; 45a b 46aa bb 47aa bb 48aa bb 49aa bb 50aa bb 51SHOW STATUS LIKE 'Created_tmp_tables'; 52Variable_name Value 53Created_tmp_tables 2 54Expected value : 2. 55'#--------------------FN_DYNVARS_156_03-------------------------#' 56connect con_int1,localhost,root,,; 57connection con_int1; 58SELECT @@SESSION.sql_buffer_result; 59@@SESSION.sql_buffer_result 600 610 / FALSE Expected 62SET SESSION sql_buffer_result = FALSE; 63connect con_int2,localhost,root,,; 64connection con_int2; 65SELECT @@SESSION.sql_buffer_result; 66@@SESSION.sql_buffer_result 670 680 / FALSE Expected 69SET SESSION sql_buffer_result = TRUE; 70connection con_int1; 71SELECT @@SESSION.sql_buffer_result; 72@@SESSION.sql_buffer_result 730 740 / FALSE Expected 75connection con_int2; 76SELECT @@SESSION.sql_buffer_result; 77@@SESSION.sql_buffer_result 781 791 / TRUE Expected 80connection default; 81disconnect con_int1; 82disconnect con_int2; 83** Cleanup ** 84SET @@sql_buffer_result = @original_sql_buffer_result; 85DROP TABLE t1; 86