MySQL Bugs: #7142: Show Fields from fails using Borland's dbExpress interface

Bug #7142	Show Fields from fails using Borland's dbExpress interface
Submitted:	9 Dec 2004 19:13	Modified:	9 Sep 2005 19:51
Reporter:	paladin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	3.23.58 / 4.0.18	OS:	Windows (W2K- Delphi 7 / 8)
Assigned to:	Reggie Burnett	CPU Architecture:	Any

Description:
Description:

Using Borland's Delphi (dbExpress) drivers to access MySQL,
issuing the command "Show Fields from SomeTable" always
truncates the returned 'TYPE' field to 40 characters, and
the returned 'DEFAULT' field to 64 characters.

The Borland developer[s] claim:
"...it looks like the problem lies within mysql_fetch_field.
  mysql_fetch_field returns 40 which is what we use."

comment?

How to repeat:

issue a "Show Fields from SomeTable" using delphi components
(eg. TSQLConnection.Execute("Show Fields from SomeTable", nil, @someDataSet) )

and look at the TYPE field for a table with a long list of enums

postlogue:

this may be similar to 3772 - but I wasn't sure.....

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/internals/26959

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Fixed in 4.1 tree only.

This only went into 4.1.  It made it into 4.1.13

yes.  sadly, as of 7/2005, Borland does not yet support 4.1x

Documented in 4.1.13 changelog:

<listitem><para><literal>SHOW FIELDS</literal> truncated the <literal>TYPE</literal> column to 40 characters. (Bug #7142)</para></listitem>

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/internals/29238

The patch is undone in 4.1.15

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/internals/29550

Noted in 4.1.13, 4.1.15, 5.0.13 changelogs.
(4.1.13 and 4.1.15 to noted the reversion of
earlier fix, 5.0.13 to note fix in 5.0.)