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