>Description: When running the statements below, MySQL errors out with: ERROR 1062 (23000) at line 5: Duplicate entry '1' for key 1 during SELECT
>How-To-Repeat: drop table if exists t; create table t (f int not null); insert into t values (1),(1); select 1 from t straight_join t as t2 left join t as t3 on 0=1 group by t2.f having 0=count(*) >Fix: Workarounds include removing "not null" from the table definition, using a join instead of a straight_join, removing the left join, having no rows in the left joined table (three different tables can be used; the bug doesn't depend on aliases), grouping on t.f instead of t2.f, or changing "0=count(*)" to "0=0". >Submitter-Id: <submitter ID> >Originator: Michael Thorpe >Organization: GISTnet, Inc. >MySQL support: none >Synopsis: Duplicate key error during select >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-5.0.37 (Source distribution) >Server: /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.37, for unknown-linux-gnu on >x86_64 Copyright (C) 2000-2006 MySQL 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 5.0.37-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /usr/mysql/sock/mysql.sock Uptime: 170 days 4 hours 18 min 34 sec Threads: 12 Questions: 218282739 Slow queries: 379 Opens: 4014478 Flush tables: 1 Open tables: 64 Queries per second avg: 14.846 >C compiler: gcc (GCC) 3.3.5 (Debian 1:3.3.5-13) >C++ compiler: g++ (GCC) 3.3.5 (Debian 1:3.3.5-13) >Environment: System: Linux gn5 2.6.14 #5 SMP Mon Mar 5 14:19:52 PST 2007 x86_64 GNU/Linux Architecture: x86_64 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/x86_64-linux/3.3.5/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,pascal,objc,ada,treelang --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.3 --enable-shared --enable-__cxa_atexit --with-system-zlib --enable-nls --without-included-gettext --enable-clocale=gnu --enable-debug --enable-java-gc=boehm --enable-java-awt=xlib --enable-objc-gc --disable-multilib x86_64-linux Thread model: posix gcc version 3.3.5 (Debian 1:3.3.5-13) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Feb 21 2007 /lib/libc.so.6 -> libc-2.3.2.so -rwxr-xr-x 1 root root 1295328 Feb 17 2007 /lib/libc-2.3.2.so -rw-r--r-- 1 root root 3861862 Feb 17 2007 /usr/lib/libc.a -rwxr-xr-x 1 root root 206 Feb 17 2007 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/mysql' '--with-unix-socket-path=/usr/mysql/sock/mysql.sock' '--with-mysqld-user=mysql' '--without-readline' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]