bug#53714: 29.0.50; pabbrev, sql-postgres: on TAB weird behavior

bug#53714: 29.0.50; pabbrev, sql-postgres: on TAB weird behavior

[Jean Louis]

I am using M-x sql-postgres and pabbrev mode. Recently I can observe
something I have not seen ever before. Video on the below link will show
the behavior.

https://gnu.support/images/tmp/2022-02-02-04:22:38.ogv

Thus if there is already a word in pabbrev database such as "hyobjects"
I can then press TAB at: "select hyTAB" and it will expand, but if the
word is not known to pabbrev, such as one beginning with "po" as shown
on video, then when I press TAB here: "select poTAB" then by pressing
TAB cursor moves even before the begin of the line and sometimes all of
the line is moved quite distant from begining of the line. 



In GNU Emacs 29.0.50 (build 2, x86_64-pc-linux-gnu, X toolkit, cairo version 1.17.4, Xaw3d scroll bars)
 of 2022-01-29 built on protected.rcdrun.com
Repository revision: 7e17749ada101fbfb772a79deda5f7087ba9e96d
Repository branch: master
Windowing system distributor 'The X.Org Foundation', version 11.0.12101003
System Description: Parabola GNU/Linux-libre

Configured using:
 'configure --with-x-toolkit=lucid'

Configured features:
ACL CAIRO DBUS FREETYPE GIF GLIB GMP GNUTLS GPM GSETTINGS HARFBUZZ JPEG
JSON LCMS2 LIBOTF LIBSYSTEMD LIBXML2 M17N_FLT MODULES NOTIFY INOTIFY
PDUMPER PNG RSVG SECCOMP SOUND SQLITE3 THREADS TIFF TOOLKIT_SCROLL_BARS
WEBP X11 XAW3D XDBE XIM XPM LUCID ZLIB

Important settings:
  value of $LC_ALL: en_US.UTF-8
  value of $LANG: de_DE.UTF-8
  value of $XMODIFIERS: @im=exwm-xim
  locale-coding-system: utf-8-unix

Major mode: Lisp Interaction

Minor modes in effect:
  tooltip-mode: t
  global-eldoc-mode: t
  eldoc-mode: t
  show-paren-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
  indent-tabs-mode: t
  transient-mark-mode: t

Load-path shadows:
None found.

Features:
(shadow sort mail-extr emacsbug message mailcap yank-media rmc puny
dired dired-loaddefs rfc822 mml mml-sec password-cache epa derived epg
rfc6068 epg-config gnus-util text-property-search time-date seq gv
subr-x byte-opt bytecomp byte-compile cconv mm-decode mm-bodies
mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader cl-loaddefs
cl-lib sendmail rfc2047 rfc2045 ietf-drums mm-util mail-prsvr mail-utils
iso-transl tooltip eldoc paren electric uniquify ediff-hook vc-hooks
lisp-float-type elisp-mode mwheel term/x-win x-win term/common-win x-dnd
tool-bar dnd fontset image regexp-opt fringe tabulated-list replace
newcomment text-mode lisp-mode prog-mode register page tab-bar menu-bar
rfn-eshadow isearch easymenu timer select scroll-bar mouse jit-lock
font-lock syntax font-core term/tty-colors frame minibuffer 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 composite emoji-zwj charscript
charprop case-table epa-hook jka-cmpr-hook help simple abbrev obarray
cl-preloaded nadvice button loaddefs faces cus-face macroexp files
window text-properties overlay sha1 md5 base64 format env code-pages
mule custom widget keymap hashtable-print-readable backquote threads
dbusbind inotify lcms2 dynamic-setting system-font-setting
font-render-setting cairo x-toolkit x multi-tty make-network-process
emacs)

Memory information:
((conses 16 46007 8464)
 (symbols 48 6212 3)
 (strings 32 17431 1634)
 (string-bytes 1 541351)
 (vectors 16 11685)
 (vector-slots 8 162941 45243)
 (floats 8 22 46)
 (intervals 56 248 0)
 (buffers 992 11))

-- 
Thanks,
Jean Louis

Take action in Free Software Foundation campaigns:
https://www.fsf.org/campaigns

bug#53714: 29.0.50; pabbrev, sql-postgres: on TAB weird behavior

[Lars Ingebrigtsen]

Jean Louis <bugs@gnu.support> writes:

> Thus if there is already a word in pabbrev database such as "hyobjects"
> I can then press TAB at: "select hyTAB" and it will expand, but if the
> word is not known to pabbrev, such as one beginning with "po" as shown
> on video, then when I press TAB here: "select poTAB" then by pressing
> TAB cursor moves even before the begin of the line and sometimes all of
> the line is moved quite distant from begining of the line. 

Perhaps the pabbrev author has some comments; added to the CCs.

-- 
(domestic pets only, the antidote for overdose, milk.)
   bloggy blog: http://lars.ingebrigtsen.no