bug#17426: 24.3.90; interactive mysql mode should support mariadb

bug#17426: 24.3.90; interactive mysql mode should support mariadb

[Jonathan Kotta]

From: Jonathan Kotta <jpkotta@gmail.com>
To: bug-gnu-emacs@gnu.org
Subject: 24.3.90; interactive mysql mode should support mariadb
--text follows this line--

0. Have a MySQL or MariaDB server to connect to.  I'm testing with MySQL
5.5.37 and MariaDB 5.5.37.
1. M-x sql-mysql RET
2. Enter the database, username, password, and hostname.
3. The interactive SQL buffer pops up, but there is no visible prompt.
4. If you enter some commands (e.g. "show status;") and send them, the
prompt will be printed in between the commands and the output from the
database.

The fix is to change the the prompt regexp from "^mysql>" to
"^\\(?:mysql\\|mariadb\\).*> " in sql-product-alist or to modify the
alist with (sql-set-product-feature 'mysql :prompt-regexp
"^\\(?:mysql\\|mariadb\\).*> ").

An example prompt (using the database bench_drylake): "MySQL
[bench_drylake]> " or "MariaDB [bench_drylake]> ".

Opinion: It makes sense for the MySQL configuration to support MariaDB,
because MariaDB is supposed to be as close as possible to a drop-in
replacement for MySQL.  It is the recommended alternative to MySQL on Linux
distibutions like Arch Linux.



In GNU Emacs 24.3.90.1 (x86_64-unknown-linux-gnu, X toolkit, Xaw3d scroll bars)
 of 2014-04-14 on shannon
Windowing system distributor `The X.Org Foundation', version 11.0.11501000
System Description:    Arch Linux

Configured using:
 `configure --prefix=/usr --sysconfdir=/etc --libexecdir=/usr/lib
 --localstatedir=/var --with-x-toolkit=lucid --with-xft --without-gconf
 --without-gsettings 'CFLAGS=-march=x86-64 -mtune=generic -O2 -pipe
 -fstack-protector --param=ssp-buffer-size=4'
 CPPFLAGS=-D_FORTIFY_SOURCE=2
 LDFLAGS=-Wl,-O1,--sort-common,--as-needed,-z,relro'

Important settings:
  value of $LANG: en_US.UTF-8
  locale-coding-system: utf-8-unix

Major mode: SQLi[MySQL]

Minor modes in effect:
  tooltip-mode: t
  electric-indent-mode: t
  mouse-wheel-mode: t
  menu-bar-mode: t
  file-name-shadow-mode: t
  global-font-lock-mode: t
  font-lock-mode: t
  blink-cursor-mode: t
  auto-composition-mode: t
  auto-encryption-mode: t
  auto-compression-mode: t
  line-number-mode: t
  transient-mark-mode: t

Recent input:
<return> <return> <return> <return> <return> l s <return>
; <return> M-x r e p o r t <tab> <return>

Recent messages:
Mark set [2 times]
t
Process SQL hangup

Login...done
End of buffer [4 times]
(:name "MySQL" :free-software t :font-lock
sql-mode-mysql-font-lock-keywords :sqli-program sql-mysql-program
:sqli-options sql-mysql-options :sqli-login sql-mysql-login-params
...)
Process SQL hangup

Login...done

Load-path shadows:
None found.

Features:
(shadow sort gnus-util mail-extr emacsbug message idna format-spec
rfc822 mml mml-sec mm-decode mm-bodies mm-encode mail-parse rfc2231
mailabbrev gmm-utils mailheader sendmail rfc2047 rfc2045 ietf-drums
mm-util help-fns mail-prsvr mail-utils jka-compr info sql view thingatpt
comint ansi-color ring cl-loaddefs cl-lib help-mode easymenu time-date
tooltip electric uniquify ediff-hook vc-hooks lisp-float-type mwheel
x-win x-dnd tool-bar dnd fontset image regexp-opt fringe tabulated-list
newcomment lisp-mode prog-mode register page menu-bar rfn-eshadow timer
select scroll-bar mouse jit-lock font-lock syntax facemenu font-core
frame cham georgian utf-8-lang misc-lang vietnamese tibetan thai
tai-viet lao korean japanese hebrew greek romanian slovak czech european
ethiopic indian cyrillic chinese case-table epa-hook jka-cmpr-hook help
simple abbrev minibuffer nadvice loaddefs button faces cus-face macroexp
files text-properties overlay sha1 md5 base64 format env code-pages mule
custom widget hashtable-print-readable backquote make-network-process
dbusbind gfilenotify dynamic-setting font-render-setting x-toolkit x
multi-tty emacs)

Memory information:
((conses 16 93916 4264)
 (symbols 48 19056 0)
 (miscs 40 127 240)
 (strings 32 17164 4195)
 (string-bytes 1 482836)
 (vectors 16 10773)
 (vector-slots 8 390040 5463)
 (floats 8 76 546)
 (intervals 56 605 19)
 (buffers 960 17)
 (heap 1024 32814 743))


-- 
Thanks,

Jonathan Kotta

Hofstadter's Law:
    It always takes longer than you expect, even
    when you take into account Hofstadter's Law.

bug#17426: 24.3.90; interactive mysql mode should support mariadb

[Lars Ingebrigtsen]

Jonathan Kotta <jpkotta@gmail.com> writes:

> 0. Have a MySQL or MariaDB server to connect to.  I'm testing with MySQL
> 5.5.37 and MariaDB 5.5.37.
> 1. M-x sql-mysql RET
> 2. Enter the database, username, password, and hostname.
> 3. The interactive SQL buffer pops up, but there is no visible prompt.
> 4. If you enter some commands (e.g. "show status;") and send them, the
> prompt will be printed in between the commands and the output from the
> database.

(I'm going through old bug reports that have unfortunately gotten no
responses yet.)

The new command `sql-mariadb' was added in 2018 in commit 61f5d6311c6,
so I think this should now work better, and I'm closing this bug report.

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no