[MDEV-8682] CSV engine does not properly process "", in quotes Created: 2015-08-26 Updated: 2015-09-28 Resolved: 2015-09-28 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | OTHER |
| Affects Version/s: | 10.1.6 |
| Fix Version/s: | 10.1.8 |
| Type: | Bug | Priority: | Major |
| Reporter: | Ian Gilfillan | Assignee: | Sergey Vojtovich |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | upstream | ||
| Sprint: | 10.1.8-3 |
| Description |
|
The 2013 MySQL bug http://bugs.mysql.com/bug.php?id=71091 also affects MariaDB (verified on 10.1, almost certainly all other versions too). It has been fixed on Percona server - https://www.percona.com/doc/percona-server/5.6/flexibility/csv_engine_mode.html - with the introduction of a new system variable, csv_mode A user requested whether this could apply to MariaDB as well. I suggested they try CONNECT (I haven't tested whether the same issue appears there also), but it would make sense to use the same solution on MariaDB. |
| Comments |
| Comment by Sergey Vojtovich [ 2015-09-22 ] |
|
serg, please review patch for this task. There're 2 actually: original Percona port and improved one - whichever your like more. |
| Comment by Sergey Vojtovich [ 2015-09-28 ] |
|
Added per-table boolean IETF_QUOTES variable to CSV storage engine. It allows to enable IETF-compatible parsing of embedded quote and comma characters. Disabled by default. |