Bug #90791 mysqldump --skip-create-options is invalid options

• Submitted: 8 May 2018 3:21
• Modified: 19 Jul 2018 12:05
• Reporter: Lehman Michael
• Status: Duplicate
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S4 (Feature request)
• Version: 8.0.11
• OS: CentOS (6.9)
• CPU Architecture: Any

[8 May 2018 3:21] Lehman Michael

Description:
I download mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz package and installing.

While I test mysqldump client add --skip-create-options,it happend error:

[root@node300 bin]# ./mysqldump --version
mysqldump  Ver 8.0.11 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)
[root@node300 bin]# ./mysqldump --skip-create-options -S ../mysql-files/mysql.sock -p123456  db01 > /tmp/t4.sql
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1 ,SQL_MODE=concat(@@sql_mode, _utf8mb4 ',NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS') ': Variable 'sql_mode' can't be set to the value of 'NO_KEY_OPTIONS' (1231)

I find mysql8.0 new feature:
These deprecated compatibility SQL modes have been removed: DB2, MAXDB, MSSQL, MYSQL323, MYSQL40, ORACLE, POSTGRESQL, NO_FIELD_OPTIONS, NO_KEY_OPTIONS, NO_TABLE_OPTIONS. They can no longer be assigned to the sql_mode system variable or used as permitted values for the mysqldump --compatible option

however  --compatible only permitted value for this option is ansi

it can't slove the problem.

How to repeat:
mysqldump --skip-create-options

[19 Jul 2018 12:05] MySQL Verification Team

Hello Lehman,

Thank you for the report.
Marking this as duplicate of Bug #91714(ideally this report should have been base bug but Bug #91714	is already in verified state and hence marking this as duplicate).

Regards,
Umesh