| Bug #7142 | Show Fields from fails using Borland's dbExpress interface | ||
|---|---|---|---|
| Submitted: | 9 Dec 2004 20:13 | Modified: | 9 Sep 2005 21:51 |
| Reporter: | paladin | ||
| Status: | Closed | ||
| Category: | Server | Severity: | S3 (Non-critical) |
| Version: | 3.23.58 / 4.0.18 | OS: | Microsoft Windows (W2K- Delphi 7 / 8) |
| Assigned to: | Reggie Burnett | Target Version: | |
[9 Dec 2004 20:15]
paladin
postlogue: this may be similar to 3772 - but I wasn't sure.....
[12 Jul 2005 21:34]
Bugs System
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
[12 Jul 2005 21:36]
Reggie Burnett
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.
[27 Jul 2005 16:58]
Reggie Burnett
This only went into 4.1. It made it into 4.1.13
[27 Jul 2005 17:25]
paladin
yes. sadly, as of 7/2005, Borland does not yet support 4.1x
[28 Jul 2005 0:30]
Mike Hillyer
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>
[2 Sep 2005 12:54]
Bugs System
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
[2 Sep 2005 18:25]
Sergei Golubchik
The patch is undone in 4.1.15
[9 Sep 2005 10:21]
Bugs System
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
[9 Sep 2005 21:51]
Paul DuBois
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.)
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