From debbugs-submit-bounces@debbugs.gnu.org Tue May 15 12:09:36 2012 Received: (at submit) by debbugs.gnu.org; 15 May 2012 16:09:36 +0000 Received: from localhost ([127.0.0.1]:56282 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.72) (envelope-from ) id 1SUKJa-0006sX-W2 for submit@debbugs.gnu.org; Tue, 15 May 2012 12:09:35 -0400 Received: from eggs.gnu.org ([208.118.235.92]:53734) by debbugs.gnu.org with esmtp (Exim 4.72) (envelope-from ) id 1SUKFb-0006mJ-A5 for submit@debbugs.gnu.org; Tue, 15 May 2012 12:05:47 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SUKFJ-00020C-RA for submit@debbugs.gnu.org; Tue, 15 May 2012 12:05:17 -0400 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-4.4 required=5.0 tests=BAYES_00,HTML_MESSAGE, RCVD_IN_DNSWL_HI, RECEIVED_FROM_WINDOWS_HOST autolearn=ham version=3.3.2 Received: from lists.gnu.org ([208.118.235.17]:38991) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SUKFJ-000205-Nw for submit@debbugs.gnu.org; Tue, 15 May 2012 12:05:09 -0400 Received: from eggs.gnu.org ([208.118.235.92]:55711) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SUKFA-0005F3-Eo for bug-gnu-emacs@gnu.org; Tue, 15 May 2012 12:05:09 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SUKF4-0001n1-MT for bug-gnu-emacs@gnu.org; Tue, 15 May 2012 12:04:59 -0400 Received: from corp-mail.e-dialog.com ([208.94.20.29]:1422) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SUKF4-0001mo-IN for bug-gnu-emacs@gnu.org; Tue, 15 May 2012 12:04:54 -0400 Received: from tigger.ad.e-dialog.com ([::1]) by tigger.ad.e-dialog.com ([::1]) with mapi; Tue, 15 May 2012 11:44:13 -0400 From: Shannon Severance To: "bug-gnu-emacs@gnu.org" Date: Tue, 15 May 2012 11:44:29 -0400 Subject: 24.0.94; Oracle interactive SQL mode not allowing & in substitution text. Thread-Topic: 24.0.94; Oracle interactive SQL mode not allowing & in substitution text. Thread-Index: Ac0ysYrPKQzU+soUSq2Vsn7xyZwtFw== Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_F761E79CEA50DE45A8BA94078A77158F0B1C65C953tiggeradedial_" MIME-Version: 1.0 X-detected-operating-system: by eggs.gnu.org: Windows XP/2000 (RFC1323+, w+, tstamp-) X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 3) X-Received-From: 208.118.235.17 X-Spam-Score: -6.9 (------) X-Debbugs-Envelope-To: submit X-Mailman-Approved-At: Tue, 15 May 2012 12:09:33 -0400 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.13 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: debbugs-submit-bounces@debbugs.gnu.org Errors-To: debbugs-submit-bounces@debbugs.gnu.org X-Spam-Score: -6.9 (------) --_000_F761E79CEA50DE45A8BA94078A77158F0B1C65C953tiggeradedial_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Steps to reproduce: 1. Start emacs from icon installed by addpm.exe 2. M-x sql-oracle 3. Enter proper username, password & database at prompts 4. At Oracle's sql*plus prompt enter: select '&x' from dual; =3D> Emacs prompts in *Minibuf-1*, "Enter value for x: " 5. Enter &y in the mini buffer. =3D> Emacs prompts in *Minibuf-1*, "Enter value for y: " 6. Enter z in the mini buffer. =3D> In the *SQL* buffer: SQL> select '&x' from dual; ' - z Elapsed: 00:00:00.29 SQL> Expected result after step 5: SQL> select '&x' from dual; '& -- &y --- Contents of my sql*plus login.sql file: set serveroutput on size unlimited format wrapped set trimspool on set long 5000 set linesize 170 set pagesize 50000 set tab off set arraysize 100 set define off alter session set nls_date_format =3D 'SYYYY-MM-DD HH24:Mi:SS'; alter session set nls_timestamp_format =3D 'SYYYY-MM-DD HH24:Mi:SS.FF9'; alter session set nls_timestamp_tz_format =3D 'SYYYY-MM-DD HH24:Mi:SS.FF9 T= ZH:TZM'; set timing on --- End of login.sql Compare to: 1. M-x shell -- Results: Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. r:\>sqlplus sqlplus SQL*Plus: Release 11.1.0.6.0 - Production on Tue May 15 08:27:07 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. Enter user-name: sseverance Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Productio= n With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options Session altered. Session altered. Session altered. SQL> set define on SQL> select '&x' from dual; Enter value for x: &y old 1: select '&x' from dual new 1: select '&y' from dual '& -- &y Elapsed: 00:00:00.32 SQL> -- end results I found I could get the behavior I wanted by customizing Sql Oracle Scan On to off (nil), which puts the following in my init.el file: (custom-set-variables ;; custom-set-variables was added by Custom. ;; If you edit it by hand, you could mess it up, so be careful. ;; Your init file should contain only one such instance. ;; If there is more than one, they won't work right. '(column-number-mode t) '(org-src-fontify-natively t) '(org-src-preserve-indentation nil) '(org-src-window-setup (quote current-window)) '(scheme-program-name "petite") '(sql-oracle-scan-on t) '(tool-bar-mode nil) '(transient-mark-mode t)) -- end init.el snipit. In GNU Emacs 24.0.94.1 (i386-mingw-nt6.1.7601) of 2012-03-19 on MARVIN Windowing system distributor `Microsoft Corp.', version 6.1.7601 Configured using: `configure --with-gcc (4.6) --no-opt --enable-checking --cflags -ID:/devel/emacs/libs/libXpm-3.5.8/include -ID:/devel/emacs/libs/libXpm-3.5.8/src -ID:/devel/emacs/libs/libpng-dev_1.4.3-1/include -ID:/devel/emacs/libs/zlib-dev_1.2.5-2/include -ID:/devel/emacs/libs/giflib-4.1.4-1/include -ID:/devel/emacs/libs/jpeg-6b-4/include -ID:/devel/emacs/libs/tiff-3.8.2-1/include -ID:/devel/emacs/libs/gnutls-3.0.9/include' 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: ENU value of $XMODIFIERS: nil locale-coding-system: cp1252 default enable-multibyte-characters: t Major mode: SQLi[Oracle] Minor modes in effect: 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 blink-cursor-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 input: s e l e c t SPC ' Q s e t SPC d e f i n e SPC o f f o n s e l e c t SPC ' & x ' SPC f r o m SPC d u a l ; & x y C-x o x e m a c s r r e p o r t Recent messages: For information about GNU Emacs and the GNU system, type C-h C-a. Login...done Load-path shadows: None found. Features: (shadow sort gnus-util mail-extr emacsbug message format-spec rfc822 mml mml-sec mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader sendmail rfc2047 rfc2045 ietf-drums mm-util mail-prsvr mail-utils shell sql thingatpt org-info org byte-opt warnings bytecomp byte-compile cconv macroexp advice help-fns advice-preload ob-emacs-lisp ob-tangle ob-ref ob-lob ob-table org-footnote org-src ob-comint ob-keys ob ob-eval org-pcomplete pcomplete comint ansi-color ring org-list org-faces org-compat org-entities org-macs noutline outline easy-mmode regexp-opt cal-menu easymenu calendar cal-loaddefs org-install time-date tooltip ediff-hook vc-hooks lisp-float-type mwheel dos-w32 disp-table ls-lisp w32-win w32-vars tool-bar dnd fontset image fringe lisp-mode register page menu-bar rfn-eshadow timer select scroll-bar mouse jit-lock font-lock syntax facemenu font-core frame cham georgian utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean japanese hebrew greek romanian slovak czech european ethiopic indian cyrillic chinese case-table epa-hook jka-cmpr-hook help simple abbrev minibuffer button faces cus-face files text-properties overlay sha1 md5 base64 format env code-pages mule custom widget hashtable-print-readable backquote make-network-process multi-tty emacs) --_000_F761E79CEA50DE45A8BA94078A77158F0B1C65C953tiggeradedial_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Steps to reproduce:
1. Start emacs from icon installed by addpm.exe
2. M-x sql-oracle
3. Enter proper username, password & database at prompts
4. At Oracle's sql*plus prompt enter:
   select '&x' from dual;
