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 version10
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