Bug #98622 Unexpected schema changes with --no-create-info
Submitted: 16 Feb 2020 12:22 Modified: 17 Feb 2020 6:01
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqlpump Command-line Client Severity:S3 (Non-critical)
Version:8.0.19, 5.7.29 OS:Any
Assigned to: CPU Architecture:Any

[16 Feb 2020 12:22] Daniël van Eeden
Description:
With --no-create-info mysqlpump doesn't include CREATE TABLE statements.

However it still contains ALTER TABLE statements to:
* Add keys
* Add check constraints

I don't expect that to happen. Either this is a documentation issue or a bug in the code.

How to repeat:
Run mysqlpump with --no-create-info and look for ALTER TABLE statements.

Suggested fix:
Don't include ALTER TABLE statements if --no-create-info is used.
[17 Feb 2020 6:01] MySQL Verification Team
Hello Daniël,

Thank you for the report and feedback.

regards,
Umesh