1
-- source include/have_innodb_plugin.inc
3
#display current value of innodb_use_sys_malloc
4
SELECT @@GLOBAL.innodb_use_sys_malloc;
7
#try changing it. Should fail.
8
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
9
SET @@GLOBAL.innodb_use_sys_malloc=0;
10
--echo Expected error 'Read only variable'
12
SELECT @@GLOBAL.innodb_use_sys_malloc;
16
#do some stuff to see if it works.
18
drop table if exists t1;
21
create table t1(a int not null) engine=innodb DEFAULT CHARSET=latin1;
22
insert into t1 values (1),(2),(3),(4),(5),(6),(7);
25
-- source include/have_innodb_plugin.inc
27
#display current value of innodb_use_sys_malloc
28
SELECT @@GLOBAL.innodb_use_sys_malloc;
31
#try changing it. Should fail.
32
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
33
SET @@GLOBAL.innodb_use_sys_malloc=0;
34
--echo Expected error 'Read only variable'
36
SELECT @@GLOBAL.innodb_use_sys_malloc;
40
#do some stuff to see if it works.
42
drop table if exists t1;
45
create table t1(a int not null) engine=innodb DEFAULT CHARSET=latin1;
46
insert into t1 values (1),(2),(3),(4),(5),(6),(7);