From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Michael Mauger Newsgroups: gmane.emacs.bugs Subject: bug#6686: 24.0.50; [restore functionality] sql-mode Date: Wed, 28 Jul 2010 12:52:12 -0700 (PDT) Message-ID: <512661.97188.qm@web62501.mail.re1.yahoo.com> References: <87aaplpp6j.fsf@blind-mole.une.edu.au> <87wrsmdvct.fsf@stupidchicken.com> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: dough.gmane.org 1280419780 2842 80.91.229.12 (29 Jul 2010 16:09:40 GMT) X-Complaints-To: usenet@dough.gmane.org NNTP-Posting-Date: Thu, 29 Jul 2010 16:09:40 +0000 (UTC) Cc: Chong Yidong , 6686@debbugs.gnu.org To: Tim Cross Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Thu Jul 29 18:09:37 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 1OeVfk-0003Ix-7d for geb-bug-gnu-emacs@m.gmane.org; Thu, 29 Jul 2010 18:09:33 +0200 Original-Received: from localhost ([127.0.0.1]:42292 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OeVfh-0002Rm-EW for geb-bug-gnu-emacs@m.gmane.org; Thu, 29 Jul 2010 12:09:25 -0400 Original-Received: from [140.186.70.92] (port=57939 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OeVeC-00015N-A6 for bug-gnu-emacs@gnu.org; Thu, 29 Jul 2010 12:07:58 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OeVe7-00070F-Md for bug-gnu-emacs@gnu.org; Thu, 29 Jul 2010 12:07:51 -0400 Original-Received: from debbugs.gnu.org ([140.186.70.43]:55352) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OeVe7-00070B-LG for bug-gnu-emacs@gnu.org; Thu, 29 Jul 2010 12:07:47 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.69) (envelope-from ) id 1OeVJ7-0004Ra-DH; Thu, 29 Jul 2010 11:46:05 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Michael Mauger Original-Sender: debbugs-submit-bounces@debbugs.gnu.org Resent-To: owner@debbugs.gnu.org Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Thu, 29 Jul 2010 15:46:05 +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.128041836017064 (code B ref 6686); Thu, 29 Jul 2010 15:46:05 +0000 Original-Received: (at 6686) by debbugs.gnu.org; 29 Jul 2010 15:46:00 +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 1OeVJ1-0004RA-Oy for submit@debbugs.gnu.org; Thu, 29 Jul 2010 11:46:00 -0400 Original-Received: from web62501.mail.re1.yahoo.com ([69.147.75.93]) by debbugs.gnu.org with smtp (Exim 4.69) (envelope-from ) id 1OeCfZ-0002YS-L3 for 6686@debbugs.gnu.org; Wed, 28 Jul 2010 15:52:02 -0400 Original-Received: (qmail 97850 invoked by uid 60001); 28 Jul 2010 19:52:12 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1280346732; bh=tkABLMAj/t+lwqyGoy4SMp2cF1E8LbFGbjD8/ZUV9NU=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=iOUOuo35WNZwHhgqCCY0WvxmfAtH0PArBk4a6CtC0wh+DU9iVOLdgqmM8JrXHP+GgllAkm1jR2nfcq0L78cycjuBVtePbb+SsxlMhm3r8z9+7JAh2VlCO/mBBDU1X669b3VZpGP0SmO2MwqbogL0rDEjK0Cr4cOmamfkF4HPcMI= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=mw6MGN6+A5lqBNw23OuxLn692IpNFMT5Q//jxpM9bM3FnMSN26HpjZJYE2cWn4ZsiglmfEUddM/YMU8H3BYKZBJ6SQj9f1Y788smDwJB1oXxgl/1hqiqnITSu24CrT99NCTEtZ3D4RB6DthRRv4537SSI6AdUYBz0QNlnEX/Qgo=; X-YMail-OSG: 3ARtsfIVM1nt3RRFsz3PrHZ7FDoYTMmiHHkVRePBNBhgD4l r9Ofk0shv2GthRcFjRripLl3ZNy_AZy3qSoUb2mkVnEOTLvYbeOg0jnCL7TI 7I3Xppcuxw71jQiX88FYkFqIJexA_aI7SixDiv2Eon6jAaO9u1hduLB0ZxSB JC6USbYhrNGjK5jlVTqfUFy..L18QYddDFdm1F4VjCZHXD51jgbsMSHSJc1. OBWZhhE_ve6nP7qa2CJrM4q3na19bKaAVSdyxEBi86j_KI.urWQhzGPfAk_Z SdPOFFt24TybLz1qTuCP1iz_f6YYiKxmN7RZEdtIZ9MpKBn3cXoSE07MCJeX pRJzscvFA9XW4Gl.cBfZaY9epM0Kwig-- Original-Received: from [98.216.52.54] by web62501.mail.re1.yahoo.com via HTTP; Wed, 28 Jul 2010 12:52:12 PDT X-Mailer: YahooMailRC/420.4 YahooMailWebService/0.8.105.277674 In-Reply-To: <87wrsmdvct.fsf@stupidchicken.com> X-Mailman-Approved-At: Thu, 29 Jul 2010 11:45:59 -0400 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.11 Precedence: list Resent-Date: Thu, 29 Jul 2010 11:46:05 -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:39045 Archived-At: ----- 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.