Hi!
I have now fixed in MySQL 3.22.28 and 3.23.8 that the standard mysql
client will not cause ;; in the update log anymore.
Regards,
Monty
>>>>> "jdd" == jdd <jdd@stripped> writes:
jdd> Using log-long-format and log-update, I've found it's possible for the
jdd> server to write characters to the updatelog that cannot be played back
jdd> into the server without causing a syntax error. In particular my update
jdd> log contained a single line consisting solely of the characters ;; which
jdd> caused the server to choke.
>> How-To-Repeat:
jdd> a) update foo set x=y
jdd> ;;
jdd> b) mysql -o -p database < update.log
>> Fix:
>> Submitter-Id: <submitter ID>
>> Originator: John David Duncan
>> Organization:
jdd> <Oregon Public Networking>
>> MySQL support: [none ]
>> Synopsis: <mysqld writes ;;; to update.log >
>> Severity:
>> Priority:
>> Category: mysql
>> Class:
>> Release: mysql-3.22.27 (Source distribution)
>> Server: /usr/local/mysql/bin/mysqladmin Ver 7.11 Distrib 3.22.27, for
> pc-bsdi4.0.1 on i386
jdd> TCX Datakonsult AB, by Monty
jdd> Server version 3.22.27-log
jdd> Protocol version 10
jdd> Connection Localhost via UNIX socket
jdd> UNIX socket /tmp/mysql.sock
jdd> Uptime: 8 min 8 sec
jdd> Threads: 1 Questions: 258 Slow queries: 0 Opens: 39 Flush tables: 1 Open
> tables: 0
>> Environment:
jdd> System: BSD/OS rabbit.office.efn.org 4.0.1 BSDI BSD/OS 4.0.1 Kernel #1: Tue Jul 20
> 14:47:55 PDT 1999 sgd@stripped:/usr/src/sys/compile/RABBIT i386
jdd> Some paths: /usr/ucb//perl /usr/ucb//make /usr/contrib/bin/gmake /usr/ucb//gcc
> /usr/ucb//cc
jdd> GCC: gcc version 2.7.2.1
jdd> Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
jdd> Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock
> --with-low-memory --with-mit-threads=yes
jdd> Perl: This is perl, version 4.0
jdd> ---------------------------------------------------------------------
jdd> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
jdd> posting. To request this thread, e-mail mysql-thread20478@stripped
jdd> To unsubscribe, send a message to the address shown in the
jdd> List-Unsubscribe header of this message. If you cannot see it,
jdd> e-mail mysql-unsubscribe@stripped instead.
