GNU bug report logs - #6686
24.0.50; [restore functionality] sql-mode

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 6686 in the body.
You can then email your comments to 6686 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

Message #5 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Tim Cross <tcross <at> une.edu.au>
To: bug-gnu-emacs <at> gnu.org
Subject: 24.0.50; [restore functionality] sql-mode
Date: Wed, 21 Jul 2010 12:02:44 +1000

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''

Important settings:
  value of $LC_ALL: nil
  value of $LC_COLLATE: nil
  value of $LC_CTYPE: nil
  value of $LC_MESSAGES: nil
  value of $LC_MONETARY: nil
  value of $LC_NUMERIC: nil
  value of $LC_TIME: nil
  value of $LANG: en_AU.utf8
  value of $XMODIFIERS: nil
  locale-coding-system: utf-8-unix
  default enable-multibyte-characters: t

Major mode: SQLi[Oracle]

Minor modes in effect:
  show-paren-mode: t
  w3m-fb-mode: t
  display-time-mode: t
  shell-dirtrack-mode: t
  tooltip-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
  size-indication-mode: t
  transient-mark-mode: t
  abbrev-mode: t

Recent input:
<return> u n e p r o <return> M-x r e p o r t - e m 
a <tab> b u <tab> <return>

Recent messages:
Restoring clock data
Loading /home/tcross/.emacs.d/org-clock-save.el (source)...done
Mapping tables: 96%
Mapping tables: 99% [3 times]
Mapping tables: done
OVERVIEW
FOLDED
(No changes need to be saved)
Emacspeak pronunciations have been re-activated in this buffer
Login...done

Load-path shadows:
/home/tcross/bzr/vm/compiler-fixes/lisp/tapestry hides /home/tcross/git/emacspeak/lisp/tapestry
/usr/share/emacs23/site-lisp/wget-el/lpath hides /usr/share/emacs/site-lisp/auctex/lpath
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex-fptex hides /usr/share/emacs/site-lisp/auctex/tex-fptex
/usr/local/share/emacs/24.0.50/site-lisp/auctex/bib-cite hides /usr/share/emacs/site-lisp/auctex/bib-cite
/usr/local/share/emacs/24.0.50/site-lisp/auctex/context-nl hides /usr/share/emacs/site-lisp/auctex/context-nl
/usr/local/share/emacs/24.0.50/site-lisp/auctex/latex hides /usr/share/emacs/site-lisp/auctex/latex
/usr/local/share/emacs/24.0.50/site-lisp/auctex/texmathp hides /usr/share/emacs/site-lisp/auctex/texmathp
/usr/local/share/emacs/24.0.50/site-lisp/auctex/font-latex hides /usr/share/emacs/site-lisp/auctex/font-latex
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex-fold hides /usr/share/emacs/site-lisp/auctex/tex-fold
/usr/local/share/emacs/24.0.50/site-lisp/auctex/multi-prompt hides /usr/share/emacs/site-lisp/auctex/multi-prompt
/usr/local/share/emacs/24.0.50/site-lisp/auctex/context hides /usr/share/emacs/site-lisp/auctex/context
/usr/local/share/emacs/24.0.50/site-lisp/auctex/context-en hides /usr/share/emacs/site-lisp/auctex/context-en
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex-bar hides /usr/share/emacs/site-lisp/auctex/tex-bar
/usr/local/share/emacs/24.0.50/site-lisp/auctex/toolbar-x hides /usr/share/emacs/site-lisp/auctex/toolbar-x
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex-info hides /usr/share/emacs/site-lisp/auctex/tex-info
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex-jp hides /usr/share/emacs/site-lisp/auctex/tex-jp
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex-font hides /usr/share/emacs/site-lisp/auctex/tex-font
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex-buf hides /usr/share/emacs/site-lisp/auctex/tex-buf
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex-mik hides /usr/share/emacs/site-lisp/auctex/tex-mik
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex hides /usr/share/emacs/site-lisp/auctex/tex
/usr/local/share/emacs/24.0.50/site-lisp/auctex/tex-style hides /usr/share/emacs/site-lisp/auctex/tex-style
/usr/share/emacs23/site-lisp/flim/hex-util hides /usr/local/share/emacs/24.0.50/lisp/hex-util
/usr/share/emacs23/site-lisp/flim/sha1 hides /usr/local/share/emacs/24.0.50/lisp/sha1
/usr/share/emacs23/site-lisp/flim/md4 hides /usr/local/share/emacs/24.0.50/lisp/md4
/home/tcross/git/emacspeak/lisp/g-client/json hides /usr/local/share/emacs/24.0.50/lisp/json
/usr/share/emacs23/site-lisp/dictionaries-common/flyspell hides /usr/local/share/emacs/24.0.50/lisp/textmodes/flyspell
/usr/share/emacs23/site-lisp/dictionaries-common/ispell hides /usr/local/share/emacs/24.0.50/lisp/textmodes/ispell
/home/tcross/.elisp/cperl-mode hides /usr/local/share/emacs/24.0.50/lisp/progmodes/cperl-mode
/usr/share/emacs23/site-lisp/flim/ntlm hides /usr/local/share/emacs/24.0.50/lisp/net/ntlm
/usr/share/emacs23/site-lisp/flim/hmac-def hides /usr/local/share/emacs/24.0.50/lisp/net/hmac-def
/usr/share/emacs23/site-lisp/flim/sasl-ntlm hides /usr/local/share/emacs/24.0.50/lisp/net/sasl-ntlm
/usr/share/emacs23/site-lisp/flim/hmac-md5 hides /usr/local/share/emacs/24.0.50/lisp/net/hmac-md5
/usr/share/emacs23/site-lisp/flim/sasl hides /usr/local/share/emacs/24.0.50/lisp/net/sasl
/usr/share/emacs23/site-lisp/flim/sasl-digest hides /usr/local/share/emacs/24.0.50/lisp/net/sasl-digest
/usr/share/emacs23/site-lisp/flim/sasl-cram hides /usr/local/share/emacs/24.0.50/lisp/net/sasl-cram

