LOAD INFILE to temporary table breaks replication

>Description:
I have 2 servers setup. One is a master, the other a read-only
slave. I am replicationg all databases except for the permission DB
(mysql). I noticed that replication breaks if the LOAD INFILE syntax is
used to populate a temporary table. The query completes normally on the
master, but the following error is recorded on the slave:

020621 14:10:23 Slave: connected to master 'replication@master:3306',
replication started in log 'master-bin.001' at position 32620370
020621 14:57:01 Slave: Error 'Table '%-.64s.%-.64s' doesn't exist'
running load data infile
020621 14:57:01 Error running query, slave aborted. Fix the problem, and
re-start the slave thread with "mysqladmin start-slave". We stopped at log
'master-bin.001' position 61759262
020621 14:57:01 Slave thread exiting, replication stopped in log
'master-bin.001' at position 61759262

>How-To-Repeat:

On master do:

CREATE TEMPORARY TABLE foo(bar VARCHAR(50) NOT NULL);
LOAD DATA INFILE '/tmp/baz.txt' INTO TABLE foo FIELDS TERMINATED BY '|';


>Fix:
Don't know, I'm not familiar enough with MySQL source


>Submitter-Id:
>Originator: Andrew Shoemaker
>Organization:
>MySQL support: none
>Synopsis: LOAD INFILE to temporary table breaks replication
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.49 (Official MySQL Binary)

>Environment:
System: Linux foo 2.4.18 #1 SMP Wed Jun 19 18:40:37 EDT 2002 i686 unknown
Architecture: i686

Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 May 28 12:21 /lib/libc.so.6 -> libc-2.2.3.so
-rwxr-xr-x 1 root root 4783716 May 25 2001 /lib/libc-2.2.3.so
-rw-r--r-- 1 root root 24721042 May 25 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 May 25 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client --enable-local-infile 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro
-O3 -fno-omit-frame-pointer' CXX=gcc


***Note: Remove "-spamsucks-" from my address for any responses.



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12128@lists.mysql.com
To unsubscribe, e-mail