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

          I cannot repeat it. How did you build MariaDB?

          serg Sergei Golubchik added a comment - I cannot repeat it. How did you build MariaDB?

          To clarify: cannot repeat using mariadb-5.5.38 built on freebsd 9.2 from ports.

          serg Sergei Golubchik added a comment - To clarify: cannot repeat using mariadb-5.5.38 built on freebsd 9.2 from ports.
          ericx Eric W. Bates added a comment -

          um... Let me gather them..

          On FreeBSD 10.0-RELEASE-p3:

          1. This file is auto-generated by 'make config'.
          2. Options for mariadb-client-5.3.7
            _OPTIONS_READ=mariadb-client-5.3.7
            _FILE_COMPLETE_OPTIONS_LIST= THREADSAFE STATIC SSL OPENSSL
            OPTIONS_FILE_SET+=THREADSAFE
            OPTIONS_FILE_UNSET+=STATIC
            OPTIONS_FILE_SET+=SSL
            OPTIONS_FILE_UNSET+=OPENSSL

          Actual build is currently 5.3.12

          On FreeBSD 9.1-STABLE:

          1. This file is auto-generated by 'make config'.
          2. Options for mariadb-client-5.3.12
            _OPTIONS_READ=mariadb-client-5.3.12
            _FILE_COMPLETE_OPTIONS_LIST=OPENSSL SSL STATIC THREADSAFE
            OPTIONS_FILE_SET+=OPENSSL
            OPTIONS_FILE_SET+=SSL
            OPTIONS_FILE_UNSET+=STATIC
            OPTIONS_FILE_SET+=THREADSAFE

          Actual build is 5.3.12_3

          On FreeBSD 9.1-RELEASE:

          1. This file is auto-generated by 'make config'.
          2. Options for mariadb-client-5.3.7
            _OPTIONS_READ=mariadb-client-5.3.7
            _FILE_COMPLETE_OPTIONS_LIST= THREADSAFE STATIC SSL OPENSSL
            OPTIONS_FILE_SET+=THREADSAFE
            OPTIONS_FILE_UNSET+=STATIC
            OPTIONS_FILE_SET+=SSL
            OPTIONS_FILE_UNSET+=OPENSSL

          Actual build is currently 5.3.11

          I can probably find a few more if needed; but I suspect the build
          options are all the same.

          I will attempt upgrading to 5.5.x and report.


          Eric W. Bates
          ericx@ericx.net
          508/243-8341

          ericx Eric W. Bates added a comment - um... Let me gather them.. On FreeBSD 10.0-RELEASE-p3: This file is auto-generated by 'make config'. Options for mariadb-client-5.3.7 _OPTIONS_READ=mariadb-client-5.3.7 _FILE_COMPLETE_OPTIONS_LIST= THREADSAFE STATIC SSL OPENSSL OPTIONS_FILE_SET+=THREADSAFE OPTIONS_FILE_UNSET+=STATIC OPTIONS_FILE_SET+=SSL OPTIONS_FILE_UNSET+=OPENSSL Actual build is currently 5.3.12 — On FreeBSD 9.1-STABLE: This file is auto-generated by 'make config'. Options for mariadb-client-5.3.12 _OPTIONS_READ=mariadb-client-5.3.12 _FILE_COMPLETE_OPTIONS_LIST=OPENSSL SSL STATIC THREADSAFE OPTIONS_FILE_SET+=OPENSSL OPTIONS_FILE_SET+=SSL OPTIONS_FILE_UNSET+=STATIC OPTIONS_FILE_SET+=THREADSAFE Actual build is 5.3.12_3 — On FreeBSD 9.1-RELEASE: This file is auto-generated by 'make config'. Options for mariadb-client-5.3.7 _OPTIONS_READ=mariadb-client-5.3.7 _FILE_COMPLETE_OPTIONS_LIST= THREADSAFE STATIC SSL OPENSSL OPTIONS_FILE_SET+=THREADSAFE OPTIONS_FILE_UNSET+=STATIC OPTIONS_FILE_SET+=SSL OPTIONS_FILE_UNSET+=OPENSSL Actual build is currently 5.3.11 I can probably find a few more if needed; but I suspect the build options are all the same. — I will attempt upgrading to 5.5.x and report. – Eric W. Bates ericx@ericx.net 508/243-8341
          ericx Eric W. Bates added a comment -

          I can confirm that the problem is gone in 5.5.38 on FreeBSD
          10-RELEASE-p5. I'm happy to know that it's been fixed and my servers can
          wait for the upgrade.

          I think it is worth pointing out that the port maintainer for MariaDB
          still has 5.3.x as the default build (don't know why) and I, for one,
          found the upgrade to be difficult.

          Thank you.


          Eric W. Bates
          ericx@ericx.net
          508/243-8341

          ericx Eric W. Bates added a comment - I can confirm that the problem is gone in 5.5.38 on FreeBSD 10-RELEASE-p5. I'm happy to know that it's been fixed and my servers can wait for the upgrade. I think it is worth pointing out that the port maintainer for MariaDB still has 5.3.x as the default build (don't know why) and I, for one, found the upgrade to be difficult. Thank you. – Eric W. Bates ericx@ericx.net 508/243-8341

          Already fixed in 5.5, we won't backport the fix to 5.1—5.3

          serg Sergei Golubchik added a comment - Already fixed in 5.5, we won't backport the fix to 5.1—5.3

          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.