>Description:
When issuing a command containing both a GROUP BY and an ORDER BY clause, the server
is returning no results. This issue has
arisen since upgrading from 3.23.47 to 4.0.1
>How-To-Repeat:
Table Creation:
CREATE TABLE statarchive (uid INT unsigned NOT NULL AUTO_INCREMENT, referal
VARCHAR(15), date DATE, uniques int unsigned,
raws int unsigned, site VARCHAR(10), signups INT unsigned, payout decimal(8,2), bsff
mediumint unsigned, PRIMARY KEY(uid));
example select code:
SELECT date, sum(uniques) as cnt1, sum(signups) as cnt2, sum(payout) as cnt3 FROM
statarchive WHERE date BETWEEN '2002-01-29'
AND '2002-02-05' GROUP BY date ORDER BY date DESC;
Will return 0 results constantly (with any use of ORDER BY, ASC or DESC). Without the
ORDER BY clause the server returns the
7 days worth of stats appropriately calculated
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: none
>Synopsis: GROUP BY w/ and ORDER BY clause returns no results
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.47 (Source distribution)
>Server: /bin/mysqladmin Ver 8.23 Distrib 3.23.47, 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.1-alpha
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 3 days 1 hour 7 min 1 sec
Threads: 132 Questions: 4144248 Slow queries: 0 Opens: 1677 Flush tables: 1 Open
tables: 16 Queries per second avg: 15.744
>Environment:
System: Linux clarke 2.2.20 #2 SMP Tue Jan 29 13:22:41 CST 2002 i686 unknown
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-slackware-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jan 29 03:30 /lib/libc.so.6 -> libc-2.1.2.so
-rwxr-xr-x 1 root root 1008844 Sep 9 1999 /lib/libc-2.1.2.so
-rw-r--r-- 1 root root 20019674 Sep 15 1999 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 15 1999 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
