Debian Codegraph @

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

raw
1 source include/not_valgrind.inc;
2 source include/have_memcached_plugin.inc;
3 source include/not_windows.inc;
4
5 SET @transaction_isolation= @@global.transaction_isolation;
6 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
7
8 # Create the memcached tables
9 --disable_query_log
10 source include/memcache_config.inc;
11 --enable_query_log
12 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
13 "innodb_only", "innodb_only", "innodb_only");
14
15 INSERT INTO config_options VALUES("separator", "|");
16
17 # describe table for memcache
18 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
19 "c1", "c2", "c3", "c4", "c5", "PRIMARY");
20
21 USE test;
22
23 CREATE TABLE t1 (c1 VARCHAR(32),
24 c2 VARCHAR(1024),
25 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
26 ENGINE = INNODB;
27
28 --disable_warnings
29 # Tables must exist before plugin can be started!
30 --let $memcached_address=127.0.0.1:11259
31 --source ../include/load_daemon_memcached_expecting_success.inc
32 --enable_warnings
33 --echo # We expect a warning to be printed from INSTALL PLUGIN.
34 SHOW WARNINGS;
35
36 UNINSTALL PLUGIN daemon_memcached;
37
38 --source include/shutdown_mysqld.inc
39
40 --echo # We expect a warning in error log to NOT be printed.
41 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
42 let SEARCH_PATTERN='InnoDB Memcached Plugin' is deprecated;
43 --source include/search_pattern.inc
44
45 --let $restart_parameters=restart:--plugin-load="libmemcached.so" --daemon_memcached=OFF
46 --source include/start_mysqld.inc
47
48 --source include/shutdown_mysqld.inc
49
50 --echo # We expect a warning in error log to NOT be printed.
51 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
52 let SEARCH_PATTERN='InnoDB Memcached Plugin' is deprecated;
53 --source include/search_pattern.inc
54
55 --let $restart_parameters=restart:--plugin-load="libmemcached.so"
56 --source include/start_mysqld.inc
57
58 # Stop plugin before innodb_memcached configuration
59 UNINSTALL PLUGIN daemon_memcached;
60
61 --source include/shutdown_mysqld.inc
62
63 --echo # We expect a warning in error log to be printed.
64 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
65 let SEARCH_PATTERN='InnoDB Memcached Plugin' is deprecated;
66 --source include/search_pattern.inc
67
68 --let $restart_parameters=restart:
69 --source include/start_mysqld.inc
70
71 DROP TABLE t1;
72 DROP DATABASE innodb_memcache;
73