Bug #91745 Contribution by Facebook: Add MY_APPEND_EXT flag when determining file name ...
Submitted: 20 Jul 2018 18:45 Modified: 31 Aug 2018 13:51
Reporter: FBContrib Admin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:8.0.11 OS:Any
Assigned to: CPU Architecture:Any

[20 Jul 2018 18:45] FBContrib Admin 
Description:
Background innformation provided by Facebook:
Abstract:

Currently, if a table name contains a dot, the fn_format function assumes that this is a file with an extension already. Instead we should always be appending the ".sql" and ".txt" extensions for table names.

This fixes https://bugs.mysql.com/bug.php?id=90314

Repo: https://github.com/mysql/mysql-server
Patch on top of 8.0.11: https://github.com/mysql/mysql-server/commit/4f1d7cf5fcb11a3f84cff27e37100d7295e7d5ca
Facebook commit: https://github.com/facebook/mysql-5.6/commit/bcb7d9c 

How to repeat:
See description

Suggested fix:
See contribution code attached
[20 Jul 2018 18:45] FBContrib Admin 
Add MY_APPEND_EXT flag when determining file names for mysqldump 
(*) This code is contributed under the Facebook agreement

Contribution: fb_patch_71.txt (text/plain), 1.09 KiB.
[31 Aug 2018 13:51] Paul DuBois 
Posted by developer:
 
Fixed in 8.0.13.

For mysqldump --tables output, file names now always include a .txt
or .sql suffix, even for file names that already contain a dot.
Thanks to Facebook for the contribution.
[23 Sep 2021 5:17] MySQL Verification Team 
Bug #90314 marked as duplicate of this one.