[Bug 576949] Re: [lucid] LOAD DATA INFILE fails in replication, simple patch available in 5.1.43
clint at fewbar.com
Thu Sep 9 07:59:28 BST 2010
** Description changed:
LOAD DATA INFILE fails in replication when there are keywords or braces
in columnnames. This is a known bug in mysql:
http://bugs.mysql.com/bug.php?id=49479, which is fixed in 5.1.43.
However, Lucid LTS has 5.1.41.
Would it be possible to include the (very simple) patch mentioned in the
mysql bugreport (it's the same as the one committed to mysql, check out
the commit here: http://lists.mysql.com/commits/92988) in the package
+ Stable Release Update Report
+ This bug's impact should be minimal, as the patch is very small and only
+ affects replication slaves in a positive way by quoting strings
+ properly. This would affect any user who has a schema with columns that
+ conflict with SQL keywords.
+ DEVELOPMENT FIX
+ This was fixed in the upstream version contained in the current
+ development release (Maverick)
+ TEST CASE
+ 1. create a replication master/slave setup
+ 2. create a table with a column name of "SELECT"
+ 3. LOAD DATA INFILE into this table on the master
+ 4. slave will fail while attempting to apply this statement.
+ REGRESSION POTENTIAL
+ Given the minimal nature of the patch, regressions are quite unlikely.
+ Built and passed tests on lucid with normal regression test suite.
+ Here is the PPA build log:
[lucid] LOAD DATA INFILE fails in replication, simple patch available in 5.1.43
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.
More information about the Ubuntu-server-bugs