>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
