© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
bbfa235
(Get the code!)
I looked into this before the conference as well. As far as I can tell the problem is that somewhere in Drizzle a zero terminator is being set in order to do the conversion of the 'text_fld' field to a HOUR value.
So the zero terminator overwrites one byte in the buffer. In the case of PBXT this buffer is pointing directly into the PBXT sequential scan buffer cache.
The byte happens to be the size of the second BLOB (blob_fld) which follow directly after text_fld. So the this overwrite set the size of the value in the blob_fld field to zero.
And that is why the error occurs.
I presume InnoDB returns a pointer to a copy of the data, and therefore this overwrite does not affect it.