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

MYSQL_PS1 no longer handles "\n" correctly

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Won't Fix
        • Affects Version/s: 5.1.67, 5.2.14, 5.3.12
        • Fix Version/s: 5.3.13, 5.2.15, 5.1.73
        • Component/s: None
        • Labels:
          None
        • Environment:
          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.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                I cannot repeat it. How did you build MariaDB?

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

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

                Show
                serg Sergei Golubchik added a comment - To clarify: cannot repeat using mariadb-5.5.38 built on freebsd 9.2 from ports.
                Hide
                Permalink
                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

                Show
                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
                Hide
                Permalink
                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

                Show
                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
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

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

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

                  People

                  • Assignee:
                    serg Sergei Golubchik
                    Reporter:
                    ericx Eric W. Bates
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Due:
                      Created:
                      Updated:
                      Resolved: