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
