Apologies, I thought I had done a decent search to see if anyone else had reported it, but apparently my search skills are lacking, I see that it was fixed in 4.0.4.
On Wed, Sep 25, 2002 at 11:34:07PM -0500, Shane Allen wrote: > >Description: > > selecting distinct when executing a left join causes mysql to die > > >How-To-Repeat: > > CREATE TABLE test1 ( > i1 int(10) unsigned NOT NULL default 0, > s1 varchar(30), > PRIMARY KEY (i1) > ); > > CREATE TABLE test2 ( > i1 int(10) unsigned NOT NULL default 0, > s1 varchar(30), > PRIMARY KEY (i1) > ); > > insert into test1 values (1,'test'); > insert into test1 values (2,'test'); > insert into test2 values (1,'test'); > insert into test2 values (2,'test'); > > select distinct * from test1 t1 left join test2 t2 on (t1.i1=t2.i1); > > >Fix: > > None known > > >Submitter-Id: <submitter ID> > >Originator: Shane Allen (shane at sell dot com) > >Organization: sell.com > >MySQL support: none > >Synopsis: select distinct with a left join crashes mysql 4.0.3 > >Severity: critical > >Priority: low > >Category: mysql > >Class: sw-bug > >Release: mysql-4.0.3-beta (Source distribution) > >Server: /usr/local/bin/mysqladmin Ver 8.37 Distrib 4.0.3-beta, for pc-linux-gnu on >i686 > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > and you are welcome to modify and redistribute it under the GPL license > > Server version 4.0.3-beta-log > Protocol version 10 > Connection Localhost via UNIX socket > UNIX socket /tmp/mysql.sock > Uptime: 56 sec > > Threads: 2 Questions: 13 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: >1 Queries per second avg: 0.232 > >Environment: > System: Linux local-dbmaster-test 2.4.19 #1 SMP Mon Sep 2 15:38:05 CDT 2002 i686 >unknown > Architecture: i686 > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc > GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.1.1/specs > Configured with: /mnt/data/gcc-3.1/gcc-3.1-3.1.1ds3/src/configure -v >--enable-languages=c,c++,java,f77,proto,objc,ada --prefix=/usr >--mandir=/usr/share/man --infodir=/usr/share/info >--with-gxx-include-dir=/usr/include/c++/3.1 --enable-shared --with-system-zlib >--enable-long-long --enable-nls --without-included-gettext --enable-clocale=gnu >--enable-__cxa_atexit --enable-threads=posix --enable-java-gc=boehm --enable-objc-gc >i386-linux > Thread model: posix > gcc version 3.1.1 > Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs >-Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings >-Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' >CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W >-Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings >-Woverloaded-virtual -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 Jul 30 16:49 /lib/libc.so.6 -> >libc-2.2.5.so > -rwxr-xr-x 1 root root 1153784 Jul 18 06:53 /lib/libc-2.2.5.so > -rw-r--r-- 1 root root 2390922 Jul 18 06:53 /usr/lib/libc.a > -rw-r--r-- 1 root root 178 Jul 18 06:53 /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 >--enable-local-infile --with-other-libc=/usr/local/mysql-glibc-2.2.5 >--prefix=/usr/local --with-extra-charsets=none --without-innodb > > > --------------------------------------------------------------------- > 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 > -- Shane Allen <[EMAIL PROTECTED]> sell.com : Buy & Sell Anything http://www.sell.com --------------------------------------------------------------------- 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