Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.7(EOL), 10.8(EOL)
-
None
-
Not for Release Notes
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a INT ZEROFILL); |
INSERT INTO t1 VALUES (1); |
SELECT JSON_OBJECT('a',a), JSON_VALID(JSON_OBJECT('a',a)) FROM t1; |
+--------------------+--------------------------------+
|
| JSON_OBJECT('a',a) | JSON_VALID(JSON_OBJECT('a',a)) |
|
+--------------------+--------------------------------+
|
| {"a": 0000000001} | 0 |
|
+--------------------+--------------------------------+
|
Notice, the constructed JSON value is wrong. The 0000000001 literal should probably be quoted.
Attachments
Issue Links
- is duplicated by
-
MDEV-30962 JSON_OBJECT function generates "malformed" JSON with ZEROFILL type
-
- Confirmed
-