[MacPorts] #64006: mysql* lacks editline or readline support

[MacPorts]

#64006: mysql* lacks editline or readline support
----------------------------+-------------------------------------
  Reporter:  laggardkernel  |      Owner:  herbygillot
      Type:  defect         |     Status:  closed
  Priority:  Normal         |  Milestone:
 Component:  ports          |    Version:  2.7.1
Resolution:  fixed          |   Keywords:  mysql editline readline
      Port:  mysql8         |
----------------------------+-------------------------------------

Comment (by laggardkernel):

 Sorry, I'm not familiar about how to compiling MySQL. I did tried the new
 revision 4 of `mysql8` and I still encounter the error `bind: Invalid
 command 'ed-tty-sigint'`. But the libedit did get used by `mysql`.

 {{{
 ❯ otool -L /opt/local/bin/mysql
 /opt/local/bin/mysql:
         /opt/local/lib/libedit.0.dylib (compatibility version 1.0.0,
 current version 1.68.0)
         /opt/local/lib/libz.1.dylib (compatibility version 1.0.0, current
 version 1.2.11)
         /opt/local/lib/libzstd.1.dylib (compatibility version 1.0.0,
 current version 1.5.0)
         /opt/local/libexec/openssl11/lib/libssl.1.1.dylib (compatibility
 version 1.1.0, current version 1.1.0)
         /opt/local/libexec/openssl11/lib/libcrypto.1.1.dylib
 (compatibility version 1.1.0, current version 1.1.0)
         /usr/lib/libresolv.9.dylib (compatibility version 1.0.0, current
 version 1.0.0)
         /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current
 version 400.9.4)
         /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
 version 1252.250.1)
 }}}

 And here is the `otool` output for Homebrew MySQL

 {{{
 otool -L /usr/local/bin/mysql
 /usr/local/bin/mysql:
         /usr/lib/libedit.3.dylib (compatibility version 2.0.0, current
 version 3.0.0)
         /usr/lib/libz.1.dylib (compatibility version 1.0.0, current
 version 1.2.11)
         /usr/local/opt/zstd/lib/libzstd.1.dylib (compatibility version
 1.0.0, current version 1.5.0)
         /usr/local/opt/openssl at 1.1/lib/libssl.1.1.dylib (compatibility
 version 1.1.0, current version 1.1.0)
         /usr/local/opt/openssl at 1.1/lib/libcrypto.1.1.dylib (compatibility
 version 1.1.0, current version 1.1.0)
         /usr/lib/libresolv.9.dylib (compatibility version 1.0.0, current
 version 1.0.0)
         /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current
 version 400.9.4)
         /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
 version 1252.250.1)
 }}}

 Is it because we're not using the system libedit? But `ed-tty-sigint` do
 exists in the MacPorts `libedit`, by checking `man 7 editline`. Currently
 I can drop the `Ctrl-d` and `Ctrl-c` keybindings to avoid the error, cause
 they seems to be enabled by default.

 Besides, the newline `\n` still doesn't take effect in `mysql` command
 line.

-- 
Ticket URL: <https://trac.macports.org/ticket/64006#comment:7>
MacPorts <https://www.macports.org/>
Ports system for macOS