dolthub / dolthub/dolt

Decimals in JSON columns are being improperly coerced into strings when inserted into tables.

Open
#7,199 1 comment 0 reactions 1 assignee Claimed by @zachmu View on GitHub
correctness json
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

Reproduction steps:

```sql
CREATE TABLE test(j json);
INSERT INTO test VALUES (JSON_OBJECT("a", 1.0));
SELECT * FROM test;
SELECT * FROM test WHERE j =JSON_OBJECT("a", 1.0);
```

MySQL output:
```
mysql> select * from test;
+------------+
| j |
+------------+
| {"a": 1.0} |
+------------+

mysql> SELECT * FROM test WHERE j =JSON_OBJECT("a", 1.0);
+------------+
| j |
+------------+
| {"a": 1.0} |
+------------+
```

Dolt output:
```
json> select * from test;
+------------+
| j |
+------------+
| {"a": "1"} |
+------------+

select * from test where j = JSON_OBJECT("a", 1.0);
Empty set (0.00 sec)
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.