From unknown Mon Aug 11 21:14:44 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#24483 <24483@debbugs.gnu.org> To: bug#24483 <24483@debbugs.gnu.org> Subject: Status: 25.1; sql-mode error due to nil prompt-cont-regexp Reply-To: bug#24483 <24483@debbugs.gnu.org> Date: Tue, 12 Aug 2025 04:14:44 +0000 retitle 24483 25.1; sql-mode error due to nil prompt-cont-regexp reassign 24483 emacs submitter 24483 Michael Kleehammer severity 24483 normal thanks From debbugs-submit-bounces@debbugs.gnu.org Tue Sep 20 13:49:15 2016 Received: (at submit) by debbugs.gnu.org; 20 Sep 2016 17:49:15 +0000 Received: from localhost ([127.0.0.1]:58443 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bmPAR-0000F9-Bx for submit@debbugs.gnu.org; Tue, 20 Sep 2016 13:49:15 -0400 Received: from eggs.gnu.org ([208.118.235.92]:37150) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bmPAQ-0000Ev-DF for submit@debbugs.gnu.org; Tue, 20 Sep 2016 13:49:14 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bmPAJ-0007OM-Ex for submit@debbugs.gnu.org; Tue, 20 Sep 2016 13:49:09 -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,T_DKIM_INVALID autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:51826) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bmPAJ-0007NP-BI for submit@debbugs.gnu.org; Tue, 20 Sep 2016 13:49:07 -0400 Received: from eggs.gnu.org ([2001:4830:134:3::10]:56322) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bmPAG-0007fq-7N for bug-gnu-emacs@gnu.org; Tue, 20 Sep 2016 13:49:06 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bmPAB-0007Jm-SU for bug-gnu-emacs@gnu.org; Tue, 20 Sep 2016 13:49:03 -0400 Received: from mail-oi0-x230.google.com ([2607:f8b0:4003:c06::230]:35836) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bmPAB-0007Hm-L3 for bug-gnu-emacs@gnu.org; Tue, 20 Sep 2016 13:48:59 -0400 Received: by mail-oi0-x230.google.com with SMTP id w11so31004673oia.2 for ; Tue, 20 Sep 2016 10:48:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kleehammer-com.20150623.gappssmtp.com; s=20150623; h=from:content-transfer-encoding:mime-version:subject:message-id:date :to; bh=F0+d9pUX+psrrK016vDvwIlX52N/222Ca03Tuae6j7I=; b=KJi7xzR5wmAGv15Hgxw6IgJoEmMxYvQQopoe+RncM6xFFvzsUd1WocPNEJYLIoumo1 mhORaOmBo3c9L90UgpwDXCBY9G5k8vfcYbOp9EamPOe0n1SGRnve0HM5jwcHJlVNKXZx 8BNn9FfRYnSEIbZ+SXGBPbvcdRlT3tJnUTd7J9SU69QXMf9EvNkE4WxXQhl0222xtJ8U g/fmqLpDKcNhUxvuwN6/EK/X91epWOnXztwqbG++QnlPQjGegMn6pVG0PGQuzAvWvuS6 5v6QpwGGdbbA1b1oBb8jV+Pjs/+YIx3SXa2HojhCIeO81luETMu7rFuz80H1HktEdUti 411w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:message-id:date:to; bh=F0+d9pUX+psrrK016vDvwIlX52N/222Ca03Tuae6j7I=; b=Sc1C33hJbqmLXEetd+dqOZN0PGZbZrXYI/5DZJhPFh7pAhsG1zYgLQb1q1hr/0tKWH mAGFLFGNRrAFi6Yj3XogvSoiONwL2wAURpp/ikHz75dSupP62NLYxBAmSpCw6sdC4HWA +kU3Z6uf6g5BYeZ/DGPG4YjtiXK8tSG2z1MhhxZVLcM4UyrfrPFW0M0N3k5ZGI2zFwP6 J/k9wUmRIITcJDYc7bzIGMrYnEsx0SXj6xX1bUYwH0HSvYLQTqEHgXIo4/osrgfVqbWf 6OpDDHpolRaUqeCkdfS7q+8aSs6K6XFShtx31WtEYrNH1qoEd2KYjAAF29gyAOg+wQ57 mRPA== X-Gm-Message-State: AE9vXwMDPcHTqwHTitHKzV+NOPw5z3+Zq3rVza8cRSykl6xuJ68X38WhikknjV6jDygdLg== X-Received: by 10.202.225.215 with SMTP id y206mr39365879oig.66.1474393737289; Tue, 20 Sep 2016 10:48:57 -0700 (PDT) Received: from michaels-air-2.home ([47.188.201.105]) by smtp.gmail.com with ESMTPSA id n9sm19152537oib.21.2016.09.20.10.48.56 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 20 Sep 2016 10:48:56 -0700 (PDT) From: Michael Kleehammer Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 10.0 \(3226\)) Subject: 25.1; sql-mode error due to nil prompt-cont-regexp Message-Id: <8CBA1E8F-1C4A-4113-933F-2701EB5BF769@kleehammer.com> Date: Tue, 20 Sep 2016 12:48:56 -0500 To: bug-gnu-emacs@gnu.org X-Mailer: Apple Mail (2.3226) X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -5.0 (-----) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -5.0 (-----) It looks like sql-interactive-remove-continuation-prompt needs to = explicitly check for a nil sql-prompt-cont-regexp, which is the default = value for some SQL products. In particular, this line marked with an arrow on the left needs a guard: (when (and comint-prompt-regexp (or (> (length (or sql-preoutput-hold "")) 0) (> (or sql-output-newline-count 0) 0) (not (or (string-match sql-prompt-regexp oline) --> (string-match sql-prompt-cont-regexp = oline))))) In my case I am using a custom "SQL product" for a SQL Server command line utility which prints "Connected to xyzzy\n" on startup but there are some standard "products" that also don't have a prompt-cont-regexp set. It should be easy to reproduce using "ansi", but here is how I reproduced it with PostgreSQL: 1) Set the PostgreSQL regexp to nil: (sql-set-product-feature 'postgres :prompt-cont-regexp nil) 2) Make sure psql prints something on connect. I have this in my ~/.psqlrc: \pset null =C2=A4 When you open a connection using sql-postgres you'll get: error in process filter: sql-interactive-remove-continuation-prompt: = Wrong type argument: stringp, nil error in process filter: Wrong type argument: stringp, nil This is new in 25.1. I used 24.5 and did not have this issue.=20 Thanks, Michael Kleehammer michael@kleehammer.com In GNU Emacs 25.1.1 (x86_64-apple-darwin13.4.0, NS appkit-1265.21 = Version 10.9.5 (Build 13F1911)) of 2016-09-17 built on builder10-9.porkrind.org Windowing system distributor 'Apple', version 10.3.1504 Configured using: 'configure --with-ns '--enable-locallisppath=3D/Library/Application Support/Emacs/${version}/site-lisp:/Library/Application Support/Emacs/site-lisp'' Configured features: NOTIFY ACL GNUTLS LIBXML2 ZLIB TOOLKIT_SCROLL_BARS NS Important settings: value of $LANG: en_US.UTF8 locale-coding-system: utf-8-unix Major mode: Emacs-Lisp Minor modes in effect: diff-auto-refine-mode: t magit-auto-revert-mode: t global-git-commit-mode: t shell-dirtrack-mode: t ws-butler-global-mode: t ws-butler-mode: t yas-global-mode: t yas-minor-mode: t ido-vertical-mode: t flx-ido-mode: t ido-everywhere: t global-undo-tree-mode: t undo-tree-mode: t projectile-global-mode: t projectile-mode: t recentf-mode: t pcre-mode: t drag-stuff-global-mode: t drag-stuff-mode: t delete-selection-mode: t cua-mode: t highlight-changes-visible-mode: t show-paren-mode: t global-linum-mode: t linum-mode: t override-global-mode: t global-eldoc-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 auto-composition-mode: t auto-encryption-mode: t auto-compression-mode: t column-number-mode: t line-number-mode: t transient-mark-mode: t Recent messages: buf: nil Login...done w # Quit uncompressing sql.el.gz...done Mark saved where search started Mark set Mark saved where search started [4 times] Mark set Quit Load-path shadows: /Users/mkleehammer/.emacs.d/misc/expand-region/web-mode-expansions hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/web-mode-expansions /Users/mkleehammer/.emacs.d/misc/expand-region/the-org-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/the-org-mode-expansi= ons /Users/mkleehammer/.emacs.d/misc/expand-region/text-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/text-mode-expansions= /Users/mkleehammer/.emacs.d/misc/expand-region/sml-mode-expansions hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/sml-mode-expansions /Users/mkleehammer/.emacs.d/misc/expand-region/ruby-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/ruby-mode-expansions= /Users/mkleehammer/.emacs.d/misc/expand-region/python-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/python-mode-expansio= ns = /Users/mkleehammer/.emacs.d/misc/expand-region/python-el-fgallina-expansio= ns hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/python-el-fgallina-e= xpansions /Users/mkleehammer/.emacs.d/misc/expand-region/python-el-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/python-el-expansions= /Users/mkleehammer/.emacs.d/misc/expand-region/octave-expansions hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/octave-expansions /Users/mkleehammer/.emacs.d/misc/expand-region/nxml-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/nxml-mode-expansions= /Users/mkleehammer/.emacs.d/misc/expand-region/latex-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/latex-mode-expansion= s /Users/mkleehammer/.emacs.d/misc/expand-region/jsp-expansions hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/jsp-expansions /Users/mkleehammer/.emacs.d/misc/expand-region/js2-mode-expansions hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/js2-mode-expansions /Users/mkleehammer/.emacs.d/misc/expand-region/js-mode-expansions hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/js-mode-expansions /Users/mkleehammer/.emacs.d/misc/expand-region/html-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/html-mode-expansions= /Users/mkleehammer/.emacs.d/misc/expand-region/feature-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/feature-mode-expansi= ons /Users/mkleehammer/.emacs.d/misc/expand-region/expand-region hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/expand-region /Users/mkleehammer/.emacs.d/misc/expand-region/expand-region-pkg hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/expand-region-pkg /Users/mkleehammer/.emacs.d/misc/expand-region/expand-region-custom = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/expand-region-custom= /Users/mkleehammer/.emacs.d/misc/expand-region/expand-region-core hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/expand-region-core /Users/mkleehammer/.emacs.d/misc/expand-region/erlang-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/erlang-mode-expansio= ns /Users/mkleehammer/.emacs.d/misc/expand-region/er-basic-expansions hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/er-basic-expansions /Users/mkleehammer/.emacs.d/misc/expand-region/enh-ruby-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/enh-ruby-mode-expans= ions /Users/mkleehammer/.emacs.d/misc/expand-region/css-mode-expansions hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/css-mode-expansions /Users/mkleehammer/.emacs.d/misc/expand-region/cperl-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/cperl-mode-expansion= s /Users/mkleehammer/.emacs.d/misc/expand-region/clojure-mode-expansions = hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/clojure-mode-expansi= ons /Users/mkleehammer/.emacs.d/misc/expand-region/cc-mode-expansions hides = /Users/mkleehammer/.emacs.d/elpa/expand-region-0.10.0/cc-mode-expansions /Users/mkleehammer/.emacs.d/misc/undo-tree hides = /Users/mkleehammer/.emacs.d/elpa/undo-tree-0.6.5/undo-tree /Users/mkleehammer/.emacs.d/misc/python hides = /Applications/Emacs.app/Contents/Resources/lisp/progmodes/python /Users/mkleehammer/.emacs.d/elpa/seq-2.16/seq hides = /Applications/Emacs.app/Contents/Resources/lisp/emacs-lisp/seq Features: (shadow sort mail-extr emacsbug sendmail pp timezone parse-time jka-compr shr-color color network-stream nsm starttls url-http tls gnutls url-gw url-auth eww mm-url gnus gnus-ems nnheader url-queue shr dom browse-url less-css-mode css-mode smie derived wdired web-mode disp-table dabbrev misearch multi-isearch smex magit-blame magit-stash magit-bisect magit-remote magit-commit magit-sequence magit magit-apply magit-wip magit-log magit-diff smerge-mode diff-mode magit-core magit-autorevert autorevert filenotify magit-process magit-popup magit-mode magit-git crm magit-section magit-utils git-commit log-edit message rfc822 mml mml-sec epg mm-decode mm-bodies mm-encode mail-parse rfc2231 rfc2047 rfc2045 ietf-drums mailabbrev mail-utils gmm-utils mailheader pcvs-util add-log with-editor async-bytecomp async python tramp-sh tramp tramp-compat tramp-loaddefs trampver shell format-spec dired-aux server sunshine url-cache url url-proxy url-privacy url-expand url-methods url-history url-cookie url-domsuf url-util url-parse auth-source gnus-util mm-util help-fns mail-prsvr password-cache url-vars mailcap cal-china lunar solar cal-dst cal-bahai cal-islam cal-hebrew holidays hol-loaddefs appt diary-lib diary-loaddefs cal-menu calendar cal-loaddefs sql view tea-time pcomplete esh-var esh-io esh-cmd esh-opt esh-ext esh-proc esh-arg esh-groups eshell esh-module esh-mode esh-util js2-mode etags xref project eieio eieio-core js sgml-mode cc-mode cc-fonts cc-guess cc-menus cc-cmds cc-styles cc-align cc-engine cc-vars cc-defs imenu ws-butler whitespace yasnippet cl browse-kill-ring avy ido-vertical-mode ido-ubiquitous cl-seq ido-completing-read+ cus-edit flx-ido flx ido undo-tree iedit iedit-lib flycheck json map find-func subr-x projectile ibuf-ext ibuffer dash thingatpt recentf tree-widget pcre2el rxt cl-macs re-builder rx drag-stuff whole-line-or-region align2 edmacro kmacro wgrep reveal-in-osx-finder dired-x dired exec-path-from-shell delsel cua-base hydra lv hilit-chg wid-edit paren avoid linum zenburn-theme use-package diminish bind-key easy-mmode finder-inf advice info package epg-config seq byte-opt gv bytecomp byte-compile cl-extra help-mode easymenu cconv cl-loaddefs pcase cl-lib grep compile comint ansi-color ring cus-start cus-load time-date mule-util tooltip eldoc electric uniquify ediff-hook vc-hooks lisp-float-type mwheel ns-win ucs-normalize term/common-win tool-bar dnd fontset image regexp-opt fringe tabulated-list newcomment elisp-mode lisp-mode prog-mode register page menu-bar rfn-eshadow timer select scroll-bar mouse jit-lock font-lock syntax facemenu font-core frame cl-generic cham georgian utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean japanese eucjp-ms cp51932 hebrew greek romanian slovak czech european ethiopic indian cyrillic chinese charscript case-table epa-hook jka-cmpr-hook help simple abbrev minibuffer cl-preloaded 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 kqueue cocoa ns multi-tty make-network-process emacs) Memory information: ((conses 16 764072 122496) (symbols 48 50260 0) (miscs 40 1811 957) (strings 32 147544 5627) (string-bytes 1 4555893) (vectors 16 105142) (vector-slots 8 2292082 293693) (floats 8 12056 11134) (intervals 56 19325 3290) (buffers 976 43)) From debbugs-submit-bounces@debbugs.gnu.org Fri Feb 24 14:53:53 2017 Received: (at 24483) by debbugs.gnu.org; 24 Feb 2017 19:53:53 +0000 Received: from localhost ([127.0.0.1]:54966 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1chLw9-0002nL-3d for submit@debbugs.gnu.org; Fri, 24 Feb 2017 14:53:53 -0500 Received: from mail-it0-f48.google.com ([209.85.214.48]:38421) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1chLw7-0002n4-9J for 24483@debbugs.gnu.org; Fri, 24 Feb 2017 14:53:51 -0500 Received: by mail-it0-f48.google.com with SMTP id y135so36741168itc.1 for <24483@debbugs.gnu.org>; Fri, 24 Feb 2017 11:53:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=li/aamFVBNF6o8DpbsYBjwUXvVZdVf5kLrCEz8GiNCQ=; b=K+OFNQj1MplQmo9uCfjaqlbXw4uOB8aTNGKrJ6fiw/oL0zjZYK9MTqz1KtLUBKmG+k IctowFFt3oy2EObRUMmQZLcyDDmmu2rJgQbuIGVR+KWLOceSxGDADuG/B6+jnmXYoNye nhm69fYN6uT1n3+pYyCgTXJdyXA8NOzh//7FTmVB8xlMaW/MTU93yKY6V3iHjNpDdQ0W 6vnEn312PIsPsZqFxdSXRzexBlILoA6PWq2n3lUYrWiY33XHBnAeqB8xJED9xT8BvC/+ k86wFR72kq1H0KWCKwzMLvzzfXWN4HrvQPxqH6RmaeBySZoaR+LribnMlvURi7eG//Tk CQuw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=li/aamFVBNF6o8DpbsYBjwUXvVZdVf5kLrCEz8GiNCQ=; b=lO6TqE6no7oXNHPT7woZBlipNyBTlQDqZTySbmqdvkS5b5LS0quEM7VJIZKRrX2Cj/ CjqkBQVZeDrjVLvqZ3wl9mY8w8rePOIRX2q+ZKQtw3k/OBHUk3mD2rSejUcrGGsZKY2K t/kHd3Ao5m7zl+1y0WSXuKsH9Nd5NxtGjlZceO71E8VpzV1nwuIcKsA5tgJ1c567YXaM yx7TOTsJfAUcIX01Cgd2ByMvRZY0JMJYTA56/rWnR1x53jSxibuZni/s1M9vEaDpRzoE pUDgC4DpqI6D7xya13xY9xsNGCY02Hn+wJ9UZuq/iQDv2hmVrnHKfz5BaRr6SnovvqKL 58nw== X-Gm-Message-State: AMke39k/ib7y/yTOtgzvqCiHjtlarJ6frsUsgG0zLIwD2CuFDDC+gJYWj54FWq7bkLGTDfI8dSfuCh4Ntpbh8w== X-Received: by 10.36.90.194 with SMTP id v185mr3743725ita.85.1487966025293; Fri, 24 Feb 2017 11:53:45 -0800 (PST) MIME-Version: 1.0 Received: by 10.107.132.1 with HTTP; Fri, 24 Feb 2017 11:53:44 -0800 (PST) From: =?UTF-8?Q?Pablo_Mercader_Alc=C3=A1ntara?= Date: Fri, 24 Feb 2017 15:53:44 -0400 Message-ID: Subject: bug#24483: 25.1; sql-mode error due to nil prompt-cont-regexp To: 24483@debbugs.gnu.org Content-Type: text/plain; charset=UTF-8 X-Spam-Score: 0.5 (/) X-Debbugs-Envelope-To: 24483 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: 0.5 (/) I'm having this same problem using ms-sql-server. I've been triying to make it work playing with edebug but haven't made any progress, if I find a way to work around this or something I'll place it here. In GNU Emacs 25.1.1 (x86_64-w64-mingw32) of 2016-11-15 built on LAPHROAIG Windowing system distributor 'Microsoft Corp.', version 10.0.10240 Configured using: 'configure --without-dbus --without-compress-install 'CFLAGS=-O2 -static -g3'' Configured features: XPM JPEG TIFF GIF PNG RSVG SOUND NOTIFY ACL GNUTLS LIBXML2 ZLIB TOOLKIT_SCROLL_BARS Important settings: value of $LANG: ENU locale-coding-system: cp1252 Major mode: Emacs-Lisp Minor modes in effect: diff-auto-refine-mode: t shell-dirtrack-mode: t yas-global-mode: t yas-minor-mode: t tooltip-mode: t global-eldoc-mode: t electric-indent-mode: t mouse-wheel-mode: t tool-bar-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 messages: Result: "(1 row affected)\nMsg 2812, Level 16, State 62, Server INTRANETDB, Line 1\nCould not find stored procedure 'l'.\n \n ----------- \n 1 \n\n" Wrong type argument: stringp, nil error in process filter: edebug-signal: Wrong type argument: stringp, nil error in process filter: Wrong type argument: stringp, nil Quit [2 times] Mark set [2 times] Mark saved where search started Load-path shadows: c:/Users/pmercader/AppData/Roaming/.emacs.d/elpa/cygwin-mount-20131111.1346/cygwin-mount hides d:/share/emacs/share/emacs/site-lisp/cygwin/cygwin-mount Features: (shadow sort mail-extr emacsbug message dired rfc822 mml mml-sec epg mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader sendmail rfc2047 rfc2045 ietf-drums mail-utils edebug debug eieio-opt speedbar sb-image ezimage dframe magit-utils dash rect vc-git diff-mode easy-mmode python tramp-sh tramp tramp-compat auth-source eieio eieio-core cl-macs gnus-util mm-util mail-prsvr password-cache tramp-loaddefs trampver ucs-normalize shell pcomplete format-spec advice json map find-func help-fns sql view thingatpt misearch multi-isearch vc-dispatcher vc-svn nxml-uchnm rng-xsd xsd-regexp rng-cmpct rng-nxml rng-valid rng-loc rng-uri rng-parse nxml-parse rng-match rng-dt rng-util rng-pttrn nxml-ns nxml-mode nxml-outln nxml-rap nxml-util nxml-glyph nxml-enc xmltok edmacro kmacro cus-edit cus-start cus-load wid-edit setup-cygwin cygwin-mount ange-ftp comint ansi-color ring cl-seq yasnippet misterioso-theme finder-inf info package epg-config windmove ido seq byte-opt gv bytecomp byte-compile cl-extra help-mode easymenu cconv cl-loaddefs pcase cl-lib time-date mule-util tooltip eldoc electric uniquify ediff-hook vc-hooks lisp-float-type mwheel dos-w32 ls-lisp disp-table w32-win w32-vars term/common-win tool-bar dnd fontset image regexp-opt fringe tabulated-list newcomment elisp-mode lisp-mode prog-mode register page menu-bar rfn-eshadow timer select scroll-bar mouse jit-lock font-lock syntax facemenu font-core frame cl-generic cham georgian utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean japanese eucjp-ms cp51932 hebrew greek romanian slovak czech european ethiopic indian cyrillic chinese charscript case-table epa-hook jka-cmpr-hook help simple abbrev minibuffer cl-preloaded 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 w32notify w32 multi-tty make-network-process emacs) Memory information: ((conses 16 403940 43396) (symbols 56 32319 0) (miscs 48 187 569) (strings 32 61799 11981) (string-bytes 1 1812321) (vectors 16 49325) (vector-slots 8 907506 34336) (floats 8 863 484) (intervals 56 23167 362) (buffers 976 33)) From debbugs-submit-bounces@debbugs.gnu.org Mon May 29 12:52:45 2017 Received: (at 24483) by debbugs.gnu.org; 29 May 2017 16:52:45 +0000 Received: from localhost ([127.0.0.1]:43589 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFNuP-0006cc-JQ for submit@debbugs.gnu.org; Mon, 29 May 2017 12:52:45 -0400 Received: from mail-lf0-f51.google.com ([209.85.215.51]:34844) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFNuN-0006cN-Sr for 24483@debbugs.gnu.org; Mon, 29 May 2017 12:52:44 -0400 Received: by mail-lf0-f51.google.com with SMTP id a5so37358066lfh.2 for <24483@debbugs.gnu.org>; Mon, 29 May 2017 09:52:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:subject:to:references:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=SGKSTDCgwivm+fpqn++S8boZebesOtszHrlUY/H/7Oc=; b=h+SUhK+lRj6n1U4smPXboFdMTYqZdyJ6Obcly3/x6JdlcmT45t646JeJv39U8z2YZS OwTdsrRpjwzUy7oJ3HweY4pb/0OsfH5uRPpw/twSYpz1vlW1TLAwpkVT0mGZ8v1KQpks lwh8ckkYxuJVFLOQc5NtST9GQ4ldfyhIQM9+uZLjvFF7hm6V3VfSg7X0JOq7NVIY2bM0 NVC8E34rFv9KHoKeJOoMr3V9z+la6JlIVs4CJO2lGQldgzUsxcNSukwvuX1cjWwamccS k133UmlN/KOlP3pDPtMMOwITEKhM9d5TAfHYV8EBwtZa9mi7Bno9hraIchv6BdJ9wXQR quMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:references:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=SGKSTDCgwivm+fpqn++S8boZebesOtszHrlUY/H/7Oc=; b=AUpghlO8lW2/K1YRGwYL1KfPXKP3suJ2DMLkEAm5MxoeADHUXiSo4aVsIfIgmrwI5Z ifOm+CSh6biAN7D7R55amX50RE/WwT5WAhOS/j34z9evDNH1mbIwJah6fRv2O1ZMxSlf 0BpPcH2+CV4/+vQSd+oIJnoPkfh4jXja1NPa9rcFAdXeha6YWPAmvjPoky5zNG6a3X33 9FzVZAEtaNFgNKXO0tSMQPho9udYL1ESyorg2ak4saVUONEYlILC5sSm9O75vNYYs0+0 NHtwyr0S7j3JRZ8XusuLWfsQvjEGohSWpvnggdOD4LkREuBdhlNYP8M7B8CfXpqsRboX g84g== X-Gm-Message-State: AODbwcCy3cIgeA8Dsdvit0stXYiUAnca/H80fEakKwM+Pco2GfQOinQd 5uvIR2YXoLQDwzRg X-Received: by 10.25.201.18 with SMTP id z18mr4520730lff.66.1496076757554; Mon, 29 May 2017 09:52:37 -0700 (PDT) Received: from [192.168.199.2] (broadband-95-84-209-126.moscow.rt.ru. [95.84.209.126]) by smtp.gmail.com with ESMTPSA id s74sm2101631lfe.46.2017.05.29.09.52.36 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 29 May 2017 09:52:36 -0700 (PDT) From: Nikolay Kudryavtsev X-Google-Original-From: Nikolay Kudryavtsev Subject: Re: bug#24483: 25.1; sql-mode error due to nil prompt-cont-regexp To: =?UTF-8?Q?Pablo_Mercader_Alc=c3=a1ntara?= , 24483@debbugs.gnu.org References: <8CBA1E8F-1C4A-4113-933F-2701EB5BF769@kleehammer.com> Message-ID: <32ea773d-5881-8364-1d32-0d8b03380790@gmail.com> Date: Mon, 29 May 2017 19:52:36 +0300 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US X-Spam-Score: 0.5 (/) X-Debbugs-Envelope-To: 24483 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: 0.5 (/) Hello, Pablo. I don't think you have the same bug as OP. In your case it seems that you're trying to execute some stored procedure that does not exist and Emacs fails at parsing the reply. Can you try adding: (add-to-list 'process-coding-system-alist '("sqlcmd" . cp866)) to your init and see if anything changes. Also, you're using sqlcmd, right? -- Best Regards, Nikolay Kudryavtsev From debbugs-submit-bounces@debbugs.gnu.org Mon May 29 17:10:42 2017 Received: (at 24483) by debbugs.gnu.org; 29 May 2017 21:10:42 +0000 Received: from localhost ([127.0.0.1]:43874 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFRw2-0001Ez-98 for submit@debbugs.gnu.org; Mon, 29 May 2017 17:10:42 -0400 Received: from mail-io0-f174.google.com ([209.85.223.174]:35998) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFRw0-0001Em-RR for 24483@debbugs.gnu.org; Mon, 29 May 2017 17:10:41 -0400 Received: by mail-io0-f174.google.com with SMTP id o12so46496856iod.3 for <24483@debbugs.gnu.org>; Mon, 29 May 2017 14:10:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=G2AQwEnUJ+NDtuwbB9f2XGo37mMcQ6X97ExXTDD2GQU=; b=JDTzDzURYYqF//BAL3hfj2cakb/jQWYtpqZl72KglNRRkxzcd+C5CqtrsjPi1AgNoJ bIKaH69TeGPUR5TBj/D4h10bYw76QYrNUeyJJ9HojcUHcOYdNBQ9s/Ap63NMNT9Usxhl pNZfBFU369CyktGrVoxcuab+C39lXdFehW64o3d+WlHFA+qmzPukJewxn3vV8mUCkHFQ Rh3xgw0Iac7zMJ1atXM+qBDV99kBozcHkONn3lCMoocrFQOYsearg/0OM5urS6lbLhFL 2GQTUg395/sHP0/z27dPb+icAzxKcS+ginO2n7TLRqqjWy0t5LYST4KPuIB2+Pq0H2Dg 0zhQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=G2AQwEnUJ+NDtuwbB9f2XGo37mMcQ6X97ExXTDD2GQU=; b=HdUMA+RjT0pUMYqNKXMJVYv+jCD/hDmmscPh6CmchsJrDz+Qmnt8Xvc+n3uIWl4CFL EKbNs40f3judQL5QgPeTONhOVnIZkSOJW6/1nzDOuymc9oXAj5Lr7HQzXHFDiqXfVGBi TuYpQEGzJiqri3ZTOaDQHU3mrVDyl/c11ccHM5wFwJUQnSuYqtj+mMQ2FXIrezPBuQg/ rI1yuLnYbwBKuMtGKP6lAA/ziLvZvD1lDuWVRHjsSW7oqOQJAjuO/0PhqHaAwGA+/4pD FZEUv8ObjaAGsXkjRwuBKVtOdxRMUrunjIJozX4aLuzin8NSYdHRK6MTx0CvLSm+IiAk IvsQ== X-Gm-Message-State: AODbwcAn+o0vBBg8aIyjyaxngWCMIEn4WJdeXxYiKFDp/HDixBLQviHV IuQEA7RCkZBlvmGTkqZ3H3gDLhb+PA== X-Received: by 10.107.62.139 with SMTP id l133mr15459119ioa.213.1496092235072; Mon, 29 May 2017 14:10:35 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.10.142 with HTTP; Mon, 29 May 2017 14:10:34 -0700 (PDT) In-Reply-To: <32ea773d-5881-8364-1d32-0d8b03380790@gmail.com> References: <8CBA1E8F-1C4A-4113-933F-2701EB5BF769@kleehammer.com> <32ea773d-5881-8364-1d32-0d8b03380790@gmail.com> From: =?UTF-8?Q?Pablo_Mercader_Alc=C3=A1ntara?= Date: Mon, 29 May 2017 17:10:34 -0400 Message-ID: Subject: Re: bug#24483: 25.1; sql-mode error due to nil prompt-cont-regexp To: Nikolay Kudryavtsev Content-Type: multipart/alternative; boundary="94eb2c061526390d520550b01ea6" X-Spam-Score: -2.3 (--) X-Debbugs-Envelope-To: 24483 Cc: 24483@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.3 (--) --94eb2c061526390d520550b01ea6 Content-Type: text/plain; charset="UTF-8" Hello Nikolay Kudryavtsev ! thanks for your interest in this little problem. I do think it is the same problem. I think that emacs tries to erase the sql prompt from the response and fails to do it. I'm getting the same problem that OP describes, when I open an interactive sql buffer and try to execute anything emacs answers with the error "Wrong type argument: stringp, nil" and no clue of the actual data. The moment in which I decided to report the bug might be while executing an stored procedure that doesn't exist, but this problem shows every time I execute ANYTHING, even a simple "select 1\ngo\n". You can see by your self that the "Wrong type argument" error is in the emacs output in my mail. To tell you the truth I did find a little workaround, that's why I didn't bother with the problem to much. This bug is in my "todo" list but I'm a little bussy to try to understand it and make a proper repair. What I did to workaround it using the ideas provided in the mail of the OP and watching what was happening in edebug, was to modify sql-product-alist in sql.el, the "prompt-cont-regexp" in the "ms" product was not even there, so I put the property and set it to " " ( <- a blank space) and that did the trick. It now shows the results but when showing those ms-sql-server results it always eats some spaces in the first column making the rows and the head of the rows misaligned. Also as OP said I didn't had this problem in the previous version (24.5) either. I'm using osql, and I'm already using cp850 with it, I think that's the right encoding I should use because its what the command prompt of windows is using. Why do you think I should use cp866. Thanks again! I hope this information helps. 2017-05-29 12:52 GMT-04:00 Nikolay Kudryavtsev < nikolay.kudryavtsev@gmail.com>: > Hello, Pablo. > > I don't think you have the same bug as OP. > > In your case it seems that you're trying to execute some stored procedure > that does not exist and Emacs fails at parsing the reply. > > Can you try adding: > > (add-to-list 'process-coding-system-alist '("sqlcmd" . cp866)) > > to your init and see if anything changes. Also, you're using sqlcmd, right? > > -- > Best Regards, > Nikolay Kudryavtsev > > --94eb2c061526390d520550b01ea6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hello Nikolay Kudryavtsev ! thank= s for your interest in this little problem.

