mariadb/mysql-test/main/servers_upgrade.test
Yuchen Pei d203a8a5df
MENT-2388 MDEV-37518 Check number of fields in mysql.servers before trying to read Options
Also added a test covering MDEV-36087

This is a followup of 6f1161aa34
2025-09-15 10:43:54 +10:00

17 lines
576 B
Text

--echo #
--echo # MDEV-36087 MariDB 11.7.2 - /usr/sbin/mariadbd got signal 11
--echo #
# This test simulates the scenario in MDEV-36087 by dropping the
# column added in MDEV-34716
create server s foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port 3306);
show create server s;
alter table mysql.servers drop column Options;
show create server s;
--source include/restart_mysqld.inc
show create server s;
ALTER TABLE mysql.servers
ADD Options JSON NOT NULL DEFAULT '{}' CHECK(JSON_VALID(Options));
show create server s;
drop server s;