=3D> Emacs prompts in *Minibuf-1*, "Enter value for x: "<= /div>
5. Enter &y in the mini buffer.
=3D> Emacs prompts in *Minibuf-1*, "Enter value for y: "<= /div>
6. Enter z in the mini buffer.
=3D> In the *SQL* buffer:
   SQL> select '&x' from dual;
 
   '
   -
   z
 
   Elapsed: 00:00:00.29
   SQL>
 
Expected result after step 5:
   SQL> select '&x' from dual;
 
   '&
   --
   &y
 
--- Contents of my sql*plus login.sql file:
set serveroutput on size unlimited format wrapped
set trimspool on
set long 5000
set linesize 170
set pagesize 50000
set tab off
set arraysize 100
set define off
alter session set nls_date_format =3D 'SYYYY-MM-DD HH24:Mi:SS';
alter session set nls_timestamp_format =3D 'SYYYY-MM-DD HH24:Mi:SS.FF9= ';
alter session set nls_timestamp_tz_format =3D 'SYYYY-MM-DD HH24:Mi:SS.= FF9 TZH:TZM';
set timing on
--- End of login.sql
 
Compare to:
1. M-x shell
-- Results:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.
 
r:\>sqlplus
sqlplus
 
SQL*Plus: Release 11.1.0.6.0 - Production on Tue May 15 08:27:07 2012<= /div>
 
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
Enter user-name: sseverance
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Prod= uction
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
 
 
Session altered.
 
 
Session altered.
 
 
Session altered.
 
