Bug #19017 | GetBytes Error | ||
---|---|---|---|
Submitted: | 11 Apr 2006 17:35 | Modified: | 22 May 2006 21:22 |
Reporter: | Charlie Mason | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / NET | Severity: | S2 (Serious) |
Version: | 1.0.7 | OS: | Windows (XP SP2) |
Assigned to: | CPU Architecture: | Any |
[11 Apr 2006 17:35]
Charlie Mason
[18 Apr 2006 15:19]
Tonci Grgin
Hi. Thanks for your problem report. A sql script containing data and structure would be nice. Also some info on server like character sets used. Can you make a small sample program demonstrating this problem using sql script which you'll provide? In the meantime, here are some links to check: http://bugs.mysql.com/bug.php?id=4324 http://bugs.mysql.com/bug.php?id=6323 http://bugs.mysql.com/bug.php?id=7704 http://bugs.mysql.com/bug.php?id=11115
[18 Apr 2006 16:44]
Charlie Mason
A c# test case and sql script demonstrating the bug
Attachment: MYSQL Connector Bug Test Case.zip (application/x-zip-compressed, text), 99.46 KiB.
[21 Apr 2006 16:57]
Charlie Mason
I have looked at the list of other bugs you supplied. It seems to be unrelated to those as the symptoms are quite different. Its seems dependent on the oder the blob coloumn appears in the SELECT satement. The test case I uploaded demonstrates both the bug and the work around. I have included an SQL script to make it very simple to reproduce the bug.
[21 Apr 2006 19:27]
Tonci Grgin
Hi. Thanks for great test case. So far I agree with you.
[21 Apr 2006 20:04]
Tonci Grgin
Hi Charlie. This turned out to be not BLOB issue at all. Try "ALTER TABLE artwork CHANGE imageSize imagesize int" (UNSIGNED, NOT NULL as you like) and all works. It seems mediumint processing is broken. Will investigate further.
[24 Apr 2006 5:04]
Tonci Grgin
Verified as described by user using test case provided on latest connector version.
[26 Apr 2006 12:39]
Charlie Mason
Thanks for for looking in to the bug. It was the first time I had used the .Net connector's GetBytes method. For a good 30 mins or so I was somewhat confused, before I realised it must be a bug. I have just used the work around demonstarted in the test case, which seems to be work fine, after more testing.
[22 May 2006 21:22]
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 1.0.8