Features:
(shadow sort mail-extr emacspeak-message message rfc822 mml mml-sec
mm-decode mm-bodies mm-encode mail-parse rfc2231 rfc2047 rfc2045
ietf-drums mailabbrev mail-utils gmm-utils mailheader emacsbug
emacspeak-ansi-color ansi-color tabify org-table org-wl org-w3m org-vm
org-rmail org-mhe org-mew org-irc org-jsinfo org-infojs org-html org-exp
org-exp-blocks org-agenda org-info org-gnus org-docview org-bibtex
org-bbdb package saveplace paren server tx-fold tx-registers edmacro
emacspeak-kmacro kmacro list-register txutils tx-eudc eudcb-ldap eudc
emacspeak-eudc emacspeak-custom cus-edit cus-start eudc-vars ldap
tx-plsql plsql align emacspeak-imenu imenu tx-sql emacspeak-sql sql
assoc tx-org org-clock remember org-remember org-datetree emacspeak-org
org org-footnote org-src org-list org-faces org-compat org-entities
org-macs tx-mode-compile tx-bmk-mgr bmk-mgr-w3m emacspeak-w3m w3m-form
emacspeak-m-player emacspeak-we w3m doc-view jka-compr image-mode
w3m-hist w3m-fb w3m-ems w3m-ccl ccl w3m-favicon w3m-image w3m-proc
w3m-util emacspeak-bmk-mgr bmk-mgr emacspeak-outline foldout noutline
outline easy-mmode tc-w3m tc-timestamp tc-template emacspeak-tempo tempo
tc-keys tx-funcs tc-diary appt cal-china lunar solar cal-dst cal-bahai
cal-islam cal-hebrew holidays hol-loaddefs diary-lib diary-loaddefs
emacspeak-calendar cal-menu calendar cal-loaddefs time tc-browse-url
tc-abbrev tx-utils boxquote rect protocols services tld vm-autoloads
vm-vars vm-version generic-x emacspeak-generic generic dired-x dired-aux
emacspeak-dired emacspeak-desktop desktop dired ls-lisp debian-el
debian-el-loaddefs w3m-wget w3m-load path-util poe pym static apel-ver
product develock bbdb-autoloads preview-latex emacspeak-auctex tex-site
auto-loads emacspeak-setup emacspeak-aumix emacspeak-forms forms-mode
forms emacspeak-webspace gweb greader g-auth derived emacspeak-webmarks
emacspeak-xslt emacspeak-webutils browse-url gfeeds g-utils json url
url-proxy url-privacy url-expand url-methods url-history url-cookie
url-util timezone mailcap url-parse auth-source gnus-util url-vars
mm-util mail-prsvr emacspeak-alsaplayer emacspeak-amark
emacspeak-replace emacspeak-advice shell comint ring emacspeak-redefine
emacspeak-personality byte-opt warnings bytecomp byte-compile emacspeak
emacspeak-widget emacspeak-view emacspeak-facemenu
emacspeak-fix-interactive emacspeak-buff-menu g-cus-load cus-load
regexp-opt emacspeak-sounds emacspeak-preamble emacspeak-keymap
emacspeak-speak time-date emacspeak-pronounce dtk-speak flite-voices
dtk-unicode descr-text help-mode easymenu view dtk-interp voice-setup
dectalk-voices espeak-voices multispeech-voices outloud-voices
acss-structure emacspeak-load-path thingatpt wid-edit advice help-fns
advice-preload vc-git cl cl-19 tooltip ediff-hook vc-hooks
lisp-float-type mwheel x-win x-dnd tool-bar dnd fontset image fringe
lisp-mode register page menu-bar rfn-eshadow timer select scroll-bar
mldrag 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 loaddefs button minibuffer faces cus-face files text-properties
overlay md5 base64 format env code-pages mule custom widget
hashtable-print-readable backquote make-network-process dbusbind
dynamic-setting system-font-setting font-render-setting gtk x-toolkit x
multi-tty emacs)

