From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Tim Cross Newsgroups: gmane.emacs.bugs Subject: bug#6686: 24.0.50; [restore functionality] sql-mode Date: Thu, 29 Jul 2010 09:51:53 +1000 (EST) Organization: University of New England Message-ID: <20100729.095153.213352561.tcross@une.edu.au> References: <87aaplpp6j.fsf@blind-mole.une.edu.au> <87wrsmdvct.fsf@stupidchicken.com> <512661.97188.qm@web62501.mail.re1.yahoo.com> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: dough.gmane.org 1280362077 24558 80.91.229.12 (29 Jul 2010 00:07:57 GMT) X-Complaints-To: usenet@dough.gmane.org NNTP-Posting-Date: Thu, 29 Jul 2010 00:07:57 +0000 (UTC) Cc: cyd@stupidchicken.com, 6686@debbugs.gnu.org To: mmaug@yahoo.com Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Thu Jul 29 02:07:55 2010 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1OeGfB-0003nq-Gk for geb-bug-gnu-emacs@m.gmane.org; Thu, 29 Jul 2010 02:07:54 +0200 Original-Received: from localhost ([127.0.0.1]:58553 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OeGfA-0003dO-ME for geb-bug-gnu-emacs@m.gmane.org; Wed, 28 Jul 2010 20:07:52 -0400 Original-Received: from [140.186.70.92] (port=55467 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OeGf3-0003dF-Q5 for bug-gnu-emacs@gnu.org; Wed, 28 Jul 2010 20:07:47 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OeGf2-0005ZF-5z for bug-gnu-emacs@gnu.org; Wed, 28 Jul 2010 20:07:45 -0400 Original-Received: from debbugs.gnu.org ([140.186.70.43]:39624) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OeGf2-0005ZA-4Y for bug-gnu-emacs@gnu.org; Wed, 28 Jul 2010 20:07:44 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.69) (envelope-from ) id 1OeGPp-0004uH-UM; Wed, 28 Jul 2010 19:52:01 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Tim Cross Original-Sender: debbugs-submit-bounces@debbugs.gnu.org Resent-To: owner@debbugs.gnu.org Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Wed, 28 Jul 2010 23:52:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 6686 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: Original-Received: via spool by 6686-submit@debbugs.gnu.org id=B6686.128036110918843 (code B ref 6686); Wed, 28 Jul 2010 23:52:01 +0000 Original-Received: (at 6686) by debbugs.gnu.org; 28 Jul 2010 23:51:49 +0000 Original-Received: from localhost ([127.0.0.1] helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OeGPc-0004ts-Bc for submit@debbugs.gnu.org; Wed, 28 Jul 2010 19:51:48 -0400 Original-Received: from mailfilter1.une.edu.au ([129.180.1.41]) by debbugs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OeGPY-0004td-Sv for 6686@debbugs.gnu.org; Wed, 28 Jul 2010 19:51:47 -0400 X-ASG-Debug-ID: 1280361113-7f5cd5330001-2Qbgtv Original-Received: from une.edu.au (blind-mole.une.edu.au [129.180.124.2]) by mailfilter1.une.edu.au with ESMTP id Chgpms0aDItOvb9m; Thu, 29 Jul 2010 09:51:53 +1000 (EST) X-Barracuda-Envelope-From: tcross@une.edu.au X-Barracuda-Apparent-Source-IP: 129.180.124.2 X-ASG-Orig-Subj: Re: bug#6686: 24.0.50; [restore functionality] sql-mode In-Reply-To: <512661.97188.qm@web62501.mail.re1.yahoo.com> X-Mailer: Mew version 7.0.50 on Emacs 23.1 / Mule 6.0 (HANACHIRUSATO) X-Barracuda-Connect: blind-mole.une.edu.au[129.180.124.2] X-Barracuda-Start-Time: 1280361113 X-Barracuda-URL: http://129.180.1.41:8000/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at une.edu.au X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using per-user scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=9.0 tests= X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.36379 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.11 Precedence: list Resent-Date: Wed, 28 Jul 2010 19:52:01 -0400 X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 3) X-BeenThere: bug-gnu-emacs@gnu.org List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.bugs:39035 Archived-At: Michael Mauger wrote ... >----- Original Message ---- > >> From: Chong Yidong >> To: Michael R. Mauger >> Cc: Tim Cross ; 6686@debbugs.gnu.org >> Sent: Fri, July 23, 2010 12:19:14 PM >> Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode >> >> Hi Michael, >> >> Could you take a look at this bug report? Thanks. >> >> >> Tim Cross writes: >> >> > The way sql-mode works in emacs has changed and while some of the >> > changes are good, there is one major change that isn't. >> > >> > In previous versions of sql-mode, running queries and executing stored >> > procedures/functions from within the sql interactive buffer did not hold >> > system focus. If the command you executed was going to take some time to >> > run, you could switch to another buffer/frame and continue working, read >> > mail, use w3m etc. However, this has now changed. When you execute an >> > SQL command or call a stored procedure/function from within the SQLi >> > buffer, you are effectively locked out from doing anything else in emacs >> > until that command has completed. I'm guessing, but suspect this change >> > is due to the additional output processing that has been added to >> > sql-mode, such as translation of tabs to spaces etc. I have disabled as >> > many features as I can, but this has made no difference. >> > >> > I am using sql-mode to access an Oracle database using sqlplus. >> > Everything works as it always has with emacs 23 and this change only >> > occured in emacs 24 either late last year or early this year. >> > >> > Could we either have the old behavior restored or if that is not >> > possible and if the change is due to other new features, have a way of >> > turning the new features off and restoring the old behavior. I really >> > want to continue using sql-mode and *really* don't want to have to give >> > it up in favor of something far less pleasant to use than emacs! >> > >> > thanks, >> > >> > Tim >> > >> > >> > In GNU Emacs 24.0.50.1 (i686-pc-linux-gnu, GTK+ Version 2.20.1) >> > of 2010-07-19 on blind-mole >> > Windowing system distributor `The X.Org Foundation', version 11.0.10706000 >> > configured using `configure '--prefix=/usr/local'' >> > >The only change that I believe impacted the handling of the command interaction >in SQLi mode > >is the use of `comint-input-sender' which may modify the text sent to the >command interpreter >before sending it. (For example, replacing TAB characters or handling >&placeholders). This > >should not cause the blocking behavior you describe. > >I have seen that behavior with code found on the net that strips out >continuation prompts on > >SQL*Plus. Is that a possible culprit? > >To be sure that the input filtering is not the cause you can: > > (sql-set-product-feature 'oracle :input-filter nil) > >The other thing you can try is to interrupt emacs under the debugger when its >blocking and >look at the backtrace. > >Beyond that, more details of your setup of SQL mode might be helpful. I'm not >seeing the same > >behavior but I don't have sqlplus available to me now. > OK, I will try the suggestion of setting input fileter to nil and see if that makes a difference. Note that I do not observe this behavior with emacs 23 and its version of sql-mode. This is on the same system, using the same configuration and the same version of sqlplus. Also note that I do not have any additional code or customizations, other than those provided by sql-mode. My sql-mode custom settings are '(sql-input-ring-file-name "~/.sql-input") '(sql-oracle-scan-on nil) '(sql-product (quote oracle)) I will let you know what I find. thanks Tim