Announcement

Announcement Module
Collapse
No announcement yet.

MySQL client does not support deletes via delete key

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL client does not support deletes via delete key

    Description:
    In interactive mode, mysql client does not support deleting of typos via delete key. mysql client from Oracle supports this.

    ./mysql --version
    ./mysql Ver 14.14 Distrib 5.5.13, for Linux (x86_64) using EditLine wrapper

    How to repeat:
    Open mysql client.
    Type in some text.
    Use the left arrow key to move back some characters.
    Press the delete key.

    Suggested fix:
    Instead of showing "~" character when delete key is pressed, delete the character to the
    right of the cursor.

  • #2
    This is because it is built against EditLine. This is a Debian insanity. Compile against readline and your problems will be gone.

    Comment


    • #3
      Would you point me to a place that describes how to compile MySQL against readline?

      Looking at BUILD/SETUP.sh, I see:
      *** FILE SNIPPET BEGIN ***
      if test -d "$path/../cmd-line-utils/readline"
      then
      base_configs="$base_configs --with-readline"
      elif test -d "$path/../cmd-line-utils/libedit"
      then
      base_configs="$base_configs --with-libedit"
      fi
      *** FILE SNIPPET END ***

      If I do a listing of that directory, I get:
      ls cmd-line-utils/
      libedit readline

      When I compile, I just run:
      cmake .
      make
      make install

      The operating system is quite old though:
      cat /etc/SuSE-release
      SUSE LINUX Enterprise Server 9 (x86_64)
      VERSION = 9
      PATCHLEVEL = 3

      Thanks.

      Comment


      • #4
        Figured it out. I was able to do it with the following commands:

        cmake -L -DWITH_READLINE:BOOL=ON
        make
        make install

        Comment

        Working...
        X