mirror of
https://github.com/MariaDB/server.git
synced 2026-03-30 21:20:42 +02:00
e054d8b874
let's simplify the code by removing copying of part_elem->connect_string
to table->s->connect_string. Move CONNECTION support from he server into
engines, engines define TOPTION("CONNECTION") if they want to support it,
it's stored in the option_struct and handled by the option_struct fix.
Problems:
* Mroonga used CONNECTION for something but there were no tests for it.
Removed Mroonga support for CONNECTION as requested by the maintainer
in MDEV-38530
* DROP/ALTER SERVER command used to close all tables using the server
in question, avoiding the need for FLUSH TABLES. This functionality
never worked for partitioned tables anyway and is now removed. Will be
done properly in MDEV-37827.
39 lines
1.4 KiB
Text
39 lines
1.4 KiB
Text
connect master,127.0.0.1,root,,test,$MASTER_MYPORT,;
|
|
connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT,;
|
|
connection master;
|
|
CREATE DATABASE federated;
|
|
connection slave;
|
|
CREATE DATABASE federated;
|
|
connection master;
|
|
#
|
|
# MDEV-388 Creating a federated table with a non-existing server returns a random error code
|
|
#
|
|
CREATE TABLE t1 (a INT) ENGINE=FEDERATED CONNECTION='non_existing';
|
|
ERROR HY000: server name: 'non_existing' doesn't exist!
|
|
SHOW WARNINGS;
|
|
Level Code Message
|
|
Error 1 server name: 'non_existing' doesn't exist!
|
|
Error 1 Can't create/write to file 'non_existing' (Errcode: 14 "Bad address")
|
|
Warning 1030 Got error 1 "Operation not permitted" from storage engine FEDERATED
|
|
#
|
|
# MDEV-4468 Assertion `error != 0' fails or timeout occurs on select from a FEDERATED table which points at a non-existent table
|
|
#
|
|
create table t1 (a int);
|
|
create table fed (a int) engine=Federated CONNECTION='mysql://root@127.0.0.1:MASTER_PORT/test/t1';
|
|
drop table t1;
|
|
select * from fed;
|
|
Got one of the listed errors
|
|
drop table fed;
|
|
# End of 5.5 tests
|
|
#
|
|
# MDEV-38039 SIGSEGV in parse_url on CREATE TABLE ... FEDERATED with empty CONNECTION
|
|
#
|
|
create table t1 (id int) engine=federated;
|
|
ERROR HY000: server name: '' doesn't exist!
|
|
# End of 12.3 tests
|
|
connection master;
|
|
DROP TABLE IF EXISTS federated.t1;
|
|
DROP DATABASE IF EXISTS federated;
|
|
connection slave;
|
|
DROP TABLE IF EXISTS federated.t1;
|
|
DROP DATABASE IF EXISTS federated;
|