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 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.