Skip to content

SQL export "one file per object" overwrites .sql file when table and procedure have the same name #2212

@ansgarbecker

Description

@ansgarbecker

Description

In MySQL, you can create tables, procedures, functions, triggers and events with all the same name in one database. The scope of their names seems to include the object types. When exporting such "duplicates", HeidiSQL writes only one file, and the last one wins.

Image

HeidiSQL version

12.11

Database server version

Reproduction recipe

  • Have a table and a procedure with the same name in one database
  • go to SQL export, select output "Directory - one file per object"
  • export

Error/Backtrace

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLconfirmedIssue verified by project membercriticalCauses data-loss on client or server

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions