Details
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.