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

REGEXP ... ESCAPE

        Details

        • Type: Task
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Fix Version/s: 10.2
        • Component/s: None
        • Labels:
          None

          Description

          It has always been very hard to use regexp's with MySQL because... they need too many escape chars! The problem is that regexps use many '\', but that char needs to be doubles in the queries. Would it be possible to implement an ESCAPE clause, that works as in LIKE ... ESCAPE '|' ?

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                PavelCibulka PavelCibulka added a comment -

                I would rather see making NO_BACKSLASH_ESCAPES default. But that probably isn't going to happen soon.

                Show
                PavelCibulka PavelCibulka added a comment - I would rather see making NO_BACKSLASH_ESCAPES default. But that probably isn't going to happen soon.
                Hide
                Permalink
                bar Alexander Barkov added a comment -

                I'd also prefer NO_BACKSLASH_ESCAPES by default, with a PostgreSQL syntax with 'E' for escaped strings:

                SELECT E'\r\n';

                Show
                bar Alexander Barkov added a comment - I'd also prefer NO_BACKSLASH_ESCAPES by default, with a PostgreSQL syntax with 'E' for escaped strings: SELECT E'\r\n';
                Hide
                Permalink
                f_razzoli Federico Razzoli added a comment -

                i agree with the comments above

                Show
                f_razzoli Federico Razzoli added a comment - i agree with the comments above

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    f_razzoli Federico Razzoli
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated: