MySQL Bugs: #111006: DOUBLE type in database has 6 digit precision despite double type capable of 15,

Bug #111006	DOUBLE type in database has 6 digit precision despite double type capable of 15,
Submitted:	11 May 2023 20:22	Modified:	30 Jun 2024 12:52
Reporter:	Rich Lowe	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / C++	Severity:	S1 (Critical)
Version:	8.0 latest build as of 5/11/23	OS:	Windows
Assigned to:	MySQL Verification Team	CPU Architecture:	x86

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

Node.js example code using MySQL npm library by way of mysql-await library

Attachment: Node.js code.png (image/png, text), 72.72 KiB.

Node.js output showing full double value returned

Attachment: Node.js output.png (image/png, text), 17.57 KiB.

C++ example code

Attachment: cpp-code.png (image/png, text), 209.31 KiB.

C++ example output

Attachment: cpp-output.png (image/png, text), 4.03 KiB.

C++ test output with no insert, just select of Node.js inserted double

Attachment: test output only selecting node.js inserted double.png (image/png, text), 7.73 KiB.

Select from MySQL workbench of C++ inserted double

Attachment: select of C++ inserted double.png (image/png, text), 88.84 KiB.

Select from MySQL workbench of Node.js inserted double

Attachment: select of node.js inserted double.png (image/png, text), 109.99 KiB.

Double selected by C++  from (top) Node.js inserted double (bottom) C++ inserted double

Attachment: final example where double selected in C++ inserted from a. node.js and b. c++.png (image/png, text), 32.08 KiB.