Your message dated Sun, 14 Dec 2008 10:47:19 +0000
with message-id <[email protected]>
and subject line Bug#505179: fixed in mysql-dfsg-5.0 5.0.67-2
has caused the Debian Bug report #505179,
regarding mysql-server-5.0: SELECT COUNT() with a WHERE clause, where no
conditions found, returns an empty set.
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
505179: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=505179
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mysql-server-5.0
Version: 5.0.67-1
Severity: normal
The package should not be checked out to testing or stable.
When using a WHERE claused with COUNT() and no criteria is met, the result
should be 0, not an empty set.
mysql> SELECT COUNT(*) FROM user WHERE User='joe' GROUP BY User;
Empty set (0.00 sec)
Using COUNT()+WHERE and having directive spl-mode="ONLY_FULL_GROUP_BY" should
not require a GROUP BY:
mysql> SELECT COUNT(*) FROM user WHERE User='joe';
ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no
GROUP columns is illegal if there is no GROUP BY clause
External bug report:
http://bugs.mysql.com/bug.php?id=39656
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-1-686 (SMP w/2 CPU cores)
Locale: LANG=en_DK.UTF-8, LC_CTYPE=en_DK.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages mysql-server-5.0 depends on:
ii adduser 3.110 add and remove users and groups
ii debconf [debconf-2.0] 1.5.24 Debian configuration management sy
ii libc6 2.7-15 GNU C Library: Shared libraries
ii libdbi-perl 1.607-1 Perl5 database interface by Tim Bu
ii libgcc1 1:4.3.2-1 GCC support library
ii libmysqlclient15off 5.0.67-1 MySQL database client library
ii libncurses5 5.6+20081025-1 shared libraries for terminal hand
ii libreadline5 5.2-3 GNU readline and history libraries
ii libstdc++6 4.3.2-1 The GNU Standard C++ Library v3
ii libwrap0 7.6.q-16 Wietse Venema's TCP wrappers libra
ii lsb-base 3.2-20 Linux Standard Base 3.2 init scrip
ii mysql-client-5.0 5.0.67-1 MySQL database client binaries
ii mysql-common 5.0.67-1 MySQL database common files
ii passwd 1:4.1.1-5 change and administer password and
ii perl 5.10.0-17 Larry Wall's Practical Extraction
ii psmisc 22.6-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime
Versions of packages mysql-server-5.0 recommends:
ii bsd-mailx [mailx] 8.1.2-0.20071201cvs-3 A simple mail user agent
ii heirloom-mailx [ma 12.3+cvs20080629-1 feature-rich BSD mail(1)
ii libhtml-template-p 2.9-1 HTML::Template : A module for usin
ii mailx 1:20071201-3 Transitional package for mailx ren
Versions of packages mysql-server-5.0 suggests:
pn tinyca <none> (no description available)
-- debconf information excluded
--- End Message ---
--- Begin Message ---
Source: mysql-dfsg-5.0
Source-Version: 5.0.67-2
We believe that the bug you reported is fixed in the latest version of
mysql-dfsg-5.0, which is due to be installed in the Debian FTP archive:
libmysqlclient15-dev_5.0.67-2_amd64.deb
to pool/main/m/mysql-dfsg-5.0/libmysqlclient15-dev_5.0.67-2_amd64.deb
libmysqlclient15off_5.0.67-2_amd64.deb
to pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.67-2_amd64.deb
mysql-client-5.0_5.0.67-2_amd64.deb
to pool/main/m/mysql-dfsg-5.0/mysql-client-5.0_5.0.67-2_amd64.deb
mysql-client_5.0.67-2_all.deb
to pool/main/m/mysql-dfsg-5.0/mysql-client_5.0.67-2_all.deb
mysql-common_5.0.67-2_all.deb
to pool/main/m/mysql-dfsg-5.0/mysql-common_5.0.67-2_all.deb
mysql-dfsg-5.0_5.0.67-2.diff.gz
to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.67-2.diff.gz
mysql-dfsg-5.0_5.0.67-2.dsc
to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.67-2.dsc
mysql-server-5.0_5.0.67-2_amd64.deb
to pool/main/m/mysql-dfsg-5.0/mysql-server-5.0_5.0.67-2_amd64.deb
mysql-server_5.0.67-2_all.deb
to pool/main/m/mysql-dfsg-5.0/mysql-server_5.0.67-2_all.deb
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Norbert Tretkowski <[email protected]> (supplier of updated mysql-dfsg-5.0
package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.8
Date: Sun, 14 Dec 2008 10:12:30 +0100
Source: mysql-dfsg-5.0
Binary: libmysqlclient15off libmysqlclient15-dev mysql-common mysql-client-5.0
mysql-server-5.0 mysql-server mysql-client
Architecture: source all amd64
Version: 5.0.67-2
Distribution: unstable
Urgency: low
Maintainer: Debian MySQL Maintainers <[email protected]>
Changed-By: Norbert Tretkowski <[email protected]>
Description:
libmysqlclient15-dev - MySQL database development files
libmysqlclient15off - MySQL database client library
mysql-client - MySQL database client (metapackage depending on the latest
versio
mysql-client-5.0 - MySQL database client binaries
mysql-common - MySQL database common files
mysql-server - MySQL database server (metapackage depending on the latest
versio
mysql-server-5.0 - MySQL database server binaries
Closes: 314785 324834 435165 442684 444216 505179 505181
Changes:
mysql-dfsg-5.0 (5.0.67-2) unstable; urgency=low
.
* New patch from 5.0.74 to fix check for non-aggregated columns in queries.
(closes: #505179, #505181)
* Add patch from Dan Munckton:
+ Clearly indicate that we do not support running multiple instances
of mysqld by duplicating the init script.
(closes: #314785, #324834, #435165, #444216)
+ Properly parameterize all existing references to the mysql config
file (/etc/mysql/my.cnf).
* Really fix FTBFS if build twice in a row. (closes: #442684)
Checksums-Sha1:
0bf2aca3d20fc283ff2d2573a475fdf3be907a62 1706 mysql-dfsg-5.0_5.0.67-2.dsc
b81964b05558286697ed3145fe1639227f98e962 294080 mysql-dfsg-5.0_5.0.67-2.diff.gz
b186c0db4e7c0ed1b3ea553778331a53ff02e19a 60448 mysql-common_5.0.67-2_all.deb
b1d25fb0506ddb59cd51db29a35232cd880d8528 54646 mysql-server_5.0.67-2_all.deb
b77cefec0155d1344b550ac0e858b5f92ec6cc73 52450 mysql-client_5.0.67-2_all.deb
a4b9dee2e7d01e7065055d238dd133d607b1e610 1902334
libmysqlclient15off_5.0.67-2_amd64.deb
46ec68689870d152efd236694c711fe5b29d609c 7658368
libmysqlclient15-dev_5.0.67-2_amd64.deb
ef802326b8877c2ae965c6faf808558cbc050ca2 8243186
mysql-client-5.0_5.0.67-2_amd64.deb
e330a93c7894c90e10ec77317ee44bb71d1da928 27381828
mysql-server-5.0_5.0.67-2_amd64.deb
Checksums-Sha256:
2ffb463587cf7b85e8b6c3f301afbadc8ddd1a4b2769249a2f2a3036dbd32a17 1706
mysql-dfsg-5.0_5.0.67-2.dsc
64df5d106ba7c4eae406b7c2aed3fec914c79457ee222963372f47f350586c8c 294080
mysql-dfsg-5.0_5.0.67-2.diff.gz
dbbb4b214a51d6de124a4a8487e55cb338c51033ed21e9d59a4221a24d7ae12f 60448
mysql-common_5.0.67-2_all.deb
143b02f01594ad2e151b67345b4616396cdfc086d7abdce32b740e1fd858baed 54646
mysql-server_5.0.67-2_all.deb
80bbec8ada9c4ce6fca1512644072d42d21976f4eb87e4d2be190d2a4913d4cc 52450
mysql-client_5.0.67-2_all.deb
a42391fcd94ede64e6a5fca28d3ad63356da2fe6312ad0b093d1128f5ead7b86 1902334
libmysqlclient15off_5.0.67-2_amd64.deb
1fa9dec274e8f1c7079ca46a9646ebad811bb290c44660e2b0d6d4ef0d19bf43 7658368
libmysqlclient15-dev_5.0.67-2_amd64.deb
49ca86c78310f29035f2be56e83595c58d3d056b4a8d472e10b217c316560460 8243186
mysql-client-5.0_5.0.67-2_amd64.deb
d8c65f27f27dd9a32bb030bd6fc8f5a0b86abcd03e573ade0cbaca2e40eab582 27381828
mysql-server-5.0_5.0.67-2_amd64.deb
Files:
b59adeb5f956abac5dab4da5f50406d3 1706 misc optional mysql-dfsg-5.0_5.0.67-2.dsc
1f110ffc91c7630aea80437354a7cb1d 294080 misc optional
mysql-dfsg-5.0_5.0.67-2.diff.gz
5889d7baf6301f89dee0786c0f131492 60448 misc optional
mysql-common_5.0.67-2_all.deb
2526148dda0a851b0d370891a1a06530 54646 misc optional
mysql-server_5.0.67-2_all.deb
7ef951fcf4693ef6ed31386d20452ca6 52450 misc optional
mysql-client_5.0.67-2_all.deb
99e199263dc76650d2333da886b194b4 1902334 libs optional
libmysqlclient15off_5.0.67-2_amd64.deb
12ae09c386823a226b31670cba52e4f2 7658368 libdevel optional
libmysqlclient15-dev_5.0.67-2_amd64.deb
e7b9cd2f3b4097f53754886ae5abe53b 8243186 misc optional
mysql-client-5.0_5.0.67-2_amd64.deb
27af9daa155be933452a7236ef4a176b 27381828 misc optional
mysql-server-5.0_5.0.67-2_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAklE4FsACgkQr/RnCw96jQEpmwCfT9M/QXs7/rvxsX2cZRCKzWzA
b58An36TJS47Czt5kQVeuUQl49yyqKGI
=RyKr
-----END PGP SIGNATURE-----
--- End Message ---
