Debian Codegraph @

mysql-test/suite/innodb/t/innodb_buffer_pool_shrink_temporary.test

raw
1 --source include/have_innodb.inc
2 call mtr.add_suppression("innodb_buffer_pool_size change aborted");
3 SET @b=REPEAT('0',1048576);
4 CREATE TEMPORARY TABLE t (c MEDIUMTEXT) ENGINE=InnoDB;
5 INSERT INTO t VALUES
6 (@b),(@b),(@b),(@b),(@b),(@b),(@b),(@b),(@b),(@b),(@b);
7 --error 0,ER_WRONG_USAGE
8 SET STATEMENT max_statement_time=0.000001 FOR
9 SET GLOBAL innodb_buffer_pool_size=6291456;
10 --error 0,ER_WRONG_USAGE
11 SET STATEMENT max_statement_time=0.000001 FOR
12 SET GLOBAL innodb_buffer_pool_size=6291456;
13 --error 0,ER_WRONG_USAGE
14 SET STATEMENT max_statement_time=0.000001 FOR
15 SET GLOBAL innodb_buffer_pool_size=6291456;
16 --error 0,ER_WRONG_USAGE
17 SET GLOBAL innodb_buffer_pool_size=6291456;
18 SET GLOBAL innodb_buffer_pool_size=16777216;
19 CHECKSUM TABLE t;
20 DROP TEMPORARY TABLE t;