MySQL Bugs: #19671: mysql_list_fields returns incorrect table name for VIEWs

Bug #19671	mysql_list_fields returns incorrect table name for VIEWs
Submitted:	10 May 2006 11:12	Modified:	3 Jul 2006 20:28
Reporter:	Bogdan Degtyariov	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: C API (client library)	Severity:	S2 (Serious)
Version:		OS:
Assigned to:	Sergei Glukhov	CPU Architecture:	Any

Description:
mysql_list_fields() function returns the name of the table alias instead of the name in VIEWs.
For the following view:
create view xyz as select t1.* from tab01 t1;

and following function call
res = mysql_list_fields(&mysql, "xyz", NULL);
it will return t1 as the table name for any field from xyz.
This causes the problem in Access

How to repeat:
Run the following SQL statements

create database thoga;
use thoga;
CREATE TABLE `tab01` (
  `id01` int(11) NOT NULL auto_increment
  PRIMARY KEY  (`id01`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
create view xyz as select t1.* from tab01 t1;

test case

Attachment: select_test.c (text/x-csrc), 932 bytes.

Is there a known work-around for this until it can be fixed?  It is significantly interfering with work I'm trying to do.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8249

The patch looks ok to push.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/8475

Fixed in 5.0.24

Noted in 5.0.24 changelog.

Fix went to 5.0.25 instead.

How can we find out when version 5.0.25 will be available, this bug is really a show stopper for my Apps under developement?

Noted in 5.1.12 changelog.