-- 
Tim Cross
Information Technology 
University of New England
 Phone: +61 2 6773 3210
Mobile: 0428 212217
   Fax: +61 2 6773 3424
E-Mail: tcross <at> une.edu.au
   Web: http://www.une.edu.au/itd
---
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html

"Social Engineering - because there is no patch for human stupidity."

Never provide your password via email. UNE will never request it and any
organisation that does is not one you want to do business with. Any email that
appears to be from UNE and requests your password is a fake and should never
be responded to. Delete it.

Message #8 received at 6686 <at> debbugs.gnu.org (full text, mbox):

From: Chong Yidong <cyd <at> stupidchicken.com>
To: "Michael R. Mauger"  <mmaug <at> yahoo.com>
Cc: Tim Cross <tcross <at> une.edu.au>, 6686 <at> debbugs.gnu.org
Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
Date: Fri, 23 Jul 2010 12:19:14 -0400

Hi Michael,

Could you take a look at this bug report?  Thanks.


Tim Cross <tcross <at> une.edu.au> 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''

Message #11 received at 6686 <at> debbugs.gnu.org (full text, mbox):

From: Tim Cross <tcross <at> une.edu.au>
To: mmaug <at> yahoo.com
Cc: cyd <at> stupidchicken.com, 6686 <at> debbugs.gnu.org
Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
Date: Thu, 29 Jul 2010 09:51:53 +1000 (EST)

 Michael Mauger <mmaug <at> yahoo.com> wrote ...
>----- Original Message ----
>
>> From: Chong Yidong <cyd <at> stupidchicken.com>
>> To: Michael R. Mauger <mmaug <at> yahoo.com>
>> Cc: Tim Cross <tcross <at> une.edu.au>; 6686 <at> 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 <tcross <at> une.edu.au> 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

Message #14 received at 6686 <at> debbugs.gnu.org (full text, mbox):

