STATUS
------
Approved pending acceptance of requests.
REQUESTS
--------
1. Fix patch warning.
2. Please add a comment block to the top of the test.
DETAILS
-------
> Bug#43363 - Backup: Backup on case sensitive server restore on case insensitive
> server fails
>
> Before, RESTORE on a case insensitive server would fail if the backup image
> contained databases or tables with upper case names.
>
> Now, RESTORE is able to handle this case by converting the names to lowercase
> in the restore catalog as long as there are no duplicate names after the conversion. The
> duplicate name problem is logged as bug 43596.
...
> === added file 'mysql-test/suite/backup/t/backup_namecase-master.opt'
> --- a/mysql-test/suite/backup/t/backup_namecase-master.opt 1970-01-01 00:00:00 +0000
> +++ b/mysql-test/suite/backup/t/backup_namecase-master.opt 2009-03-20 14:00:02 +0000
> @@ -0,0 +1 @@
> +--lower_case_table_names=1
> \ No newline at end of file
1. Please fix this. I don't know if it matters, but I see the error when I apply
the patch.
> === added file 'mysql-test/suite/backup/t/backup_namecase.test'
> --- a/mysql-test/suite/backup/t/backup_namecase.test 1970-01-01 00:00:00 +0000
> +++ b/mysql-test/suite/backup/t/backup_namecase.test 2009-03-20 14:00:02 +0000
> @@ -0,0 +1,116 @@
> +--source include/have_debug_sync.inc
> +--source include/not_embedded.inc
> +
> +--echo
> +--echo # Create database with tables and views
> +--echo
2. I think a comment block at the top of this test that explains what is going
on (and perhaps why) would help considerably. For example, why are privileges
needed for this test?
...
Chuck