Your message dated Fri, 14 Jan 2005 11:47:13 -0500
with message-id <[EMAIL PROTECTED]>
and subject line Bug#282486: fixed in mysql-dfsg-4.1 4.1.8a-5
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)
--------------------------------------
Received: (at submit) by bugs.debian.org; 22 Nov 2004 13:50:02 +0000
>From [EMAIL PROTECTED] Mon Nov 22 05:50:02 2004
Return-path: <[EMAIL PROTECTED]>
Received: from h00401011cf04.ne.client2.attbi.com (tigger.ma.gildea.net)
[24.61.44.96]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1CWEZu-0005aq-00; Mon, 22 Nov 2004 05:50:02 -0800
Received: by tigger.ma.gildea.net (Postfix, from userid 1000)
id A707B3CC02E; Mon, 22 Nov 2004 08:50:01 -0500 (EST)
Received: from tigger.ma.gildea.net (localhost [127.0.0.1])
by tigger.ma.gildea.net (Postfix) with ESMTP id A0CDE6D4218
for <[EMAIL PROTECTED]>; Mon, 22 Nov 2004 08:50:01 -0500 (EST)
From: Stephen Gildea <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: mysql_list_fields fails as used by ODBC and OpenOffice
X-Mailer: MH-E 7.82; nmh 1.1; GNU Emacs 21.3.1
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=-=-="
Date: Mon, 22 Nov 2004 08:50:01 -0500
Message-Id: <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
--=-=-=
Package: mysql-server
Version: 4.0.22
Recent versions of mysql-server fail with certain uses of the
mysql_list_fields client function, to which the server returns 0 fields,
even though the table may have more than 0 fields. The problem seems to
be triggered when setting the third argument, "wild", to a non-NULL
value.
I've seen this failure with these versions of mysql-server:
4.0.21, 4.0.22, 4.1.7. (Version 4.0.20 works fine.)
In particular, Debian mysql-server 4.0.20-14 works and 4.0.21-1 fails.
This bug breaks OpenOffice.org's dba access with ODBC. ODBC's MySQL
driver is myodbc, which calls mysql_list_fields. If you try to sort
a data source by a column, OpenOffice gives you the error "Column
not in select clause!". (Note that I'm using database type "ODBC",
not type "MySQL".)
I've written the attached small program to demonstrate the bug. (This
seemed nicer than asking you to configure ODBC with a MySQL driver and
create an openoffice data source that uses ODBC.) It's a very simple
program; you will need to compile in your database access values.
Other parts of my configuration:
ii libc6 2.3.2.ds1-18
ii libmysqlclient12 4.0.22-2
ii libmyodbc 3.51.06-1
ii unixodbc 2.2.4-11
ii openoffice.org-bin 1.1.2dfsg1-1
I have tried also compiling my test client against libmysqlclient10 and
libmysqlclient14. No change; this seems to be a server problem.
Both client and server are on Pentium-class machines.
--=-=-=
Content-Type: text/x-c
Content-Disposition: attachment; filename=mysql-list-fields-test.c
Content-Description: mysql-server bug-testing client
/*
* This program demonstrates how the mysql_list_fields() call
* (as used by myodbc as called from OpenOffice.org)
* fails to get the fields from the server.
* It fails with MySQL server versions 4.0.21 through 4.1.7 (current version).
* It works with all earlier versions of the server.
*
* Test case by Stephen Gildea, November 2004.
*/
#include <mysql/mysql.h>
#include <stdio.h>
/* modify these values to suit your database */
static char host[] = "localhost";
static char user[] = "yourusername";
static char password[] = "yourpassword";
static char dbname[] = "yourdatabase";
static char table[] = "atablename";
int main()
{
MYSQL *db_conn;
MYSQL_RES *db_results;
int num_fields;
db_conn = mysql_init(NULL);
mysql_real_connect(db_conn, host, user, password, dbname, 0, NULL, 0);
if (mysql_errno(db_conn) != 0) {
printf("mysql_real_connect failed: %s\n", mysql_error(db_conn));
return 3;
}
/* without this query, the following list_fields
fails even against older servers */
mysql_query(db_conn, "show tables like '%'");
db_results = mysql_store_result(db_conn);
mysql_free_result(db_results);
/*
* MySQL server 4.0.21 or newer will erroneously return 0 fields
* to this mysql_list_fields call.
*/
db_results = mysql_list_fields(db_conn, table, "%");
if (db_results == NULL) {
printf("mysql_list_fields failed: %s\n", mysql_error(db_conn));
return 1;
}
num_fields = mysql_num_fields(db_results);
if (num_fields == 0) {
printf("FAILURE! MySQL server failed to return any fields to
mysql_list_fields\n");
return 2;
}
printf("SUCCESS! mysql_list_fields found %d fields\n", num_fields);
return 0;
}
--=-=-=--
---------------------------------------
Received: (at 282486-close) by bugs.debian.org; 14 Jan 2005 16:53:03 +0000
>From [EMAIL PROTECTED] Fri Jan 14 08:53:03 2005
Return-path: <[EMAIL PROTECTED]>
Received: from newraff.debian.org [208.185.25.31] (mail)
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1CpUh4-000677-00; Fri, 14 Jan 2005 08:53:03 -0800
Received: from katie by newraff.debian.org with local (Exim 3.35 1 (Debian))
id 1CpUbR-0006Aj-00; Fri, 14 Jan 2005 11:47:13 -0500
From: Christian Hammers <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
X-Katie: $Revision: 1.55 $
Subject: Bug#282486: fixed in mysql-dfsg-4.1 4.1.8a-5
Message-Id: <[EMAIL PROTECTED]>
Sender: Archive Administrator <[EMAIL PROTECTED]>
Date: Fri, 14 Jan 2005 11:47:13 -0500
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Source: mysql-dfsg-4.1
Source-Version: 4.1.8a-5
We believe that the bug you reported is fixed in the latest version of
mysql-dfsg-4.1, which is due to be installed in the Debian FTP archive:
libmysqlclient14-dev_4.1.8a-5_i386.deb
to pool/main/m/mysql-dfsg-4.1/libmysqlclient14-dev_4.1.8a-5_i386.deb
libmysqlclient14_4.1.8a-5_i386.deb
to pool/main/m/mysql-dfsg-4.1/libmysqlclient14_4.1.8a-5_i386.deb
mysql-client-4.1_4.1.8a-5_i386.deb
to pool/main/m/mysql-dfsg-4.1/mysql-client-4.1_4.1.8a-5_i386.deb
mysql-common-4.1_4.1.8a-5_all.deb
to pool/main/m/mysql-dfsg-4.1/mysql-common-4.1_4.1.8a-5_all.deb
mysql-dfsg-4.1_4.1.8a-5.diff.gz
to pool/main/m/mysql-dfsg-4.1/mysql-dfsg-4.1_4.1.8a-5.diff.gz
mysql-dfsg-4.1_4.1.8a-5.dsc
to pool/main/m/mysql-dfsg-4.1/mysql-dfsg-4.1_4.1.8a-5.dsc
mysql-server-4.1_4.1.8a-5_i386.deb
to pool/main/m/mysql-dfsg-4.1/mysql-server-4.1_4.1.8a-5_i386.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-4.1
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: Thu, 13 Jan 2005 01:29:05 +0100
Source: mysql-dfsg-4.1
Binary: libmysqlclient14-dev mysql-common-4.1 libmysqlclient14 mysql-server-4.1
mysql-client-4.1
Architecture: source i386 all
Version: 4.1.8a-5
Distribution: unstable
Urgency: medium
Maintainer: Christian Hammers <[EMAIL PROTECTED]>
Changed-By: Christian Hammers <[EMAIL PROTECTED]>
Description:
libmysqlclient14 - mysql database client library
libmysqlclient14-dev - mysql database development files
mysql-client-4.1 - mysql database client binaries
mysql-common-4.1 - mysql database common files (e.g. /etc/mysql/my.cnf)
mysql-server-4.1 - mysql database server binaries
Closes: 282486 287792 287955 289131 289840 289851
Changes:
mysql-dfsg-4.1 (4.1.8a-5) unstable; urgency=medium
.
* Fixed important upstream bug that causes from_unixtime(0) to return
NULL instead of "1970-01-01 00:00:00" which fails on NOT NULL columns.
Closes: #287792
* Fixes upstream bug in mysql_list_fields() . Closes: #282486
* Fixes bug that lead to double rotated logfiles when mysql-server 4.0
was previously installed (thanks to Olaf van der Spek). Closes: #289851
* Fixed typo in README.Debian (thanks to Mark Nipper). Closes: #289131
* Changed max_allowed_packet in my.cnf to 16M as in 4.0.x (thanks to
Olaf van der Spek). Closes: #289840
* Updated French debconf translation (thanks to Christian Perrier).
Closes: #287955
Files:
62e7deb8422b4c87e1530ce465fc80c1 977 misc optional mysql-dfsg-4.1_4.1.8a-5.dsc
10ec5accefad0de379fd34859232b964 149107 misc optional
mysql-dfsg-4.1_4.1.8a-5.diff.gz
5f6c922efe5206659d493f56ef463c26 31150 misc optional
mysql-common-4.1_4.1.8a-5_all.deb
24307e815e714e2753affc9d8ab9c5d9 1402032 libs optional
libmysqlclient14_4.1.8a-5_i386.deb
5e9796cc491408c31bd127c9d4380f8f 2507052 libdevel optional
libmysqlclient14-dev_4.1.8a-5_i386.deb
db8251e85c11fb49c133ccb37d410466 821102 misc optional
mysql-client-4.1_4.1.8a-5_i386.deb
bac02ea4dc2eb93db99feaa32e28dee2 14480052 misc optional
mysql-server-4.1_4.1.8a-5_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
iEYEARECAAYFAkHn70wACgkQkR9K5oahGOYdQACdGJD199nX5Or3I9RFnYcjGgKN
aDkAnipOUL+rJTy49YoAnl9W2d+ym9BH
=xB+8
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
