[debian-mysql] Bug#440507: mysqlhotcopy "Invalid db.table name ... at /usr/bin/mysqlhotcopy line 859" - patch included

[Gabor FUNK]

Package: mysql-server-5.0
Version: mysql-dfsg-5.0 5.0.45-1

I guess this should be fixed upstream, but upstream bug opened
at 20th March, 2007 with "Severity: S1 (Critical)", yet not seem
to be fixed.
(http://bugs.mysql.com/bug.php?id=27303)

Patch and all other previous details:


----- Original Message ----- 
From: Gabor FUNK 
To: ch at debian.org ; seanius at debian.org ; adconrad at 0c3.net 
Sent: Sunday, August 05, 2007 10:45 AM
Subject: Fw: 5.0.41a-1 - mysqlhotcopy error


I know mysql package is a bit orphaned, and mysqlhotcopy has even
less priority, but I provide a patch to fix stil existing mysqlhotcopy
"error", hoping that it will make into the distribution....


#--8<----------------------

--- mysqlhotcopy.ori 2007-06-25 03:05:26.000000000 +0200
+++ mysqlhotcopy 2007-08-05 10:37:51.000000000 +0200
@@ -837,6 +837,7 @@
     });
 
     my @dbh_tables = eval { $dbh->tables() };
+    map { s/^.*?\.//o } @dbh_tables;
 
     ## Remove quotes around table names
     my $quote = $dbh->get_info(29); # SQL_IDENTIFIER_QUOTE_CHAR

#--8<----------------------


Cheers, G.



----- Original Message ----- 
From: "Gabor FUNK" <FUNK.Gabor at hunetkft.hu>
To: <pkg-mysql-maint at lists.alioth.debian.org>
Sent: Monday, July 02, 2007 10:28 AM
Subject: 5.0.41a-1 - mysqlhotcopy error


> I recently updated my testing system, mysql is at 5.0.41a-1 now.
> Before mysqlhotcopy was working well, after the upgrade it
> displayed the following error message:
> 
> Invalid db.table name 'foo.foo`.`bar' at /usr/bin/mysqlhotcopy line 859.
> (real example:
> Invalid db.table name 'huweb-forum.huweb-forum`.`phpbb_attach_quota' at 
> /usr/bin/mysqlhotcopy line 859. )
> 
> This seems to be sort of upstream - but it is only in "verified" status.
> http://bugs.mysql.com/bug.php?id=27303
> 
> As described above, it can be fixed by adding a line containing:
>    map { s/^.*?\.//o } @dbh_tables;
> after line 839 which is 
>    my @dbh_tables = eval { $dbh->tables() };
> (This is mysqlhotcopy v1.22, size 33225, dated Jun 25, 03:05)
> 
> I can confirm that this works indeed .
> 
> G.