From e8e0559ed213db0fffcfd9e2108eedaeb451f7f4 Mon Sep 17 00:00:00 2001 From: Thirunarayanan Balathandayuthapani Date: Fri, 17 Mar 2023 17:17:35 +0530 Subject: MDEV-30870 Undo tablespace name displays wrongly for I_S queries - INNODB_SYS_TABLESPACES in information schema should display innodb_undo001, innodb_undo002 etc as tablespace name for undo tablespaces --- storage/innobase/handler/i_s.cc | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) (limited to 'storage') diff --git a/storage/innobase/handler/i_s.cc b/storage/innobase/handler/i_s.cc index 063462a12b9..366ef38cc07 100644 --- a/storage/innobase/handler/i_s.cc +++ b/storage/innobase/handler/i_s.cc @@ -6436,8 +6436,13 @@ static int i_s_sys_tablespaces_fill(THD *thd, const fil_space_t &s, TABLE *t) OK(f->store(name.data(), name.size(), system_charset_info)); f->set_notnull(); } - else - f->set_notnull(); + else if (srv_is_undo_tablespace(s.id)) + { + char name[15]; + snprintf(name, sizeof name, "innodb_undo%03zu", + (s.id - srv_undo_space_id_start + 1)); + OK(f->store(name, strlen(name), system_charset_info)); + } else f->set_notnull(); } fields[SYS_TABLESPACES_NAME]->set_null(); -- cgit v1.2.1