[MDEV-25306] mysqldump options --ignore-table and --ignore-table-data are case-insensitive Created: 2021-03-30  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None


 Description   

mysqldump (mariadb-dump has options

  --ignore-table-data=name 
                      Do not dump the specified table data. To specify more
 
                      than one table to ignore, use the directive multiple
 
                      times, once for each table. Each table must be specified
 
                      with both database and table names, e.g.,
 
                      --ignore-table-data=database.table.
 
  --ignore-table=name Do not dump the specified table. To specify more than one
 
                      table to ignore, use the directive multiple times, once
 
                      for each table.  Each table must be specified with both
 
                      database and table names, e.g.,
 
                      --ignore-table=database.table.

Both options are case-insensitive. That is, if we have tables test.A and test.a, then mysqldump ... --ignore-table=test.a will skip both tables, and so will mysqldump ... --ignore-table=test.A.

This is not universal for mysqldump options. For example, mysqldump ... test --tables A will only dump the table test.A, and mysqldump ... test --tables a will only dump the table test.a. So, treating ignore-table differently is inconsistent.
Generated at Thu Feb 08 09:36:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.