[MDEV-29597] mysqldump outputs fully qualified names for views when lower_case_table_names=2 Created: 2022-09-21 Updated: 2022-09-22 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.6.8, 10.6.10 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Vitaliy | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Windows 10 64bit |
||
| Description |
|
Setting lower_case_table_names=2 option forces mysqldump to output fully qualified names for the views (including database name). This is an issues because such a scrips can't be used to recreate database with a different name. Steps to reproduce:
Example with lower_case_table_names=2
Example without lower_case_table_names=2
Output of the
changes to print fully qualified name when lower_case_table_names=2 |