2010-05-07 12:00:55 |
Mrten |
bug |
|
|
added bug |
2010-05-07 12:01:41 |
Mrten |
summary |
LOAD DATA INFILE fails in replication, simple patch in 5.1.43 |
[lucid] LOAD DATA INFILE fails in replication, simple patch available in 5.1.43 |
|
2010-05-10 20:55:57 |
Mrten |
attachment added |
|
patch taken from mysql commit log http://launchpadlibrarian.net/48235687/tmp.patch |
|
2010-05-17 15:09:29 |
Chuck Short |
mysql-dfsg-5.1 (Ubuntu): importance |
Undecided |
Medium |
|
2010-05-17 15:09:29 |
Chuck Short |
mysql-dfsg-5.1 (Ubuntu): status |
New |
Incomplete |
|
2010-05-17 15:23:17 |
Mrten |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=49479 |
|
2010-05-17 16:31:38 |
Brian Murray |
tags |
|
patch |
|
2010-05-25 16:51:39 |
Chuck Short |
mysql-dfsg-5.1 (Ubuntu): status |
Incomplete |
In Progress |
|
2010-06-29 14:04:41 |
Mrten |
nominated for series |
|
Ubuntu Lucid |
|
2010-08-20 14:24:50 |
Chuck Short |
bug task added |
|
mysql-dfsg-5.1 (Ubuntu Lucid) |
|
2010-08-20 14:26:07 |
Chuck Short |
mysql-dfsg-5.1 (Ubuntu): status |
In Progress |
Fix Released |
|
2010-09-03 17:45:08 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu Lucid): status |
New |
In Progress |
|
2010-09-03 17:45:12 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu Lucid): assignee |
|
Clint Byrum (clint-fewbar) |
|
2010-09-03 18:26:19 |
Launchpad Janitor |
branch linked |
|
lp:~clint-fewbar/ubuntu/lucid/mysql-dfsg-5.1/sru-576949 |
|
2010-09-09 06:59:28 |
Clint Byrum |
description |
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 for Lucid? |
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 for Lucid?
Stable Release Update Report
IMPACT
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:
https://launchpad.net/~clint-fewbar/+archive/fixes/+build/1945729 |
|
2010-09-09 07:07:44 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu Lucid): assignee |
Clint Byrum (clint-fewbar) |
|
|
2010-09-09 07:07:46 |
Clint Byrum |
bug |
|
|
added subscriber Clint Byrum |
2010-09-09 07:07:48 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu Lucid): status |
In Progress |
Confirmed |
|
2010-11-21 18:21:56 |
Clint Byrum |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
2010-11-21 18:22:01 |
Clint Byrum |
mysql-dfsg-5.1 (Ubuntu Lucid): assignee |
|
Clint Byrum (clint-fewbar) |
|
2011-02-09 20:58:11 |
Kees Cook |
mysql-dfsg-5.1 (Ubuntu Lucid): status |
Confirmed |
Fix Committed |
|
2011-02-09 20:58:49 |
Kees Cook |
bug |
|
|
added subscriber SRU Verification |
2011-02-09 20:59:02 |
Kees Cook |
tags |
patch |
patch verification-needed |
|
2011-02-11 14:41:12 |
Mrten |
tags |
patch verification-needed |
patch verified |
|
2011-02-11 14:43:32 |
Mrten |
tags |
patch verified |
patch verification-done |
|
2011-02-13 19:52:08 |
Launchpad Janitor |
branch linked |
|
lp:ubuntu/lucid-proposed/mysql-dfsg-5.1 |
|
2011-02-25 14:40:12 |
Launchpad Janitor |
mysql-dfsg-5.1 (Ubuntu Lucid): status |
Fix Committed |
Fix Released |
|
2011-09-19 21:19:03 |
Ubuntu Foundations Team Bug Bot |
tags |
patch verification-done |
patch testcase verification-done |
|