I do think it is t= he same problem. I think that emacs tries to erase the sql prompt from the = response and fails to do it. I'm getting the same problem that OP descr= ibes, when I open an interactive sql buffer and try to execute anything ema= cs answers with the error "Wrong type argument: stringp, nil" and= no clue of the actual data. The moment in which I decided to report the bu= g might be while executing an stored procedure that doesn't exist, but = this problem shows every time I execute ANYTHING, even a simple "selec= t 1\ngo\n". You can see by your self that the "Wrong type argumen= t" error is in the emacs output in my mail.

To tell = you the truth I did find a little workaround, that's why I didn't b= other with the problem to much. This bug is in my "todo" list but= I'm a little bussy to try to understand it and make a proper repair. W= hat I did to workaround it using the ideas provided in the mail of the OP a= nd watching what was happening in edebug, was to modify sql-product-alist i= n sql.el, the "prompt-cont-regexp" in the "ms" product = was not even there, so I put the property and set it to " " ( <= ;- a blank space) and that did the trick. It now shows the results but when= showing those ms-sql-server results it always eats some spaces in the firs= t column making the rows and the head of the rows misaligned.

=
Also as OP said I didn't had this problem in the previous version = (24.5) either.

I'm using osql, and I'm alre= ady using cp850 with it, I think that's the right encoding I should use= because its what the command prompt of windows is using. Why do you think = I should use cp866.

