Bug #20147 mysql cmd-line client does not rename .mysql_history.TMP to .mysql_history
Submitted: 30 May 2006 11:24 Modified: 31 May 2006 21:28
Reporter: Markus Heinze Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.21 OS:Linux (linux x86 (SuSE 9.3))
Assigned to: CPU Architecture:Any

[30 May 2006 11:24] Markus Heinze
Description:
As formerly described in bug http://bugs.mysql.com/bug.php?id=16557 for the mysql-5.0.18 version.

When i built mysql from source without(!) --without-readline, the 5.0.21 mysql command-line
client saves its readline history in ~/.mysql_history.TMP but does not rename it
to ~/.mysql_history .  This means that no history is saved between sessions. 

gcc --version
gcc (GCC) 3.3.5 20050117 (prerelease) (SUSE Linux)
Copyright (C) 2003 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

How to repeat:
Build the code with:

#!/bin/bash

. ../platform.sh

export CXX=gcc
export CFLAGS="-DUSE_OLD_FUNCTIONS"
export CXXFLAGS=$CFLAGS

cd mysql

./configure \
--prefix=/usr/local \
--sysconfdir=/etc \
--localstatedir=/JobsAdverts/SqlServer/var \
--enable-thread-safe-client \
--enable-assembler \
--enable-static \
--with-raid \
--with-mysql-user=mysql \
--without-debug \
--without-docs \
--without-bench \
--with-extra-charsets=complex \
--with-innodb

$MAKE -j 4 &&
cd mysql-test && ./mysql-test-run --force

cd ..

... and use the client program local
[31 May 2006 21:28] Jorge del Conde
I was unable to reproduce this under 5.0.23 from bk