Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14432

mysqldump does not preserve case of table names in generated sql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.0.26, 10.1, 10.2, 10.3, 10.2.10, 10.4, 10.0
    • Fix Version/s: 10.2, 10.3, 10.4
    • Component/s: Server
    • Labels:
      None
    • Environment:
      Windows 10 64bit MyISAM engine.

      Description

      The table name in the sql file generated by mysqldump is in lowercase. This only happens if the command arguments include a table name. If run without specifying a table the case of the table names is preserved.

      From looking at logs, it appears as if earlier versions used "show tables like ..." and the later versions use "select from information_schema.tables where table_name = ....".

      Interestingly there is a different result between like and =

      MariaDB [daves]> select table_name from information_schema.tables where table_schema = database() and table_name like 'BouncyCaps';
      +------------+
      | table_name |
      +------------+
      | BouncyCaps |
      +------------+
      1 row in set (0.00 sec)
       
      MariaDB [daves]>
      MariaDB [daves]> select table_name from information_schema.tables where table_schema = database() and table_name = 'BouncyCaps';
      +------------+
      | table_name |
      +------------+
      | bouncycaps |
      +------------+
      1 row in set (0.00 sec)
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            David Crimmins David Crimmins
            Votes:
            3 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated: