[EMAIL PROTECTED] wrote: > > >Description: > > This query produces 16 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (field1 = field2) > WHERE field2 = 'something' > ORDER BY field2,field3,field4 > > But this query produces 0 results: > > SELECT * FROM table1 > LEFT JOIN table2 ON (field1 = field2) > WHERE field2 = 'something' > ORDER BY field2,field3,field4 > LIMIT 400; > > I can also get the correct results set by removing the ORDER BY clause. > > >How-To-Repeat: > > >Fix: > > >Submitter-Id: <submitter ID> > >Originator: > >Organization: > > >MySQL support: none > >Synopsis: Bug with Query in MySQL 4.0.0/RedHat 8.0 > >Severity: serious > >Priority: high > >Category: mysql > >Class: sw-bug > >Release: mysql-4.0.4-beta (Official MySQL RPM) > > >Environment: > > System: Linux pliedes-1.mfm.com 2.4.18-17.8.0 #2 Fri Oct 18 07:43:20 EDT 2002 i686 >i686 i386 GNU/Linux > 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/3.2/specs > Configured with: ../configure --prefix=/usr --mandir=/usr/share/man >--infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking >--host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit > Thread model: posix > gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) > 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 14 Oct 17 10:23 /lib/libc.so.6 -> >libc-2.2.93.so > -rwxr-xr-x 1 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so > -rw-r--r-- 1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a > -rw-r--r-- 1 root root 178 Sep 5 18:50 /usr/lib/libc.so > Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static >--with-client-ldflags=-all-static --without-berkeley-db --with-innodb --without-vio >--without-openssl --enable-assembler --enable-local-infile --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/share/info --includedir=/usr/include --mandir=/usr/share/man >--with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL >RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 >-fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti >-mpentium' CXX=gcc > > --------------------------------------------------------------------- > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Additional information: 1. I've tried on RedHat 8.0 and 7.1/7.2. 2. I've tried compiling my own version from the sources (w/RedHat 7.x) and the binary RPM version (on RedHat 8.0). 3. I've uploaded the relevant tables in mfm-mysqlbug.tar.gz to ftp://support.mysql.com/pub/mysql/secret/. -m -- ## Mark T. Dame, Vice President, Internet Operations ## MFM Communication Software: http://www.mfm.com/ ## E-mail: mailto:mdame@;mfm.com WWW: http://www.mfm.com/~mdame/ "And that's all I have to say about that." -- Forrest Gump --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php