summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/innodb/r/compression_providers_unloaded.result
blob: d4ac9cdb41ca03b1464709543bfb718a4953bf7b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
#
# Testing unloaded compression provider: bzip2
#
# Innodb_have_bzip2 reflects that the provider is not loaded
SHOW GLOBAL STATUS WHERE Variable_name = "Innodb_have_bzip2";
Variable_name	Value
Innodb_have_bzip2	OFF
# Innodb_compression_algorithm cannot be set to bzip2
SET GLOBAL Innodb_compression_algorithm = bzip2;
ERROR 42000: Variable 'innodb_compression_algorithm' can't be set to the value of 'bzip2'
show warnings;
Level	Code	Message
Warning	138	InnoDB: compression algorithm bzip2 (5) is not available. Please, load the corresponding provider plugin.
Error	1231	Variable 'innodb_compression_algorithm' can't be set to the value of 'bzip2'