Your message dated Sat, 02 Dec 2006 21:17:12 +0000 with message-id <[EMAIL PROTECTED]> and subject line Bug#397597: fixed in mysql-dfsg-5.0 5.0.30-1 has caused the attached Bug report 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 I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database)
--- Begin Message ---Package: mysql-server-5.0 Version: 5.0.26-2 Severity: normal Hello, thanks for maintaining mysql. This one is weird, but I can regularly reproduce it in my machine. Here is how: 1. Create the database test, on InnoDB 2. zcat intial-build.gz | mysql test 3. mysql test 4. SELECT pa.lat, pa.lon, pa.ident, c.ltype, c.l1, c.l2, c.ptype, c.p1, c.p2, c.datetime, c.id_report, d.id_var, d.value, pa.id, c.id FROM context AS c JOIN pseudoana AS pa ON c.id_ana = pa.id JOIN data AS d ON d.id_context=c.id WHERE c.id_report=1 AND c.datetime>='1001-01-01 00:00:00' ORDER BY c.id_ana, c.datetime, c.ltype, c.l1, c.l2, c.ptype, c.p1, c.p2; will return an empty result 5. SELECT pa.lat, pa.lon, pa.ident, c.ltype, c.l1, c.l2, c.ptype, c.p1, c.p2, c.datetime, c.id_report, d.id_var, d.value, pa.id, c.id FROM context AS c JOIN pseudoana AS pa ON c.id_ana = pa.id JOIN data AS d ON d.id_context=c.id WHERE c.id_report=1 AND c.datetime>='1001-01-01 00:00:00'; will return a non-empty result 6. mysqldump test > /tmp/dump 7. mysql test < /tmp/dump 8. SELECT pa.lat, pa.lon, pa.ident, c.ltype, c.l1, c.l2, c.ptype, c.p1, c.p2, c.datetime, c.id_report, d.id_var, d.value, pa.id, c.id FROM context AS c JOIN pseudoana AS pa ON c.id_ana = pa.id JOIN data AS d ON d.id_context=c.id WHERE c.id_report=1 AND c.datetime>='1001-01-01 00:00:00' ORDER BY c.id_ana, c.datetime, c.ltype, c.l1, c.l2, c.ptype, c.p1, c.p2; will return a non-empty result I'm attaching initial-build.gz to this bug report. Ciao, Enrico -- System Information: Debian Release: 4.0 APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.18-1-686 Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8) Versions of packages mysql-server-5.0 depends on: ii adduser 3.99 Add and remove users and groups ii debconf [debconf-2.0] 1.5.8 Debian configuration management sy ii libc6 2.3.6.ds1-8 GNU C Library: Shared libraries ii libdbi-perl 1.52-1 Perl5 database interface by Tim Bu ii libgcc1 1:4.1.1-19 GCC support library ii libmysqlclient15off 5.0.26-2 mysql database client library ii libncurses5 5.5-5 Shared libraries for terminal hand ii libreadline5 5.2-1 GNU readline and history libraries ii libstdc++6 4.1.1-19 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-11 Wietse Venema's TCP wrappers libra ii lsb-base 3.1-19 Linux Standard Base 3.1 init scrip ii mysql-client-5.0 5.0.26-2 mysql database client binaries ii mysql-common 5.0.26-2 mysql database common files (e.g. ii passwd 1:4.0.18.1-5 change and administer password and ii perl 5.8.8-6.1 Larry Wall's Practical Extraction ii psmisc 22.3-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3-13 compression library - runtime Versions of packages mysql-server-5.0 recommends: ii mailx 1:8.1.2-0.20050715cvs-1 A simple mail user agent -- debconf information: mysql-server-5.0/really_downgrade: false mysql-server-5.0/start_on_boot: true mysql-server/error_setting_password: mysql-server-5.0/mysql_update_hints1: mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false mysql-server-5.0/no_upgrade_with_isam_tables: * mysql-server-5.0/mysql_install_db_notes:
initial-build.gz
Description: Binary data
--- End Message ---
--- Begin Message ---Source: mysql-dfsg-5.0 Source-Version: 5.0.30-1 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.30-1_amd64.deb to pool/main/m/mysql-dfsg-5.0/libmysqlclient15-dev_5.0.30-1_amd64.deb libmysqlclient15off_5.0.30-1_amd64.deb to pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.30-1_amd64.deb mysql-client-5.0_5.0.30-1_amd64.deb to pool/main/m/mysql-dfsg-5.0/mysql-client-5.0_5.0.30-1_amd64.deb mysql-client_5.0.30-1_all.deb to pool/main/m/mysql-dfsg-5.0/mysql-client_5.0.30-1_all.deb mysql-common_5.0.30-1_all.deb to pool/main/m/mysql-dfsg-5.0/mysql-common_5.0.30-1_all.deb mysql-dfsg-5.0_5.0.30-1.diff.gz to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.30-1.diff.gz mysql-dfsg-5.0_5.0.30-1.dsc to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.30-1.dsc mysql-dfsg-5.0_5.0.30.orig.tar.gz to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.30.orig.tar.gz mysql-server-4.1_5.0.30-1_amd64.deb to pool/main/m/mysql-dfsg-5.0/mysql-server-4.1_5.0.30-1_amd64.deb mysql-server-5.0_5.0.30-1_amd64.deb to pool/main/m/mysql-dfsg-5.0/mysql-server-5.0_5.0.30-1_amd64.deb mysql-server_5.0.30-1_all.deb to pool/main/m/mysql-dfsg-5.0/mysql-server_5.0.30-1_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. Christian Hammers <[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.7 Date: Sat, 2 Dec 2006 16:36:38 +0100 Source: mysql-dfsg-5.0 Binary: libmysqlclient15-dev mysql-client mysql-client-5.0 mysql-server mysql-server-4.1 mysql-server-5.0 mysql-common libmysqlclient15off Architecture: source all amd64 Version: 5.0.30-1 Distribution: unstable Urgency: low Maintainer: Christian Hammers <[EMAIL PROTECTED]> Changed-By: Christian Hammers <[EMAIL PROTECTED]> Description: libmysqlclient15-dev - mysql database development files libmysqlclient15off - mysql database client library mysql-client - mysql database client (meta package depending on the latest versi mysql-client-5.0 - mysql database client binaries mysql-common - mysql database common files (e.g. /etc/mysql/my.cnf) mysql-server - mysql database server (meta package depending on the latest versi mysql-server-4.1 - mysql database server (transitional package) mysql-server-5.0 - mysql database server binaries Closes: 397597 401305 Changes: mysql-dfsg-5.0 (5.0.30-1) unstable; urgency=low . * New upstream version (switch to the MySQL Enterprise branch). * Upstream bugfix for the Innodb performance bug: "Very poor performance with multiple queries running concurrently (Bug#15815)". * Upstream bugfix for a possible server crash: "Selecting from a MERGE table could result in a server crash if the underlying tables had fewer indexes than the MERGE table itself (Bug#22937)" * Upstream bugfies for *lot* of NDB problems. * Upstream bugfix for Innodb optimizer bug. Closes: #397597 * Updated Italian Debconf translation (thanks to Luca Monducci). Closes: #401305 * Updated debian/watch file to MySQL Enterprise branch. Files: 34f663aa5fbd0f7073363a769773e0e6 1108 misc optional mysql-dfsg-5.0_5.0.30-1.dsc b505a79e2832c2d488efe6dc539bacb6 19254058 misc optional mysql-dfsg-5.0_5.0.30.orig.tar.gz 006701fc89c93ec78d0502a2e5ae25ac 140856 misc optional mysql-dfsg-5.0_5.0.30-1.diff.gz 8e8ba8a15fd160c43874a1f6b08dfcb3 50912 misc optional mysql-common_5.0.30-1_all.deb 0e4f8af780fceb335a762e2ceb373bab 44456 misc optional mysql-server_5.0.30-1_all.deb 44763756824494beead5fa746f644770 42382 misc optional mysql-client_5.0.30-1_all.deb 08abcaf4534252e648c5d4ee7c5cec3a 1821632 libs optional libmysqlclient15off_5.0.30-1_amd64.deb d036af7569d09c629554b4e1222311c3 7335902 libdevel optional libmysqlclient15-dev_5.0.30-1_amd64.deb 032e43f98ac3cf2b7ac762aca9690e58 7516032 misc optional mysql-client-5.0_5.0.30-1_amd64.deb b3dabd9e2a19bb11b3cb17ed322c01ad 25743950 misc optional mysql-server-5.0_5.0.30-1_amd64.deb e7c38c31285ace621949823e02d88582 44488 oldlibs extra mysql-server-4.1_5.0.30-1_amd64.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iEYEARECAAYFAkVx6ZgACgkQkR9K5oahGOZQlQCgm9muZu8j8NKVChwBEeO5B5J6 bUkAn3fo6JMj1+ULhEUV5ZPuTLaQ07oR =W7Yk -----END PGP SIGNATURE-----
--- End Message ---
