>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