summaryrefslogtreecommitdiff
path: root/mysql-test/r/temp_table_frm.result
blob: 19c66380af2615da96f50046ba10921fa966dfd1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
set @@session.max_heap_table_size=16*1024*1024;
create table t1 select * from information_schema.session_status where variable_name like 'Opened%';
create temporary table t2 (a int) engine=memory;
select variable_name, session_status.variable_value - t1.variable_value
from information_schema.session_status join t1 using (variable_name);
variable_name	session_status.variable_value - t1.variable_value
OPENED_FILES	0
OPENED_PLUGIN_LIBRARIES	0
OPENED_TABLE_DEFINITIONS	2
OPENED_TABLES	1
OPENED_VIEWS	0
truncate table t2;
select variable_name, session_status.variable_value - t1.variable_value
from information_schema.session_status join t1 using (variable_name);
variable_name	session_status.variable_value - t1.variable_value
OPENED_FILES	0
OPENED_PLUGIN_LIBRARIES	0
OPENED_TABLE_DEFINITIONS	2
OPENED_TABLES	1
OPENED_VIEWS	0
drop table t1;