mirror of
https://github.com/MariaDB/server.git
synced 2025-09-26 02:49:13 +02:00
21 lines
869 B
Text
21 lines
869 B
Text
#
|
|
# MDEV-36087 MariDB 11.7.2 - /usr/sbin/mariadbd got signal 11
|
|
#
|
|
create server s foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port 3306);
|
|
show create server s;
|
|
Server Create Server
|
|
s CREATE SERVER `s` FOREIGN DATA WRAPPER mysql OPTIONS (host '127.0.0.1', database 'test', user 'root', port '3306');
|
|
alter table mysql.servers drop column Options;
|
|
show create server s;
|
|
Server Create Server
|
|
s CREATE SERVER `s` FOREIGN DATA WRAPPER mysql OPTIONS (host '127.0.0.1', database 'test', user 'root', port '3306');
|
|
# restart
|
|
show create server s;
|
|
Server Create Server
|
|
s CREATE SERVER `s` FOREIGN DATA WRAPPER mysql OPTIONS ();
|
|
ALTER TABLE mysql.servers
|
|
ADD Options JSON NOT NULL DEFAULT '{}' CHECK(JSON_VALID(Options));
|
|
show create server s;
|
|
Server Create Server
|
|
s CREATE SERVER `s` FOREIGN DATA WRAPPER mysql OPTIONS ();
|
|
drop server s;
|