summaryrefslogtreecommitdiff
path: root/storage/spider/mysql-test/spider/t/variable_deprecation.test
blob: 8521f5595d172c72084b7e2ebb511b9207e367b9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
--echo #
--echo # MDEV-27228 Deprecate Spider plugin variables that result in excessive tweak
--echo #

--disable_query_log
--disable_result_log
--source test_init.inc
--enable_result_log
--enable_query_log

--connection master_1
CREATE DATABASE auto_test_local;
USE auto_test_local;

--echo # MDEV-27923 Deprecate spider_use_handler
SET spider_use_handler = 3;
SHOW VARIABLES LIKE "spider_use_handler";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='uhd "3"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='use_handler "3"';

DROP TABLE tbl_a;
DROP TABLE tbl_b;

--echo # MDEV-28005 Deprecate Spider plugin variables regarding UDFs
SET GLOBAL spider_udf_ds_bulk_insert_rows = 1;
SHOW VARIABLES LIKE "spider_udf_ds_bulk_insert_rows";

SET spider_udf_ds_table_loop_mode = 1;
SHOW VARIABLES LIKE "spider_udf_ds_table_loop_mode";

SET spider_udf_ds_use_real_table = 1;
SHOW VARIABLES LIKE "spider_udf_ds_use_real_table";

SET GLOBAL spider_udf_ct_bulk_insert_interval = 1;
SHOW VARIABLES LIKE "spider_udf_ct_bulk_insert_interval";

SET GLOBAL spider_udf_ct_bulk_insert_rows = 1;
SHOW VARIABLES LIKE "spider_udf_ct_bulk_insert_rows";

--echo # MDEV-27981 Deprecate spider_internal_limit 
SET spider_internal_limit = 1;
SHOW VARIABLES LIKE "spider_internal_limit";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='ilm "1"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='internal_limit "1"';

DROP TABLE tbl_a;
DROP TABLE tbl_b;

DROP DATABASE auto_test_local;

--disable_query_log
--disable_result_log
--source test_deinit.inc
--enable_result_log
--enable_query_log