From: Tim Cross <tcross <at> une.edu.au>
To: mmaug <at> yahoo.com
Cc: cyd <at> stupidchicken.com, 6686 <at> debbugs.gnu.org
Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
Date: Thu, 29 Jul 2010 10:53:41 +1000 (EST)

 Michael Mauger <mmaug <at> yahoo.com> wrote ...
>
>Here's another option: attached is the version of sql.el found in Emacs 23.  
>Load 
>
>this rather than the E24 version and see if you see the same behavior.  If you 
>do
>then this is an E24 bug, else I've got some debugging to do...
>

Thanks Michael. I will try an do some testing early next week and will let you
know what I find. Actually, after your response, I was going to do exactly
what you suggest. It is quite possible the behavior is due to something else
that has changed in emacs 24, though nothing jumped out at me from a quick
scan of the change logs.

tim

Message #17 received at 6686 <at> debbugs.gnu.org (full text, mbox):

From: Michael Mauger <mmaug <at> yahoo.com>
To: Tim Cross <tcross <at> une.edu.au>
Cc: Chong Yidong <cyd <at> stupidchicken.com>, 6686 <at> debbugs.gnu.org
Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
Date: Wed, 28 Jul 2010 12:52:12 -0700 (PDT)

----- Original Message ----

> From: Chong Yidong <cyd <at> stupidchicken.com>
> To: Michael R. Mauger <mmaug <at> yahoo.com>
> Cc: Tim Cross <tcross <at> une.edu.au>; 6686 <at> 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 <tcross <at> une.edu.au> 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.

Message #20 received at 6686 <at> debbugs.gnu.org (full text, mbox):

From: Michael Mauger <mmaug <at> yahoo.com>
To: Tim Cross <tcross <at> une.edu.au>
Cc: cyd <at> stupidchicken.com, 6686 <at> debbugs.gnu.org
Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
Date: Wed, 28 Jul 2010 17:34:54 -0700 (PDT)

[Message part 1 (text/plain, inline)]

Tim Cross <tcross <at> une.edu.au> wrote:


> To: mmaug <at> yahoo.com
> Cc: 6686 <at> debbugs.gnu.org; cyd <at> stupidchicken.com
> Sent: Wed, July 28, 2010 7:51:53 PM
> Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
> 
> Michael Mauger <mmaug <at> yahoo.com> wrote ...
> >-----  Original Message ----
> >
> >> From: Chong Yidong <cyd <at> stupidchicken.com>
> >>  To: Michael R. Mauger <mmaug <at> yahoo.com>
> >> Cc: Tim Cross  <tcross <at> une.edu.au>; 6686 <at> 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 <tcross <at> une.edu.au> 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

Here's another option: attached is the version of sql.el found in Emacs 23.  
Load 

this rather than the E24 version and see if you see the same behavior.  If you 
do
then this is an E24 bug, else I've got some debugging to do...

[sql.el (application/octet-stream, attachment)]

Message #23 received at 6686 <at> debbugs.gnu.org (full text, mbox):

From: Michael Mauger <mmaug <at> yahoo.com>
To: Tim Cross <tcross <at> une.edu.au>
Cc: cyd <at> stupidchicken.com, 6686 <at> debbugs.gnu.org
Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
Date: Tue, 3 Aug 2010 18:11:37 -0700 (PDT)

----- Original Message ----

> From: Tim Cross <tcross <at> une.edu.au>
> To: mmaug <at> yahoo.com
> Cc: 6686 <at> debbugs.gnu.org; cyd <at> stupidchicken.com
> Sent: Wed, July 28, 2010 8:53:41 PM
> Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
> 
> Michael Mauger <mmaug <at> yahoo.com> wrote  ...
> >
> >Here's another option: attached is the version of sql.el  found in Emacs 23.  

> >Load 
> >
> >this rather than the E24  version and see if you see the same behavior.  If 
>you 
>
> >do
> >then this is an E24 bug, else I've got some debugging to  do...
> >
> 
> Thanks Michael. I will try an do some testing early next  week and will let 
you
> know what I find. Actually, after your response, I was  going to do exactly
> what you suggest. It is quite possible the behavior is  due to something else
> that has changed in emacs 24, though nothing jumped out  at me from a quick
> scan of the change logs.
> 
> tim
>

