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

MYSQL_PS1 no longer handles "\n" correctly

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 5.1.67, 5.2.14, 5.3.12
    • 5.1.73, 5.2.15, 5.3.13
    • None
    • None
    • FreeBSD 10.0-RELEASE-p3
      FreeBSD 9.x-RELEASE
      FreeBSD 8.x-RELEASE

    Description

      As of the first release of MariaDB, the '\n' char no longer results in a CR/LF in the mysql prompt when it is included in MYSQL_PS1. This does not appear to be a problem in any of the mysql releases I have used (e.g. 5.1.6).

      e.g: my prompt:

       ** root@hazel ** ~ ** Mon Jul 21 15:49:06
      # set | grep -i mysql
      MYSQL_PS1=' \u ** \d ** \D\nsql> '

      results in:

       ** root@hazel ** ~ ** Mon Jul 21 15:49:21
      # mysql
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 2649
      Server version: 5.3.12-MariaDB-log Source distribution
       
      Copyright (c) 2000, 2012, Oracle, Monty Program Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
       ericx ** (none) ** Mon Jul 21 15:49:30 201sql> 

      Should have reported this a long time ago...
      Thanks for your time.

      Attachments

        Activity

          ericx Eric W. Bates created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Description As of the first release of MariaDB, the '\n' char no longer results in a CR/LF in the mysql prompt when it is included in MYSQL_PS1. This does not appear to be a problem in any of the mysql releases I have used (e.g. 5.1.6).

          e.g: my prompt:

           ** root@hazel ** ~ ** Mon Jul 21 15:49:06
          # set | grep -i mysql
          MYSQL_PS1=' \u ** \d ** \D\nsql> '

          results in:

           ** root@hazel ** ~ ** Mon Jul 21 15:49:21
          # mysql
          Welcome to the MariaDB monitor. Commands end with ; or \g.
          Your MariaDB connection id is 2649
          Server version: 5.3.12-MariaDB-log Source distribution

          Copyright (c) 2000, 2012, Oracle, Monty Program Ab and others.

          Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

           ericx ** (none) ** Mon Jul 21 15:49:30 201sql>


          Should have reported this a long time ago...
          Thanks for your time.
          As of the first release of MariaDB, the '\n' char no longer results in a CR/LF in the mysql prompt when it is included in MYSQL_PS1. This does not appear to be a problem in any of the mysql releases I have used (e.g. 5.1.6).

          e.g: my prompt:

          {noformat}
           ** root@hazel ** ~ ** Mon Jul 21 15:49:06
          # set | grep -i mysql
          MYSQL_PS1=' \u ** \d ** \D\nsql> '
          {noformat}

          results in:

          {noformat}
           ** root@hazel ** ~ ** Mon Jul 21 15:49:21
          # mysql
          Welcome to the MariaDB monitor. Commands end with ; or \g.
          Your MariaDB connection id is 2649
          Server version: 5.3.12-MariaDB-log Source distribution

          Copyright (c) 2000, 2012, Oracle, Monty Program Ab and others.

          Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

           ericx ** (none) ** Mon Jul 21 15:49:30 201sql>
          {noformat}

          Should have reported this a long time ago...
          Thanks for your time.
          serg Sergei Golubchik made changes -
          Labels MariaDB_5.3
          serg Sergei Golubchik made changes -
          Due Date 2014-09-05
          serg Sergei Golubchik made changes -
          Fix Version/s 5.3.13 [ 12602 ]
          Fix Version/s 5.2.15 [ 12601 ]
          Fix Version/s 5.1.73 [ 12600 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ]
          Resolution Won't Fix [ 2 ]
          Status Open [ 1 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 50503 ] MariaDB v3 [ 64683 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 64683 ] MariaDB v4 [ 148050 ]

          People

            serg Sergei Golubchik
            ericx Eric W. Bates
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.