Description: I've encountered a problem with a select statement. When I run it for the first time it doesn't give any result, but it gives for the second and other times. If I run a kind of (what I don't know exactly) query on the database (or table) then when I run this select right after, it doesn't prouce any result again. After the first select it behaves normal. I'm the only one who uses this mysql server that on my machine at work, no other users/processes were using at the time of tests. How-To-Repeat: I don't know how this mysqlbug script works, but if I can I will attach some scripts that makes the problem reproducable. Fix: unfortunatelly it isn't known, and causes a big trouble for our CMS

Submitter-Id: <submitter ID> Originator: Arpad Tamas Organization: <organization of PR author (multiple lines)> MySQL support: [none | licence | email support | extended email support ] Synopsis: more run of the same select statement doesn't produce the same result Severity: serious Priority: <[ low | medium | high ] (one line)> Category: mysql Class: sw-bug Release: mysql-3.23.47 (Official MySQL RPM)

Environment: Amd K7-700, RedHat Linux 7.0 (with it's standard libraries and kernel) System: Linux sts.xubion.hu 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 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-redhat-linux/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'
CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Apr 4 2001 /lib/libc.so.6 ->
libc-2.2.so -rwxr-xr-x 1 root root 5072386 Jan 11 2001 /lib/libc-2.2.so -rw-r--r-- 1 root root 24498288 Jan 11 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 11 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--without-berkeley-db --without-innodb --enable-assembler
--with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock
--prefix=/ --with-extra-charsets=complex --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include
--mandir=/usr/man '--with-comment=Official MySQL RPM'