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

\W client command does not work well with DELIMITER

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 5.1.67, 5.2.14, 5.3.12, 5.5.34, 10.0.7
    • None
    • None

    Description

      I found this bug adding \W at the beginning of a batch file, but I can write a command-line test case:

      MariaDB [stk_apalog]> \W
      Show warnings enabled.
      MariaDB [stk_apalog]> DELIMITER ||
      MariaDB [stk_apalog]> CREATE DATABASE IF NOT EXISTS test;
          -> DO NULL;
          -> ||
      Query OK, 1 row affected, 1 warning (0.00 sec)
       
      Query OK, 0 rows affected (0.00 sec)

      The || delimiter runs 2 statements in this case. If the first statement generates a warning, the warning does not appear. By deleting USE NULL and retrying, the warning appears.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            f_razzoli Federico Razzoli
            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.