Thanks again! I hope this i= nformation helps.


2017-05-29 12:52 GMT-04:00 Nikolay Kud= ryavtsev <nikolay.kudryavtsev@gmail.com>:
Hello, Pablo.

I don't think you have the same bug as OP.

In your case it seems that you're trying to execute some stored procedu= re that does not exist and Emacs fails at parsing the reply.

Can you try adding:

(add-to-list 'process-coding-system-alist '("sqlcmd" . cp= 866))

to your init and see if anything changes. Also, you're using sqlcmd, ri= ght?

--
Best Regards,
Nikolay Kudryavtsev


--94eb2c061526390d520550b01ea6-- From debbugs-submit-bounces@debbugs.gnu.org Mon May 29 17:50:33 2017 Received: (at 24483) by debbugs.gnu.org; 29 May 2017 21:50:33 +0000 Received: from localhost ([127.0.0.1]:43890 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFSYb-0003yo-7L for submit@debbugs.gnu.org; Mon, 29 May 2017 17:50:33 -0400 Received: from mail-lf0-f54.google.com ([209.85.215.54]:34225) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFSYZ-0003yb-GP for 24483@debbugs.gnu.org; Mon, 29 May 2017 17:50:31 -0400 Received: by mail-lf0-f54.google.com with SMTP id 99so39931048lfu.1 for <24483@debbugs.gnu.org>; Mon, 29 May 2017 14:50:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:subject:to:cc:references:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=RUnJMy7szh4Vgm1b/Xiwd1eOLXx9aqG7RDA5P+1OlwI=; b=c7SM8SV7VuRjZ5vZ+ZOG4k7CyBhhuukWQQyBRUj5oYtR9l6acF9amWVM4Kz51BKeir ujWMilwattCirPCrQd6v5BNEZzuMaOz89fv7+qaPsFu0opuqXNbcSUhQIdQraezqr9y3 AsuKs5lg6mqPb+Q7DtTSl4KgLGKtb/ItB9x5dhuafbI7CigZQ/JtV+QRq+NZm9M5PRsE /NktONLeTMF0rspopHjTyxP6XHaab70wpncPEHaj4BMho/FxZ8iN6/LES8QejmgDZCtd GGEohbO7Tg6Mw3ivG3CKXmjRz6QaBVASquXtslCtx/OkCiAkw3vJKEGwfcPmC6Ec1xx5 ywTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=RUnJMy7szh4Vgm1b/Xiwd1eOLXx9aqG7RDA5P+1OlwI=; b=q6RmQSZmmRwrSjKq7/lO3e3dp/PKMTwcr38V6zzLgTnJ6Ds5OVjYmsaRfbWCxHK71a EDmph4sty5da8r3nIwDtPt3JE1Pu0u/fCJ+dGoOhhfVAYkCoUou0lp9ukvFurRbRWPwD sPR94rty1lY1vKsZW5WvxPD1GnuH0SdSbmutx20o2Kgpr/sTK+dhJZri11wn/hgvWKCC YUKs7vIWKpN3EDpE4p7Shfai0bjoIoH/XRBKyQWAzAggEltmQmlx3YQvqdrj1mGnb4nr em3EY60AkAGOxKRBVkIxkQZi+sq7Fsiu3RVqiosvLH2R0jcXSP26UKBGdk3KDjA/SBtZ W3GA== X-Gm-Message-State: AODbwcCzcyQCbeO0LKbwNv9PpQW4o+TCAaTWkoEgfqzftGbGuE1pMXHA KFriv/kuACSP5FjR X-Received: by 10.46.20.81 with SMTP id 17mr5538717lju.19.1496094625208; Mon, 29 May 2017 14:50:25 -0700 (PDT) Received: from [192.168.199.2] (broadband-95-84-209-126.moscow.rt.ru. [95.84.209.126]) by smtp.gmail.com with ESMTPSA id t4sm2203537ljd.1.2017.05.29.14.50.24 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 29 May 2017 14:50:24 -0700 (PDT) From: Nikolay Kudryavtsev X-Google-Original-From: Nikolay Kudryavtsev Subject: Re: bug#24483: 25.1; sql-mode error due to nil prompt-cont-regexp To: =?UTF-8?Q?Pablo_Mercader_Alc=c3=a1ntara?= References: <8CBA1E8F-1C4A-4113-933F-2701EB5BF769@kleehammer.com> <32ea773d-5881-8364-1d32-0d8b03380790@gmail.com> Message-ID: Date: Tue, 30 May 2017 00:50:22 +0300 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US X-Spam-Score: 0.5 (/) X-Debbugs-Envelope-To: 24483 Cc: 24483@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: 0.5 (/) Oh, sorry for the cp866 suggestion, my bad, cp850 is probably right for you. If you're using osql, can you try switching to sqlcmd? Osql had been considered deprected by Microsoft for many years. Sqlcmd is freely downloadable and should be usable with any more or less modern version of SQL Server. The configuration for it that I use looks like this: (setq sql-ms-program "sqlcmd" sql-ms-options (quote ("-W" "-s" "|" "-I"))) -- Best Regards, Nikolay Kudryavtsev From debbugs-submit-bounces@debbugs.gnu.org Mon Jun 05 11:31:21 2017 Received: (at 24483) by debbugs.gnu.org; 5 Jun 2017 15:31:21 +0000 Received: from localhost ([127.0.0.1]:57756 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dHtyT-0001wI-FB for submit@debbugs.gnu.org; Mon, 05 Jun 2017 11:31:21 -0400 Received: from mail-it0-f43.google.com ([209.85.214.43]:36431) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dHtyS-0001w5-KW for 24483@debbugs.gnu.org; Mon, 05 Jun 2017 11:31:21 -0400 Received: by mail-it0-f43.google.com with SMTP id m47so65398968iti.1 for <24483@debbugs.gnu.org>; Mon, 05 Jun 2017 08:31:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=qXySQMdonGwZbZcd8VF+wF6gGWNHsnvarHCtcb+zg84=; b=rqisZro0LbjS/1zvDOsft01sVIPqX2avMVshuSgHMafJX/vLPOG9GnLN9iTOnZdPDQ TrH8d4agc94BQKwpAkPzcsYEVjGguDSJBWFgWCLyYIUU1xBghgCQ0bKl2uYAn56NQnAx vNoQmZvNGBD7rH0DNAx0WhgOhDEMto4U905B2gbcm4OoGKYiJvvnrRXwVhtBe+USLxd1 JVpLvxEd65kh55+19yh57enL55n4DwqQcys/qRHSKKAcAkz+hnK5uUpy67cJqzbZihoH O21sGj2HjWNHcKoedhTFFJGu/RmB2LKSAZcOVdfrWLYcdYE0xeEkMJKRU6rq0zqRbknY V7ng== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=qXySQMdonGwZbZcd8VF+wF6gGWNHsnvarHCtcb+zg84=; b=M4Yf7RwduZ6Is/noJkKVo8zjG3h7P5BdK3OoP6+gWQaKqgMtxvLT3ENowDj6LkITQb /9YUww5/equ3u9uQfOtq0cZN9m+IVY9J5i/Knn4iDj8Zfazvk6YDIU71Fkoo4+Oa0vyI tOxMK45DLmUaxHHEnqrPOT5zkIENLo3TUCMGMC42x3H/GNbCmG2K6JVpRFW4YXQEhXUn vvuuOmIU5cH0TnuNijWZfeEcWeR254hI2mgG99rDJBitLLpMVANv0Uni9hrHYrAXC+kH PYqv/tmkvF80rureUgMU5ZSMh92SrIoO1dyzuenq6+Ea5ifxY9qyZO8IHNkVktjjL80t 0kMg== X-Gm-Message-State: AODbwcDh+V2NZQzlgqeWHIFWDvLC9/+52fmPbyAxQganIMzr+Om6FCSk t+hQaqsDyod/ycp6KrwVbTOWhVBJitg8 X-Received: by 10.36.211.69 with SMTP id n66mr11872967itg.36.1496676674520; Mon, 05 Jun 2017 08:31:14 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.20.199 with HTTP; Mon, 5 Jun 2017 08:31:13 -0700 (PDT) In-Reply-To: References: <8CBA1E8F-1C4A-4113-933F-2701EB5BF769@kleehammer.com> <32ea773d-5881-8364-1d32-0d8b03380790@gmail.com> From: =?UTF-8?Q?Pablo_Mercader_Alc=C3=A1ntara?= Date: Mon, 5 Jun 2017 11:31:13 -0400 Message-ID: Subject: Re: bug#24483: 25.1; sql-mode error due to nil prompt-cont-regexp To: 24483@debbugs.gnu.org Content-Type: multipart/alternative; boundary="001a1149a9648770bf0551383153" X-Spam-Score: 0.5 (/) X-Debbugs-Envelope-To: 24483 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: 0.5 (/) --001a1149a9648770bf0551383153 Content-Type: text/plain; charset="UTF-8" Ok, I tried using "sqlcmd" instead of "osql" and the problem remains. Also tried using MySQL instead of MS-SQL-Server to see if I could reproduce the problem, and it has a similar problem, doesn't show any results to any query I write, but doesn't spit the "Wrong type argument: stringp, nil" message. So the problem is not the executable program used to talk to the database. I'm still beating to a problem in sql.el. Thanks for your help! 2017-05-29 17:50 GMT-04:00 Nikolay Kudryavtsev < nikolay.kudryavtsev@gmail.com>: > Oh, sorry for the cp866 suggestion, my bad, cp850 is probably right for > you. > > If you're using osql, can you try switching to sqlcmd? Osql had been > considered deprected by Microsoft for many years. Sqlcmd is freely > downloadable and should be usable with any more or less modern version of > SQL Server. The configuration for it that I use looks like this: > > (setq sql-ms-program "sqlcmd" > sql-ms-options (quote ("-W" "-s" "|" "-I"))) > > > -- > Best Regards, > Nikolay Kudryavtsev > > --001a1149a9648770bf0551383153 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Ok, I tried using "sqlcmd" instead of "osql= " and the problem remains. Also tried using MySQL instead of MS-SQL-Server to see if I could reproduce the problem, and it has a similar problem,=20 doesn't show any results to any query I write, but doesn't spit the= =20 "Wrong type argument: stringp, nil" message.

So the p= roblem is not the executable program used to talk to the database. I'm = still beating to a problem in sql.el.
Thanks for your help!


<= div class=3D"gmail_quote">2017-05-29 17:50 GMT-04:00 Nikolay Kudryavtsev <nikolay.kudryavtsev@gmail.com>:
Oh, sorry for the cp866 suggestion, my bad, cp850 is proba= bly right for you.

If you're using osql, can you try switching to sqlcmd? Osql had been co= nsidered deprected by Microsoft for many years. Sqlcmd is freely downloadab= le and should be usable with any more or less modern version of SQL Server.= The configuration for it that I use looks like this:

(setq sql-ms-program "sqlcmd"
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 sql-ms-options (quote ("-W" &q= uot;-s" "|" "-I")))


--
Best Regards,
Nikolay Kudryavtsev


--001a1149a9648770bf0551383153-- From debbugs-submit-bounces@debbugs.gnu.org Mon Jun 05 18:25:22 2017 Received: (at 24483) by debbugs.gnu.org; 5 Jun 2017 22:25:22 +0000 Received: from localhost ([127.0.0.1]:58211 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dI0R8-0007Mm-LD for submit@debbugs.gnu.org; Mon, 05 Jun 2017 18:25:22 -0400 Received: from mail-lf0-f44.google.com ([209.85.215.44]:35819) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dI0R6-0007Ma-R6 for 24483@debbugs.gnu.org; Mon, 05 Jun 2017 18:25:21 -0400 Received: by mail-lf0-f44.google.com with SMTP id p189so11850789lfe.2 for <24483@debbugs.gnu.org>; Mon, 05 Jun 2017 15:25:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:subject:to:references:cc:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=9Xd/jLW8uEl1MjA2uyZC4v44AOpcjKZFUlx8Vg+vWoU=; b=LyZg30jKqm5vtqbX3e7PmLQfirzDB6eYPWRP5IFjSkjffg3Ub5/OBO/VMg+CU7Yptj GMIO/1/LzJtsqX+QN9LRDb8FJ2GJCqIIx906fZQR+0gzfJwlmnU8JgSexOu7ZQU1n5Q1 0GiGeOitEueQx3sSnbTH8CVTjaNNk47bUsRMPnRk/jvrV19tghwqnZhWNlrDikQ+rbxt ifR8YwQOrWdfw4ZE4WR3+wcWriwGNVD81GmZhtCo246LZgYXaWorcdXDG7lmnrLLFke4 veeCWttPgKsPsVPRrLqnUiJeXDkHegMTHrOENsFEV79BgM+o60h48uDW3H8HDwnOkXQu sm7w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:references:cc:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=9Xd/jLW8uEl1MjA2uyZC4v44AOpcjKZFUlx8Vg+vWoU=; b=btd7E96uwy0pQ3mJmOoeDrryA0O1d1AiRUpjrWO0F7zYw0BMFPiPUBINlYE03d7LKK donykHiOshSWztcivi/seSztzJjnLOr80zKK7TVLjplfztlRQPsIOFztXs4rgzsAy/rl tVlw2pHpQq6I6Gh35LZD9xVPzqpgWCTsfv6a1RJ6Kp/+33fXBtGaHHiPwstnWWuVG4rv Ic1wIMom0SaG9ISkwwqBtaqbH1S5+ovdjHMYWFSJgZrST0A8N9zqoCQSS90EDgwycLeh +rSZRr5CmuyOcfJYuxZa9VRTgvyT7HokkpSmbH1vrsNNDbypU7LU3Libdlg4Wh6NY8KZ qbbg== X-Gm-Message-State: AODbwcAz+PZooSOdjNDtPVB992aFZ0n6Am9QTHyZew4389PB5TAK6l7v B2Z6A4wvA542xEt0 X-Received: by 10.46.21.11 with SMTP id s11mr5715316ljd.2.1496701514542; Mon, 05 Jun 2017 15:25:14 -0700 (PDT) Received: from [192.168.199.6] (broadband-95-84-209-126.moscow.rt.ru. [95.84.209.126]) by smtp.gmail.com with ESMTPSA id q125sm7001479ljb.18.2017.06.05.15.25.13 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 05 Jun 2017 15:25:13 -0700 (PDT) From: Nikolay Kudryavtsev X-Google-Original-From: Nikolay Kudryavtsev Subject: Re: bug#24483: 25.1; sql-mode error due to nil prompt-cont-regexp To: =?UTF-8?Q?Pablo_Mercader_Alc=c3=a1ntara?= References: <8CBA1E8F-1C4A-4113-933F-2701EB5BF769@kleehammer.com> <32ea773d-5881-8364-1d32-0d8b03380790@gmail.com> Message-ID: <8bc9714d-782e-6302-9753-0569d6406c2c@gmail.com> Date: Tue, 6 Jun 2017 01:25:12 +0300 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US X-Spam-Score: 0.5 (/) X-Debbugs-Envelope-To: 24483 Cc: 24483@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: 0.5 (/) Hello, Pablo. It's not clear from your letter whether you still have an error with prompt-cont-regexp when using sqlcmd. If so, could you please set debug-on-error to t and paste the debug log here. For mysql I use (setq sql-mysql-options '("-C" "-f" "-t" "-n")). Also don't forget the statement terminator there: either put ";" or "\go" at the end query. -- Best Regards, Nikolay Kudryavtsev From debbugs-submit-bounces@debbugs.gnu.org Wed Jul 05 12:57:52 2017 Received: (at control) by debbugs.gnu.org; 5 Jul 2017 16:57:52 +0000 Received: from localhost ([127.0.0.1]:53632 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dSnce-00038O-1p for submit@debbugs.gnu.org; Wed, 05 Jul 2017 12:57:52 -0400 Received: from eggs.gnu.org ([208.118.235.92]:46299) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dSncc-00038C-HO for control@debbugs.gnu.org; Wed, 05 Jul 2017 12:57:50 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dSncW-0003wb-Gw for control@debbugs.gnu.org; Wed, 05 Jul 2017 12:57:45 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,RP_MATCHES_RCVD autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:36644) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dSncW-0003wV-Er for control@debbugs.gnu.org; Wed, 05 Jul 2017 12:57:44 -0400 Received: from rgm by fencepost.gnu.org with local (Exim 4.82) (envelope-from ) id 1dSncW-0006Kv-4S for control@debbugs.gnu.org; Wed, 05 Jul 2017 12:57:44 -0400 Subject: control message for bug 27586 To: X-Mailer: mail (GNU Mailutils 2.99.98) Message-Id: From: Glenn Morris Date: Wed, 05 Jul 2017 12:57:44 -0400 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -5.0 (-----) X-Debbugs-Envelope-To: control X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -5.0 (-----) merge 24483 27586 From debbugs-submit-bounces@debbugs.gnu.org Sun Apr 21 02:02:58 2019 Received: (at control) by debbugs.gnu.org; 21 Apr 2019 06:02:58 +0000 Received: from localhost ([127.0.0.1]:47300 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hI5Z4-0001aM-Bd for submit@debbugs.gnu.org; Sun, 21 Apr 2019 02:02:58 -0400 Received: from mail4.protonmail.ch ([185.70.40.27]:41959) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1hI5Z1-0001a6-IV for control@debbugs.gnu.org; Sun, 21 Apr 2019 02:02:57 -0400 Date: Sun, 21 Apr 2019 06:02:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=default; t=1555826568; bh=nAoozreqsFDRnjPpR3zIY1QLcg0pc9ym4j0YiqefP9o=; h=Date:To:From:Reply-To:Subject:Feedback-ID:From; b=NegChC/naIyUpeMpXwRhcLVQX1DxnDxELsnkP7lo5q1VqkkIY0xNaNjShB0SOEFvi rhCZMbDhZY8a3BVPq6dPClG4W+onXW0BfnWWL7ER3V5h53CeTVntOmYvALo9a/5OKV aONEc0sYx4BKdY667eVGk43MezP2orkRizMpjVOo= To: "control@debbugs.gnu.org" From: Michael Mauger Subject: Close bugs Message-ID: Feedback-ID: b6CpL0MxcIA6fpHRkn3ZHzWS0Hoqxbtv_SrHfEzC9D85cLvnRsVk4rKaAOJUw48iy20W0W1VX4whjBYFluIX0w==:Ext:ProtonMail MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, score=-1.2 required=7.0 tests=ALL_TRUSTED,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,FREEMAIL_FROM autolearn=ham autolearn_force=no version=3.4.2 X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on mail.protonmail.ch X-Spam-Score: -0.7 (/) X-Debbugs-Envelope-To: control X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-To: Michael Mauger Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.7 (-) # placeholder close 11481 27.0.50 # missing prompt-cont-regexp handling close 24483 27.0.50 # postgres password prompt tag 18066 + unreproducible moreinfo tag 18240 + unreproducible moreinfo tag 20288 + unreproducible moreinfo tag 20289 + unreproducible moreinfo notabug tag 23063 + unreproducible moreinfo tag 29105 + unreproducible moreinfo tag 3569 + notabug close 3569 close 14759 26.1 tag 15202 + notabug tag 22016 + unreproducible moreinfo close 22106 26.1 close 30247 27.0.50 thank you -- MICHAEL@MAUGER.COM // FSF and EFF member // GNU Emacs sql.el maintainer From unknown Mon Aug 11 21:14:44 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Sun, 19 May 2019 11:24:07 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator