Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug30899683.result

raw
1 set global table_definition_cache=400;
2 set global table_open_cache= 1024;
3 use test;
4 SET SESSION innodb_strict_mode = OFF;
5 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="zlibX";
6 Warnings:
7 Warning 1112 InnoDB: Unsupported compression algorithm 'zlibX'
8 SHOW WARNINGS;
9 Level Code Message
10 Warning 1112 InnoDB: Unsupported compression algorithm 'zlibX'
11 SHOW CREATE TABLE t1;
12 Table Create Table
13 t1 CREATE TABLE `t1` (
14 `c1` int NOT NULL,
15 PRIMARY KEY (`c1`)
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMPRESSION='zlibX'
17 SELECT TABLE_NAME, CREATE_OPTIONS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
18 TABLE_NAME CREATE_OPTIONS
19 t1 COMPRESSION="zlibX"
20 SELECT NAME, ROW_FORMAT, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME = 'test/t1';
21 NAME ROW_FORMAT SPACE_TYPE
22 test/t1 Dynamic Single
23 INSERT INTO t1 VALUES(1);
24 commit;
25 use test;
26 SELECT * FROM t1;
27 c1
28 1
29 select sleep(10);
30 sleep(10)
31 0
32 # Flush tables, so that the table can be evicted by master thread.
33 flush tables;
34 # Create 1000 tables, try the best to evict the table.
35 sleep(20)
36 0
37 Warnings:
38 Warning 1525 Incorrect COMPRESSION value: 'zlibX'
39 Level Code Message
40 Warning 1525 Incorrect COMPRESSION value: 'zlibX'
41 set global table_definition_cache=default;
42 set global table_open_cache= default;