| 2014-05-05 08:43:42 |
Jericho Rivera |
bug |
|
|
added bug |
| 2014-05-05 08:46:45 |
Jericho Rivera |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=71091 |
|
| 2014-05-05 08:46:45 |
Jericho Rivera |
bug task added |
|
mysql-server |
|
| 2014-05-05 08:47:05 |
Jericho Rivera |
tags |
i37547 |
i37547 upstream |
|
| 2014-05-05 09:16:48 |
Jericho Rivera |
description |
MySQL's CSV engine does NOT interpret "", inside quotes properly. It requires sequence like \", to be there instead, without clear reason (I see nothing like this explained here, http://dev.mysql.com/doc/refman/5.6/en/csv-storage-engine.html).
How to repeat (taken from upstream bug description):
On any MySQL server version execute the following:
mysql> CREATE TABLE `emp` (
-> `col1` text NOT NULL,
-> `col2` text NOT NULL
-> ) ENGINE=CSV DEFAULT CHARSET=utf8
-> ;
Query OK, 0 rows affected (0.11 sec)
mysql> insert into emp values ("alan", "newyork"), ("jim", "CA\",boston");
Query OK, 2 rows affected (0.06 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from emp;
+------+------------+
| col1 | col2 |
+------+------------+
| alan | newyork |
| jim | CA",boston |
+------+------------+
2 rows in set (0.00 sec)
mysql> flush tables;
Query OK, 0 rows affected (0.05 sec)
Now, check what is in emp.CSV file in the database directory. You'll see:
"alan","newyork"
"jim","CA\",boston"
I do not see this documented on Wiki as acceptable way of quoting. Now, change file to conform to "standard":
"alan","newyork"
"jim","CA"",boston"
Then check how it is interpreted/loaded:
mysql> flush tables;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from emp;
+------+---------+
| col1 | col2 |
+------+---------+
| alan | newyork |
| jim | CA" |
+------+---------+
2 rows in set (0.02 sec)
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.33 |
+-----------+
1 row in set (0.01 sec) |
Original description can be found on upstream bug.
MySQL's CSV engine does NOT interpret "", inside quotes properly. It requires sequence like \", to be there instead, without clear reason (I see nothing like this explained here, http://dev.mysql.com/doc/refman/5.6/en/csv-storage-engine.html).
How to repeat (taken from upstream bug description):
On any MySQL server version execute the following:
mysql> CREATE TABLE `emp` (
-> `col1` text NOT NULL,
-> `col2` text NOT NULL
-> ) ENGINE=CSV DEFAULT CHARSET=utf8
-> ;
Query OK, 0 rows affected (0.11 sec)
mysql> insert into emp values ("alan", "newyork"), ("jim", "CA\",boston");
Query OK, 2 rows affected (0.06 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from emp;
+------+------------+
| col1 | col2 |
+------+------------+
| alan | newyork |
| jim | CA",boston |
+------+------------+
2 rows in set (0.00 sec)
mysql> flush tables;
Query OK, 0 rows affected (0.05 sec)
Now, check what is in emp.CSV file in the database directory. You'll see:
"alan","newyork"
"jim","CA\",boston"
I do not see this documented on Wiki as acceptable way of quoting. Now, change file to conform to "standard":
"alan","newyork"
"jim","CA"",boston"
Then check how it is interpreted/loaded:
mysql> flush tables;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from emp;
+------+---------+
| col1 | col2 |
+------+---------+
| alan | newyork |
| jim | CA" |
+------+---------+
2 rows in set (0.02 sec)
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.33 |
+-----------+
1 row in set (0.01 sec) |
|
| 2014-05-05 09:57:08 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.5 |
|
| 2014-05-05 09:57:08 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.5 |
|
| 2014-05-05 09:57:08 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.1 |
|
| 2014-05-05 09:57:08 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.1 |
|
| 2014-05-05 09:57:08 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.6 |
|
| 2014-05-05 09:57:08 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.6 |
|
| 2014-05-06 07:25:37 |
Jericho Rivera |
tags |
i37547 upstream |
i37457 upstream |
|
| 2014-05-06 08:29:11 |
Jericho Rivera |
percona-server/5.1: status |
New |
Confirmed |
|
| 2014-05-06 08:29:23 |
Jericho Rivera |
percona-server/5.5: status |
New |
Confirmed |
|
| 2014-05-06 08:29:33 |
Jericho Rivera |
percona-server/5.6: status |
New |
Confirmed |
|
| 2014-05-06 12:30:20 |
Laurynas Biveinis |
percona-server/5.6: status |
Confirmed |
Triaged |
|
| 2014-05-06 12:30:28 |
Laurynas Biveinis |
percona-server/5.5: importance |
Undecided |
Medium |
|
| 2014-05-06 12:30:32 |
Laurynas Biveinis |
percona-server/5.5: status |
Confirmed |
Triaged |
|
| 2014-05-06 12:30:36 |
Laurynas Biveinis |
percona-server/5.6: importance |
Undecided |
Medium |
|
| 2014-07-18 14:15:28 |
Laurynas Biveinis |
percona-server/5.5: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
| 2014-07-18 14:15:33 |
Laurynas Biveinis |
percona-server/5.1: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
| 2014-07-18 14:15:38 |
Laurynas Biveinis |
percona-server/5.6: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
| 2014-07-18 14:20:43 |
Laurynas Biveinis |
percona-server/5.1: status |
Confirmed |
Won't Fix |
|
| 2014-07-18 14:21:44 |
Laurynas Biveinis |
percona-server/5.5: status |
Triaged |
In Progress |
|
| 2014-07-22 08:27:56 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/bug1316042-5.5 |
|
| 2014-07-22 08:39:14 |
Laurynas Biveinis |
percona-server/5.5: status |
In Progress |
Fix Committed |
|
| 2014-07-22 08:39:20 |
Laurynas Biveinis |
percona-server/5.6: status |
Triaged |
Fix Committed |
|
| 2014-07-22 08:40:10 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/bug1316042-5.6 |
|
| 2014-08-22 13:48:01 |
Laurynas Biveinis |
percona-server/5.5: status |
Fix Committed |
In Progress |
|
| 2014-10-01 12:07:37 |
Laurynas Biveinis |
percona-server/5.5: status |
In Progress |
Fix Committed |
|
| 2014-10-01 12:07:42 |
Laurynas Biveinis |
percona-server/5.6: status |
Fix Committed |
In Progress |
|
| 2014-10-01 12:07:09 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/csv-engine-ietf-quotes |
|
| 2014-10-01 13:11:31 |
Laurynas Biveinis |
percona-server/5.6: status |
In Progress |
Fix Committed |
|
| 2014-10-01 13:10:53 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/csv-engine-ietf-quotes-5.6 |
|
| 2014-10-12 08:19:46 |
Laurynas Biveinis |
percona-server/5.5: milestone |
|
5.5.40-37.0 |
|
| 2014-10-12 08:19:49 |
Laurynas Biveinis |
percona-server/5.6: milestone |
|
5.6.21-69.1 |
|
| 2014-10-12 08:19:52 |
Laurynas Biveinis |
percona-server/5.5: status |
Fix Committed |
Fix Released |
|
| 2014-10-12 08:19:58 |
Laurynas Biveinis |
percona-server/5.6: status |
Fix Committed |
Fix Released |
|
