Bug #119522 json类型数据写入"port":"9.000910091019099e267"，显示"port":"9.0009100910191e267"

• Submitted: 8 Dec 2025 7:30
• Modified: 13 Jan 20:47
• Reporter: feixiang liu
• Status: Not a Bug
• Category: MySQL Server: JSON
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any
• Tags: json, 数据安全

[8 Dec 2025 7:30] feixiang liu

Description:
json类型数据写入"port":"9.000910091019099e267"，显示"port":"9.0009100910191e267".
数据不一致

How to repeat:
create table test01(id int primary key,name json,name01 varchar(21));
insert into test01 values(1,'"port":"9.000910091019099e267"',"9.000910091019099e267");
select * from test01;

[13 Jan 20:47] Øystein Grøvlen

Thank you for your bug report.
However, you are not using correct JSON syntax:

> insert into test01 values(1,'"port":"9.000910091019099e267"',"9.000910091019099e267");
ERROR 3140 (22032): Invalid JSON text: "The document root must not be followed by other values." at position 6 in value for column 'test01.name'.

> insert into test01 values(1,'{"port":"9.000910091019099e267"}',"9.000910091019099e267");
Query OK, 1 row affected (0.001 sec)