I think what's wrong is the setting:

 (setq comint-process-echoes t)

in `sql-interactive-mode'; Just comment out that line.

I'm not sure why I added that, I'll have to check my notes.  See if that helps.

-Michael

Message #26 received at 6686 <at> debbugs.gnu.org (full text, mbox):

From: Tim Cross <tcross <at> une.edu.au>
To: mmaug <at> yahoo.com
Cc: cyd <at> stupidchicken.com, 6686 <at> debbugs.gnu.org
Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
Date: Thu, 05 Aug 2010 09:43:59 +1000 (EST)

 Michael Mauger <mmaug <at> yahoo.com> wrote ...
>----- Original Message ----
>
>> From: Tim Cross <tcross <at> une.edu.au>
>> To: mmaug <at> yahoo.com
>> Cc: 6686 <at> debbugs.gnu.org; cyd <at> stupidchicken.com
>> Sent: Wed, July 28, 2010 8:53:41 PM
>> Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
>> 
>> Michael Mauger <mmaug <at> yahoo.com> wrote  ...
>> >
>> >Here's another option: attached is the version of sql.el  found in Emacs 23.  
>
>> >Load 
>> >
>> >this rather than the E24  version and see if you see the same behavior.  If 
>>you 
>>
>> >do
>> >then this is an E24 bug, else I've got some debugging to  do...
>> >
>> 
>> Thanks Michael. I will try an do some testing early next  week and will let 
>you
>> know what I find. Actually, after your response, I was  going to do exactly
>> what you suggest. It is quite possible the behavior is  due to something else
>> that has changed in emacs 24, though nothing jumped out  at me from a quick
>> scan of the change logs.
>> 
>> tim
>>
>
>I think what's wrong is the setting:
>
> (setq comint-process-echoes t)
>
>in `sql-interactive-mode'; Just comment out that line.
>
>I'm not sure why I added that, I'll have to check my notes.  See if that helps.
>
Thanks Michael. Was about to try your suggestion, but figured I should do it
with the latest dev sources. However, there appears to be an issue in sysdep.c
in the current HEAD which causes emacs to bail with an error when doing the
build. Will wait until somebody fixes the problem so that I can build with
latest snapshot. 

Tim

Message #29 received at 6686 <at> debbugs.gnu.org (full text, mbox):

From: Tim Cross <tcross <at> une.edu.au>
To: Michael Mauger <mmaug <at> yahoo.com>
Cc: Tim Cross <tcross <at> une.edu.au>, cyd <at> stupidchicken.com, 6686 <at> debbugs.gnu.org
Subject: Re: bug#6686: 24.0.50; [restore functionality] sql-mode
Date: Mon, 9 Aug 2010 11:07:42 +1000

Michael Mauger writes:
 > 
 > I think what's wrong is the setting:
 > 
 >  (setq comint-process-echoes t)
 > 
 > in `sql-interactive-mode'; Just comment out that line.
 > 
 > I'm not sure why I added that, I'll have to check my notes.  See if that helps.
 > 

Hi Michael,

yep, that seems to have fixed it. In fact, not only has it fixed the problem
of sql interactive mode grabbing emacs, it has also fixed some issues I was
having which I thought were something to do with emacspeak. Now all is working
brilliantly. Thanks for the effort. I now consider my bug resolved. 

Tim

-- 
Tim Cross
Information Technology 
University of New England
 Phone: +61 2 6773 3210
Mobile: 0428 212217
   Fax: +61 2 6773 3424
E-Mail: tcross <at> une.edu.au
   Web: http://www.une.edu.au/itd
---
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html

"Social Engineering - because there is no patch for human stupidity."

Never provide your password via email. UNE will never request it and any
organisation that does is not one you want to do business with. Any email that
appears to be from UNE and requests your password is a fake and should never
be responded to. Delete it.

Previous Next

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