tk.MustExec(`CREATE TABLE t (
		a int(11),
		b varchar(100),
		c decimal(3,2),
		d json,
		e date,
		f time,
		g datetime DEFAULT '2012-01-01',
		h timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
		i char(36),
		j text(50));`)

	tk.MustExec(`insert into t values(1, 'ab', 5.5, '{"id": 1}', '2020-01-10', '11:12:13', '2020-01-11', '0000-00-00 00:00:00', 'first', 'json_arrayagg_test');`)

	result := tk.MustQuery("select a, json_arrayagg(b) from t group by a order by a;")
	result.Check(testkit.Rows(`1 ["ab"]`))
	result = tk.MustQuery("select b, json_arrayagg(c) from t group by b order by b;")
	result.Check(testkit.Rows(`ab [5.5]`))
	result = tk.MustQuery("select e, json_arrayagg(f) from t group by e order by e;")
	result.Check(testkit.Rows(`2020-01-10 ["11:12:13"]`))
	result = tk.MustQuery("select f, json_arrayagg(g) from t group by f order by f;")
	result.Check(testkit.Rows(`11:12:13 ["2020-01-11 00:00:00"]`))
	result = tk.MustQuery("select g, json_arrayagg(h) from t group by g order by g;")
	result.Check(testkit.Rows(`2020-01-11 00:00:00 ["0000-00-00 00:00:00"]`))
	result = tk.MustQuery("select h, json_arrayagg(i) from t group by h order by h;")
	result.Check(testkit.Rows(`0000-00-00 00:00:00 ["first"]`))
	result = tk.MustQuery("select i, json_arrayagg(j) from t group by i order by i;")
	result.Check(testkit.Rows(`first ["json_arrayagg_test"]`))
	result = tk.MustQuery("select json_arrayagg(23) from t group by a order by a;")
	result.Check(testkit.Rows(`[23]`))
	result = tk.MustQuery("select json_arrayagg(null) from t group by a order by a;")
	result.Check(testkit.Rows(`[null]`))