Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
-
None
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.