Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 02 Dec 2022 02:21:38 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 268113] databases/mariadb106-client command prompt does not accept new line character \n in my.cnf
Message-ID:  <bug-268113-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D268113

            Bug ID: 268113
           Summary: databases/mariadb106-client command prompt does not
                    accept new line character \n in my.cnf
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: brnrd@freebsd.org
          Reporter: 000.fbsd@quip.cz
             Flags: maintainer-feedback?(brnrd@freebsd.org)
          Assignee: brnrd@freebsd.org

We upgraded some of our machines from 10.3 to 10.6 and noticed that mysql
client / mariadb client command prompt looks different in 10.6 because it d=
oes
not accept newline character \n

\n is documented in https://mariadb.com/kb/en/mysql-command-line-client/

In 10.3 we had

[mysql]
prompt =3D \u @ \h [\d]:\nmysql>\_

The prompt looks like this:

root @ localhost [(mydatabase)]:
mysql>

With the same settings in MariaDB 10.6 the prompt looks like this:

root @ localhost [(mydatabase)]:mysql>

The prompt is not wrapped to 2 lines.


I already reported this issue to MariaDB Jira
https://jira.mariadb.org/browse/MDEV-30018
The resolution of this issue is that it is not a bug in MariaDB client but
libedit vs readline issue.


Sergei Golubchik wrote:
10.3 client doesn't have libedit.so.0, so it's indeed readline vs libedit
issue. 10.3 is linked with a budled readline, while 10.6 uses system libedi=
t.

Use

make CMAKE_ON=3DWITH_READLINE=3Dbundled

to get 10.3-like build



Can we get back the right behavior of mariadb CLI?

--=20
You are receiving this mail because:
You are the assignee for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-268113-7788>