MySQL Bugs: #104329: strip_role_admin cannot be specified in the MySQL Shell compatibility option

Bug #104329	strip_role_admin cannot be specified in the MySQL Shell compatibility option
Submitted:	16 Jul 2021 5:23	Modified:	16 Jul 2021 10:09
Reporter:	MAKOTO FUKUMOTO	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Shell Dump & Load	Severity:	S3 (Non-critical)
Version:	8.0.25	OS:	CentOS
Assigned to:		CPU Architecture:	x86

Description:
The compatibility option in the reference below contains instructions for strip_role_admin.

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.ht...

However, if strip_role_admin is specified, the following error will occur.

```
# rpm -qa | grep -i mysql-shell
mysql-shell-8.0.25-1.el7.x86_64
# mysqlsh root@localhost
MySQL Shell 8.0.25

Copyright (c) 2016, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Type '\help' or '\?' for help; '\quit' to exit.
Creating a session to 'root@localhost'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 50 (X protocol)
Server version: 8.0.25 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.
 MySQL  localhost:33060+ ssl  JS > util.dumpInstance("bucketPrefix", {osBucketName: "mds", osNamespace: "xxxxx", threads: 2, ocimds: true, compatibility: ["strip_restricted_grants", "strip_definers", "strip_restricted_grants", "strip_role_admin"], dryRun: true})
Util.dumpInstance: Argument #2: Unknown compatibility option: strip_role_admin (ArgumentError)
 MySQL  localhost:33060+ ssl  JS >
```

Looking at the source code, I don't think there is a definition for strip_role_admin.

https://github.com/mysql/mysql-shell/blob/66610494cc96a4718c6b23c603e9a6e3234a984e/modules...

How to repeat:
See Description.

Hello MAKOTO-San,

Thank you for the report and feedback.

regards,
Umesh

Posted by developer:
 
This is an error in documentation, this compatibility option was never available, its functionality is covered by "strip_restricted_grants". The docs have been updated, changes will be visible in some time.