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 ** Connecting con_int1 using 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 ** Connecting con_int2 using 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 Disconnecting Connections con_int1, con_int2
82 ** Cleanup **
83 SET @@sql_buffer_result = @original_sql_buffer_result;
84 DROP TABLE t1;