| Bug #35041 | 'Binary(16) as GUID' - columns lose IsGuid value after a NULL value found | ||
|---|---|---|---|
| Submitted: | 4 Mar 2008 17:53 | Modified: | 16 May 2008 15:19 |
| Reporter: | Tim Faust | ||
| Status: | Closed | ||
| Category: | Connector/Net | Severity: | S2 (Serious) |
| Version: | 5.2.1 | OS: | Microsoft Windows (Vista) |
| Assigned to: | Target Version: | ||
If the data you need to attach is more than 500KB, you should create
a compressed archive of the data and a README file that describes the data
with a filename that includes the bug number (example:
bug-data-35041.zip), and use FTP to upload the archive
to ftp://ftp.mysql.com/pub/mysql/upload/.
Once you have uploaded the file, add a comment to this bug to notify us about
it. Note: This directory is unlistable, which means that once you
have uploaded your file, you will not be able to see it.
All entries become the exclusive editorial property of Sun Microsystems, Inc.
[4 Mar 2008 17:54]
Tim Faust
[4 Mar 2008 17:54]
Tim Faust
sample table
Attachment: guidtesttbl.sql (application/octet-stream, text), 207 bytes.
[4 Mar 2008 17:55]
Tim Faust
inserts test rows into the table to recreate problem
Attachment: guidtestinserts.sql (application/octet-stream, text), 207 bytes.
[4 Mar 2008 17:55]
Tim Faust
helper function to convert GUIDs into Binary(16)
Attachment: FNC_CONVERT_CHAR_TO_UUID.sql (application/octet-stream, text), 338 bytes.
[4 Mar 2008 17:56]
Tim Faust
patched code to fix problem
Attachment: MySqlBinary.cs (text/plain), 6.26 KiB.