SQL> set define on
SQL> select '&x' from dual;
Enter value for x: &y
old   1: select '&x' from dual
new   1: select '&y' from dual
 
'&
--
&y
 
Elapsed: 00:00:00.32
SQL>
-- end results
 
I found I could get the behavior I wanted by customizing Sql Oracle Sc= an
On to off (nil), which puts the following in my init.el file:
(custom-set-variables
;; custom-set-variables was added by Custom.
;; If you edit it by hand, you could mess it up, so be careful.
;; Your init file should contain only one such instance.
;; If there is more than one, they won't work right.
'(column-number-mode t)
'(org-src-fontify-natively t)
'(org-src-preserve-indentation nil)
'(org-src-window-setup (quote current-window))
'(scheme-program-name "petite")
'(sql-oracle-scan-on t)
'(tool-bar-mode nil)
'(transient-mark-mode t))
-- end init.el snipit.
 
 
In GNU Emacs 24.0.94.1 (i386-mingw-nt6.1.7601)
of 2012-03-19 on MARVIN
Windowing system distributor `Microsoft Corp.', version 6.1.7601
Configured using:
`configure --with-gcc (4.6) --no-opt --enable-checking --cflags
-ID:/devel/emacs/libs/libXpm-3.5.8/include
-ID:/devel/emacs/libs/libXpm-3.5.8/src
-ID:/devel/emacs/libs/libpng-dev_1.4.3-1/include
-ID:/devel/emacs/libs/zlib-dev_1.2.5-2/include
-ID:/devel/emacs/libs/giflib-4.1.4-1/include
-ID:/devel/emacs/libs/jpeg-6b-4/include
-ID:/devel/emacs/libs/tiff-3.8.2-1/include
-ID:/devel/emacs/libs/gnutls-3.0.9/include'
 
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: ENU
  value of $XMODIFIERS: nil
  locale-coding-system: cp1252
  default enable-multibyte-characters: t
 
Major mode: SQLi[Oracle]
 
Minor modes in effect:
  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
  blink-cursor-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 input:
<return> s e l e c t SPC ' Q <backspace> <backspace>=
<backspace> <backspace> <backspace> <backspace>= ; <backspace>
<backspace> <backspace> s e t SPC d e f i n e SPC o
f f <backspace> <backspace> <backspace> o n <retu= rn>
s e l e c t SPC ' & x ' SPC f r o m SPC d u a l ; <return> <= /div>
& x <backspace> y <return> C-x o <escape> x e m = a c
s <tab> r <tab> <backspace> <backspace> <ba= ckspace>
<backspace> <backspace> <backspace> <backspace>= ; r e
p o r t <tab> <return>
 
Recent messages:
For information about GNU Emacs and the GNU system, type C-h C-a.
Login...done
 
Load-path shadows:
None found.
 
Features:
(shadow sort gnus-util mail-extr emacsbug message format-spec rfc822 m= ml
mml-sec mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev
gmm-utils mailheader sendmail rfc2047 rfc2045 ietf-drums mm-util
mail-prsvr mail-utils shell sql thingatpt org-info org byte-opt warnin= gs
bytecomp byte-compile cconv macroexp advice help-fns advice-preload
ob-emacs-lisp ob-tangle ob-ref ob-lob ob-table org-footnote org-src
ob-comint ob-keys ob ob-eval org-pcomplete pcomplete comint ansi-color=
ring org-list org-faces org-compat org-entities org-macs noutline
outline easy-mmode regexp-opt cal-menu easymenu calendar cal-loaddefs<= /div>
org-install time-date tooltip ediff-hook vc-hooks lisp-float-type mwhe= el
dos-w32 disp-table ls-lisp w32-win w32-vars tool-bar dnd fontset image=
fringe lisp-mode register page menu-bar rfn-eshadow timer select
scroll-bar mouse jit-lock font-lock syntax facemenu font-core frame ch= am
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<= /div>
abbrev minibuffer button faces cus-face files text-properties overlay<= /div>
sha1 md5 base64 format env code-pages mule custom widget
hashtable-print-readable backquote make-network-process multi-tty emac= s)
 
--_000_F761E79CEA50DE45A8BA94078A77158F0B1C65C953tiggeradedial_-- 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 Tue Jun 24 15:41:46 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