Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8682

CSV engine does not properly process "", in quotes

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.1.6
        • Fix Version/s: 10.1.8
        • Component/s: OTHER
        • Labels:
        • 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.

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #71091 - CSV engine does not properly process "", in quotes

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  svoj Sergey Vojtovich added a comment -

                  Sergei Golubchik, please review patch for this task. There're 2 actually: original Percona port and improved one - whichever your like more.

                  Show
                  svoj Sergey Vojtovich added a comment - Sergei Golubchik , please review patch for this task. There're 2 actually: original Percona port and improved one - whichever your like more.
                  Hide
                  Permalink
                  svoj Sergey Vojtovich added a comment -

                  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.

                  Show
                  svoj Sergey Vojtovich added a comment - 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.

                    People

                    • Assignee:
                      svoj Sergey Vojtovich
                      Reporter:
                      greenman Ian Gilfillan
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      4 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 15 minutes
                        15m

                          Agile