Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
--let $include= ../storage/spider/mysql-test/spider/include
|
--error 0,1
|
--file_exists $include/init_spider.inc
|
if ($errno) |
{
|
--let $include= plugin/spider/spider/include |
}
|
|
|
--source $include/init_spider.inc
|
--source include/have_partition.inc
|
|
|
SET spider_same_server_link= on; |
eval create server s foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port $MASTER_MYPORT); |
|
|
CREATE TABLE t1 (a INT); |
INSERT INTO t1 VALUES (1),(2); |
CREATE TABLE t2 (a INT); |
INSERT INTO t2 VALUES (3),(4); |
|
|
CREATE TABLE t_spider (a INT) ENGINE=SPIDER |
PARTITION BY HASH (a) ( |
PARTITION p1 COMMENT='srv "s", table "t1"', |
PARTITION P2 COMMENT='srv "s", table "t2"' |
);
|
|
|
CHECK TABLE t_spider; |
|
|
# Cleanup
|
|
|
DROP TABLE t_spider, t1, t2; |
DROP SERVER s; |
|
|
--source $include/deinit_spider.inc |
|
10.3 dd8833bf |
CHECK TABLE t_spider; |
Table Op Msg_type Msg_text |
test.t_spider check error Found a misplaced row |
test.t_spider check error Partition p1 returned error |
test.t_spider check error Upgrade required. Please do "REPAIR TABLE `t_spider`" or dump/reload to fix it! |
Reproducible on all 10.3+.