>Description:
parsing/executing aggregates involving IF() statements. Everything needed
to reproduce the bug available from
http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz
It's tested and reproduced on MySQL, version 3.23.32 on TrueUnix (two bugs)
or version 3.22.32 on Linux (only one them).
The 'meat' of the bugs is listed below.
>How-To-Repeat:
The tar file contains instructions
>Fix:
No idea.
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
EBI
>MySQL support: none
>Synopsis: parsing/executing aggregates involving IF() statements
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: Ver 3.23.32 for dec-osf4.0f on alphaev6 and mysqld Ver 3.22.32 for
>pc-linux-gnu on i686
>Environment:
Ver 3.23.32 for dec-osf4.0f on alphaev6
and Ver 3.22.32 for pc-linux-gnu on i686
System: SunOS sol6.ebi.ac.uk 5.7 Generic sun4u sparc SUNW,Ultra-5_10
Architecture: sun4
Some paths: /sw/arch/bin/perl /sw/arch/bin/make /sw/arch/bin/gmake /sw/arch/bin/gcc
/usr/ucb/cc
GCC: Reading specs from
/sw/arch/pkg/gcc-2.95.3/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs'
CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include
--mandir=/usr/man '--with-comment=Official MySQL RPM'
Perl: This is perl, version 5.005_03 built for sun4-solaris
NOTE: the Environment information is not that of the machine where I found
and/or reproduced the bug.
Second Note: I am rather annoyed at all the silly impediments to submitting a
bug-report. The number of hoops that I have to jump through to provide you
with a free and fairly detailed bug-report is completely ridiculous. This is
the fourth time I am submitting something. There is simply no reason for
this; just require subscription to the bugs mailing list, and allow
submitting in free format; that will get rid of most of the spam and noise.
I put some time into reproducing this bug, as I think this is part of the
civil duties of using open source software, and I hope this will be helpful
(we're academic and don't pay any support). However, I am not sure I can be
bothered to do this again if things are like this. Disgruntled,
Philip Lijnzaad <[EMAIL PROTECTED]>
---------------------------------------------------------------------
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
