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

testing a regex ends up in changing to non existent database

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 5.5, 10.0, 10.1, 10.2
    • N/A
    • Scripts & Clients
    • None

    Description

      Testing a select regexp_replace ends up in some strange behavior:

      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 25
      Server version: 10.2.0-MariaDB Source distribution
       
      Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> select regexp_replace("/* test */ LOAD /* infile load */ DATA LOCAL INFILE /* 'foo' */ 'foo.txt'', "/\*([^*]|[\r\n]|(\*+([^*/]|[\r\n])))*\*+/", "");
      ERROR: Unknown command '\*'.
      ERROR 1049 (42000): Unknown database 'n]|(*+([^*/]|[rn])))**+/",'
      unknown [n]|(*+([^*/]|[rn])))**+/",]> select 1;
      No connection. Trying to reconnect...
      ERROR 1049 (42000): Unknown database 'n]|(*+([^*/]|[rn])))**+/",'
      ERROR: Can't connect to the server
       
      unknown [n]|(*+([^*/]|[rn])))**+/",]> 
      

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            georg Georg Richter
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.