[Bug 268113] databases/mariadb106-client command prompt does not accept new line character \n in my.cnf

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=268113

            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 does
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 = \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 libedit.

Use

make CMAKE_ON=WITH_READLINE=bundled

to get 10.3-like build



Can we get back the right behavior of mariadb CLI?

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