GNU bug report logs - #17426
24.3.90; interactive mysql mode should support mariadb

Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.

Package: emacs; Severity: minor; Reported by: Jonathan Kotta <jpkotta@HIDDEN>; dated Tue, 6 May 2014 22:36:02 UTC; Maintainer for emacs is bug-gnu-emacs@HIDDEN.

Message received at submit <at> debbugs.gnu.org:


Received: (at submit) by debbugs.gnu.org; 6 May 2014 22:35:37 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Tue May 06 18:35:37 2014
Received: from localhost ([127.0.0.1]:53237 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.80)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1WhnxY-00068W-4q
	for submit <at> debbugs.gnu.org; Tue, 06 May 2014 18:35:36 -0400
Received: from eggs.gnu.org ([208.118.235.92]:50679)
 by debbugs.gnu.org with esmtp (Exim 4.80)
 (envelope-from <jpkotta@HIDDEN>) id 1Whnob-0005rr-GN
 for submit <at> debbugs.gnu.org; Tue, 06 May 2014 18:26:22 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <jpkotta@HIDDEN>) id 1WhnoV-0000nN-6a
 for submit <at> debbugs.gnu.org; Tue, 06 May 2014 18:26:16 -0400
X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org
X-Spam-Level: 
X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50,FREEMAIL_FROM,
 T_DKIM_INVALID autolearn=disabled version=3.3.2
Received: from lists.gnu.org ([2001:4830:134:3::11]:33696)
 by eggs.gnu.org with esmtp (Exim 4.71)
 (envelope-from <jpkotta@HIDDEN>) id 1WhnoV-0000nI-2U
 for submit <at> debbugs.gnu.org; Tue, 06 May 2014 18:26:15 -0400
Received: from eggs.gnu.org ([2001:4830:134:3::10]:52352)
 by lists.gnu.org with esmtp (Exim 4.71)
 (envelope-from <jpkotta@HIDDEN>) id 1WhnoT-0007Y4-H9
 for bug-gnu-emacs@HIDDEN; Tue, 06 May 2014 18:26:15 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <jpkotta@HIDDEN>) id 1WhnoR-0000mG-RG
 for bug-gnu-emacs@HIDDEN; Tue, 06 May 2014 18:26:13 -0400
Received: from mail-vc0-x231.google.com ([2607:f8b0:400c:c03::231]:34828)
 by eggs.gnu.org with esmtp (Exim 4.71)
 (envelope-from <jpkotta@HIDDEN>) id 1WhnoR-0000m4-LB
 for bug-gnu-emacs@HIDDEN; Tue, 06 May 2014 18:26:11 -0400
Received: by mail-vc0-f177.google.com with SMTP id if11so184054vcb.8
 for <bug-gnu-emacs@HIDDEN>; Tue, 06 May 2014 15:26:10 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:from:date:message-id:subject:to:content-type;
 bh=71yRr7aQyfwTpShoE4nLTQ0kYpMNuSkVj3yxSKyKlKc=;
 b=DW582h3DLJofS8+Ijssk61BJL3Gtg10ZmU/dK+r7pEFEeT1lpQBVJegaC2SL/7qGaf
 M1peEZ+vMSEFiCK7c3O5xeqWDBj28/E41MIBcrwG3OxEggy75Ih7G0t/hl+9+zwwM/NR
 R3tJ9u4Dm+x+EKyKrqKZbHJVJAyukxwNhRbGC6CJpLxcM846yE0VJ6NBeSy0n3J+e6NH
 gjhP2L1WPxJtejMFHW1Y95ULMydWUz3D5Uw8SSdK5OLRkqmgS8P72jxbQcechAl2feHl
 J2AZen9OLnBkC1Z79Ykb16wkNmDONrfkvwDgCZfv4/yDzcjaFuSQwmp/MnSH+HU4rE3K
 I46g==
X-Received: by 10.52.173.165 with SMTP id bl5mr29381111vdc.13.1399415170817;
 Tue, 06 May 2014 15:26:10 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.58.247.36 with HTTP; Tue, 6 May 2014 15:25:30 -0700 (PDT)
From: Jonathan Kotta <jpkotta@HIDDEN>
Date: Tue, 6 May 2014 17:25:30 -0500
Message-ID: <CALDneavcTkbPoXdHJ2HhshrTATh4AboD_12JOxOipP1Lac39Rg@HIDDEN>
Subject: 24.3.90; interactive mysql mode should support mariadb
To: bug-gnu-emacs@HIDDEN
Content-Type: text/plain; charset=UTF-8
X-detected-operating-system: by eggs.gnu.org: Error: Malformed IPv6 address
 (bad octet value).
X-detected-operating-system: by eggs.gnu.org: Error: Malformed IPv6 address
 (bad octet value).
X-Received-From: 2001:4830:134:3::11
X-Spam-Score: -4.0 (----)
X-Debbugs-Envelope-To: submit
X-Mailman-Approved-At: Tue, 06 May 2014 18:35:34 -0400
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <http://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <http://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <http://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -4.0 (----)

From: Jonathan Kotta <jpkotta@HIDDEN>
To: bug-gnu-emacs@HIDDEN
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.




Acknowledgement sent to Jonathan Kotta <jpkotta@HIDDEN>:
New bug report received and forwarded. Copy sent to bug-gnu-emacs@HIDDEN. Full text available.
Report forwarded to bug-gnu-emacs@HIDDEN:
bug#17426; Package emacs. Full text available.
Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.
Last modified: Fri, 31 Oct 2014 17:00:04 UTC

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997 nCipher Corporation Ltd, 1994-97 Ian Jackson.