MySQL Bugs: #96478: Incorrect blob handling on select operation

Bug #96478	Incorrect blob handling on select operation
Submitted:	8 Aug 2019 20:44	Modified:	17 Sep 2019 20:30
Reporter:	Marcio Reis	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector for Node.js	Severity:	S2 (Serious)
Version:	8.0.17	OS:	Any
Assigned to:	Rui Quelhas	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Reading operations return strings instead of buffers. 
Also, strings returned cannot be converted back to buffers because they don't actually match the original blob content. 

How to repeat:
SELECT BLOB FROM TABLE is enough.

Suggested fix:
Return a Buffer

Posted by developer:
 
Fixed as of the upcoming MySQL Connector/Node.js 8.0.18 release, and here's the changelog entry:

MySQL column binary values (such as BLOB, BINARY, and VARBINARY) can now
convert to proper Node.js Buffer instances.

Thank you for the bug report.