Debian Codegraph @

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

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