255 lines
8.9 KiB
Plaintext
255 lines
8.9 KiB
Plaintext
source include/not_valgrind.inc;
|
|
source include/have_memcached_plugin.inc;
|
|
source include/not_windows.inc;
|
|
|
|
call mtr.add_suppression("Cannot add field ");
|
|
|
|
--disable_query_log
|
|
CALL mtr.add_suppression("daemon-memcached-w-batch-size': unsigned");
|
|
CALL mtr.add_suppression("Could not obtain server's UPN to be used as target service name");
|
|
CALL mtr.add_suppression("Warning: MySQL is trying to drop");
|
|
--enable_query_log
|
|
|
|
--enable_connect_log
|
|
SET @transaction_isolation= @@global.transaction_isolation;
|
|
SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
|
|
|
|
# Create the memcached tables
|
|
--disable_query_log
|
|
source include/memcache_config.inc;
|
|
--enable_query_log
|
|
SET sql_mode='NO_ENGINE_SUBSTITUTION';
|
|
INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
|
|
"innodb_only", "innodb_only", "innodb_only");
|
|
|
|
INSERT INTO config_options VALUES("separator", ",");
|
|
|
|
# describe table for memcache
|
|
INSERT INTO containers VALUES ("desc_t1", "test", "t1",
|
|
"c1",
|
|
"c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
|
|
c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
|
|
c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
|
|
c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
|
|
c240,c241,c242,c243,c244,c245,c246,c247,c248,c249",
|
|
"c3", "c4", "c5", "PRIMARY");
|
|
|
|
# Container's value_columns is 255 bytes, above insertion would be truncated.
|
|
# The truncation left an invalid column name "c", which will be rejected
|
|
# by InnoDB memcached configuration
|
|
SELECT * FROM containers;
|
|
|
|
DELETE FROM containers;
|
|
|
|
# The 255 character limit of "value_columns" can hold columns up to "c230"
|
|
INSERT INTO containers VALUES ("desc_t1", "test", "t1",
|
|
"c1",
|
|
"c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
|
|
c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
|
|
c220,c221,c222,c223,c224,c225,c226,c227,c228,c229",
|
|
"c3", "c4", "c5", "PRIMARY");
|
|
|
|
USE test;
|
|
|
|
SET innodb_strict_mode=OFF;
|
|
--disable_warnings
|
|
CREATE TABLE t1 (c1 VARCHAR(32),
|
|
c200 VARCHAR(40),
|
|
c201 VARCHAR(40),
|
|
c202 VARCHAR(40),
|
|
c203 VARCHAR(40),
|
|
c204 VARCHAR(40),
|
|
c205 VARCHAR(40),
|
|
c206 VARCHAR(40),
|
|
c207 VARCHAR(40),
|
|
c208 VARCHAR(40),
|
|
c209 VARCHAR(40),
|
|
c210 VARCHAR(40),
|
|
c211 VARCHAR(40),
|
|
c212 VARCHAR(40),
|
|
c213 VARCHAR(40),
|
|
c214 VARCHAR(40),
|
|
c215 VARCHAR(40),
|
|
c216 VARCHAR(40),
|
|
c217 VARCHAR(40),
|
|
c218 VARCHAR(40),
|
|
c219 VARCHAR(40),
|
|
c220 VARCHAR(40),
|
|
c221 VARCHAR(40),
|
|
c222 VARCHAR(40),
|
|
c223 VARCHAR(40),
|
|
c224 VARCHAR(40),
|
|
c225 VARCHAR(40),
|
|
c226 VARCHAR(40),
|
|
c227 VARCHAR(40),
|
|
c228 VARCHAR(40),
|
|
c229 VARCHAR(40),
|
|
c230 VARCHAR(40),
|
|
c231 VARCHAR(40),
|
|
c232 VARCHAR(40),
|
|
c233 VARCHAR(40),
|
|
c234 VARCHAR(40),
|
|
c235 VARCHAR(40),
|
|
c236 VARCHAR(40),
|
|
c237 VARCHAR(40),
|
|
c238 VARCHAR(40),
|
|
c239 VARCHAR(40),
|
|
c240 VARCHAR(40),
|
|
c241 VARCHAR(40),
|
|
c242 VARCHAR(40),
|
|
c243 VARCHAR(40),
|
|
c244 VARCHAR(40),
|
|
c245 VARCHAR(40),
|
|
c246 VARCHAR(40),
|
|
c247 VARCHAR(40),
|
|
c248 VARCHAR(40),
|
|
c249 VARCHAR(40),
|
|
c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
|
|
ROW_FORMAT=COMPACT ENGINE = INNODB;
|
|
--enable_warnings
|
|
|
|
INSERT INTO t1 VALUES ('1',
|
|
'c200','c201','c202','c203','c204','c205','c206','c207','c208','c209',
|
|
'c210','c211','c212','c213','c214','c215','c216','c217','c218','c219',
|
|
'c220','c221','c222','c223','c224','c225','c226','c227','c228','c229',
|
|
'c230','c231','c232','c233','c234','c235','c236','c237','c238','c239',
|
|
'c240','c241','c242','c243','c244','c245','c246','c247','c248','c249',
|
|
0, 0, 0);
|
|
INSERT INTO t1 VALUES ('2',
|
|
'c200','c201','c202','c203','c204','c205','c206','c207','c208','c209',
|
|
'c210','c211','c212','c213','c214','c215','c216','c217','c218','c219',
|
|
'c220','c221','c222','c223','c224','c225','c226','c227','c228','c229',
|
|
'c230','c231','c232','c233','c234','c235','c236','c237','c238','c239',
|
|
'c240','c241','c242','c243','c244','c245','c246','c247','c248','c249',
|
|
0, 0, 0);
|
|
INSERT INTO t1 VALUES ('3',
|
|
'c200','c201','c202','c203','c204','c205','c206','c207','c208','c209',
|
|
'c210','c211','c212','c213','c214','c215','c216','c217','c218','c219',
|
|
'c220','c221','c222','c223','c224','c225','c226','c227','c228','c229',
|
|
'c230','c231','c232','c233','c234','c235','c236','c237','c238','c239',
|
|
'c240','c241','c242','c243','c244','c245','c246','c247','c248','c249',
|
|
0, 0, 0);
|
|
|
|
# Tables must exist before plugin can be started!
|
|
--let $memcached_address=127.0.0.1:11215
|
|
--source ../include/load_daemon_memcached_expecting_success.inc
|
|
|
|
--sorted_result
|
|
SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
|
|
c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
|
|
c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
|
|
c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
|
|
c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
|
|
FROM t1;
|
|
|
|
|
|
perl;
|
|
use DBI;
|
|
use Cache::Memcached;
|
|
my $memd = new Cache::Memcached {
|
|
'servers' => [ "127.0.0.1:11215" ],
|
|
'connect_timeout' => 20,
|
|
'select_timeout' => 20
|
|
};
|
|
print "Here are the memcached results:\n";
|
|
$val = $memd->get("1");
|
|
if ($val) { print "$val\n"; }
|
|
$val = $memd->get("2");
|
|
if ($val) { print "$val\n"; }
|
|
$val = $memd->get("3");
|
|
if ($val) { print "$val\n"; }
|
|
$memd->disconnect_all;
|
|
EOF
|
|
|
|
--sorted_result
|
|
SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
|
|
c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
|
|
c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
|
|
c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
|
|
c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
|
|
FROM t1;
|
|
|
|
perl;
|
|
use DBI;
|
|
use Cache::Memcached;
|
|
my $memd = new Cache::Memcached {
|
|
'servers' => [ "127.0.0.1:11215" ],
|
|
'connect_timeout' => 20,
|
|
'select_timeout' => 20
|
|
};
|
|
print "Here are the memcached results after set:\n";
|
|
$val = $memd->set("4","c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,c220,c221,c222,c223,c224,c225,c226,c227,c228,c229");
|
|
$val = $memd->get("4");
|
|
if ($val) { print "$val\n"; }
|
|
$memd->disconnect_all;
|
|
EOF
|
|
|
|
--sorted_result
|
|
SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
|
|
c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
|
|
c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
|
|
c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
|
|
c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
|
|
FROM t1;
|
|
|
|
perl;
|
|
use DBI;
|
|
use Cache::Memcached;
|
|
my $memd = new Cache::Memcached {
|
|
'servers' => [ "127.0.0.1:11215" ],
|
|
'connect_timeout' => 20,
|
|
'select_timeout' => 20
|
|
};
|
|
print "Here are the memcached results after set:\n";
|
|
$val = $memd->set("4","c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
|
|
c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
|
|
c220,c221,c222,c223,c224,c225,c226,c227,c228,c229"
|
|
);
|
|
$val = $memd->get("4");
|
|
if ($val) { print "$val\n"; }
|
|
$memd->disconnect_all;
|
|
EOF
|
|
|
|
--sorted_result
|
|
SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
|
|
c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
|
|
c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
|
|
c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
|
|
c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
|
|
FROM t1;
|
|
|
|
perl;
|
|
use DBI;
|
|
use Cache::Memcached;
|
|
my $memd = new Cache::Memcached {
|
|
'servers' => [ "127.0.0.1:11215" ],
|
|
'connect_timeout' => 20,
|
|
'select_timeout' => 20
|
|
};
|
|
print "Here are the memcached results after set:\n";
|
|
$val = $memd->set("4","c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
|
|
c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
|
|
c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
|
|
c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
|
|
c240,c241,c242,c243,c244,c245,c246,c247,c248,c249"
|
|
);
|
|
$val = $memd->get("4");
|
|
if ($val) { print "$val\n"; }
|
|
$memd->disconnect_all;
|
|
EOF
|
|
|
|
--sorted_result
|
|
SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
|
|
c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
|
|
c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
|
|
c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
|
|
c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
|
|
FROM t1;
|
|
|
|
DROP TABLE t1;
|
|
SET sql_mode=default;
|
|
UNINSTALL PLUGIN daemon_memcached;
|
|
DROP DATABASE innodb_memcache;
|
|
|
|
SET @@global.transaction_isolation= @transaction_isolation;
|