| Bug #118496 | Inserting data in JSON type, precision error | ||
|---|---|---|---|
| Submitted: | 20 Jun 8:54 | Modified: | 20 Jun 10:31 |
| Reporter: | Alice Alice | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: JSON | Severity: | S3 (Non-critical) |
| Version: | 8.0.41 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[20 Jun 9:22]
Alice Alice
Inserting data in JSON type, precision error
[20 Jun 10:31]
MySQL Verification Team
Hello Alice Alice, Thank you for the report and test case. IMHO this is duplicate of Bug #83954. Also, see Bug #116160 regards, Umesh
Description: Inserting data in JSON type, precision error How to repeat: mysql> CREATE TABLE `test1` ( -> `id` int NOT NULL AUTO_INCREMENT, -> `json_col` json DEFAULT NULL, -> PRIMARY KEY (`id`) -> ) ENGINE=InnoDB; Query OK, 0 rows affected (0.02 sec) mysql> insert into test1(json_col) values('{"id": 206, "name": "Str_9b8fae68", "value": 0.43434838152895533}'); Query OK, 1 row affected (0.01 sec) mysql> select * from test1; +----+------------------------------------------------------------------+ | id | json_col | +----+------------------------------------------------------------------+ | 1 | {"id": 206, "name": "Str_9b8fae68", "value": 0.4343483815289554} | +----+------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql>