MySQL Bugs: #98859: multiple undo tablespace having same file name.

Bug #98859	multiple undo tablespace having same file name.
Submitted:	6 Mar 2020 14:01	Modified:	9 Mar 2020 12:48
Reporter:	Rahul Malik	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	8.0.19	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Users can create multiple undo tablespace with the same file name but different directory.

there is no 'per database/schema' concept for undo tablespaces then Why is it allowed to create undo tablespace with the same name?

How to repeat:
create undo tablespace undo_003 add datafile "undo_003.ibu";

and /some/undo/dir is part of --innodb_directories

create undo tablespace undo_004 add datafile "/some/undo/dir/undo_003.ibu";

Suggested fix:
IMHO They should not be allowed 

it can create some problems,
like https://bugs.mysql.com/bug.php?id=98628.

or when you have to restore this undo files to only undo_directory.

It may be useful for backup too to copy undo

Hi Mr. Malik,

Thank you for your bug report.

I have repeated the behaviour and I agree with your conclusions.

Verified as reported.