Debian Codegraph @

mysql-test/suite/memcached/t/memc286_sdi_create.test

raw
1 # Bug#20205934 - ENABLE VALGRIND FOR MEMCACHED TESTS
2 source include/not_valgrind.inc;
3 source include/have_memcached_plugin.inc;
4 # Memcached SDI APIs are enabled only for debug version
5 source include/have_debug.inc;
6 # This test uses external $MYSQL client tool to create table
7 # with large number of columns(999) from a .sql file.
8
9 --disable_query_log
10 CALL mtr.add_suppression("daemon-memcached-w-batch-size': unsigned");
11 CALL mtr.add_suppression("Could not obtain server's UPN to be used as target service name");
12 CALL mtr.add_suppression("Warning: MySQL is trying to drop");
13 # Create the memcached tables
14 source include/memcache_config.inc;
15 --enable_query_log
16
17 INSERT INTO cache_policies VALUES('cache_policy', 'innodb_only',
18 'innodb_only', 'innodb_only', 'innodb_only');
19
20 INSERT INTO config_options VALUES('separator', '|');
21
22 # describe table for memcache
23 INSERT INTO containers VALUES ('desc_t1', 'test', 't1',
24 'c1', 'c2', '0', '0', '0', 'PRIMARY');
25 INSERT INTO containers VALUES ('desc_t2', 'test', 't2',
26 'c1', 'c2', '0', '0', '0', 'PRIMARY');
27 INSERT INTO containers VALUES ('desc_t3', 'test', 't3',
28 'c1', 'c2', '0', '0', '0', 'PRIMARY');
29 INSERT INTO containers VALUES ('desc_t4', 'test', 't4',
30 'c1', 'c2', '0', '0', '0', 'PRIMARY');
31 INSERT INTO containers VALUES ('desc_t5', 'test', 't5',
32 'c1', 'c2', '0', '0', '0', 'PRIMARY');
33 INSERT INTO containers VALUES ('desc_t6', 'test', 't6',
34 'c1', 'c2', '0', '0', '0', 'PRIMARY');
35 INSERT INTO containers VALUES ('desc_t7', 'test', 't7',
36 'c1', 'c2', '0', '0', '0', 'PRIMARY');
37 USE test;
38 let MEMCACHED_PORT=11286;
39
40 --let $memcached_address=127.0.0.1:11286
41
42 SET GLOBAL innodb_file_per_table=OFF;
43 --source ../include/sdi_create_alter.inc
44
45 SET GLOBAL innodb_file_per_table=ON;
46 --source ../include/sdi_create_alter.inc
47
48 --echo # Create compressed table
49 CREATE TABLE t6 (c1 INT PRIMARY KEY,
50 c2 VARCHAR(30),
51 c3 FLOAT,
52 KEY idx1(c3),
53 KEY idx2(c2(20)))
54 ENGINE = INNODB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
55
56 # Tables must exist before plugin can be started!
57 --source ../include/load_daemon_memcached_expecting_success.inc
58
59 let TABLE_NAME = t6;
60 let MEMCACHED_TABLE_MAPPING = desc_t6;
61 --source ../include/sdi_insert_get_row.inc
62 DROP TABLE t6;
63
64 --echo # Create SDI in General tablespace
65 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
66 CREATE TABLE t6 (c1 INT PRIMARY KEY,
67 c2 VARCHAR(30),
68 c3 FLOAT,
69 KEY idx1(c3),
70 KEY idx2(c2(20)))
71 ENGINE = INNODB TABLESPACE=ts1;
72
73 let TABLE_NAME = t6;
74 let MEMCACHED_TABLE_MAPPING = desc_t6;
75 --source ../include/sdi_insert_get_row.inc
76
77 DROP TABLE t6;
78 DROP TABLESPACE ts1;
79
80 DROP DATABASE innodb_memcache;
81 # Stop plugin before innodb_memcached configuration
82 UNINSTALL PLUGIN daemon_memcached;
83 SET GLOBAL innodb_file_per_table = default;