I didnt look into drizzle code. All I can tell is that when we return non-corrupted buffer which can be tested by running the first set of SELECTs multiple times - it will always return the correct value, but once you call a date-time function on the previous field (text_fld) the buffer of blob_fld gets corrupted and the returned value will always be "" (unless it's refreshed in pbxt's internal cache or server is restarted).
Jay,
I didnt look into drizzle code. All I can tell is that when we return non-corrupted buffer which can be tested by running the first set of SELECTs multiple times - it will always return the correct value, but once you call a date-time function on the previous field (text_fld) the buffer of blob_fld gets corrupted and the returned value will always be "" (unless it's refreshed in pbxt's internal cache or server is restarted).