Details
Description
CREATE TABLE t (f varchar(1)); |
INSERT INTO t VALUES ('a'),('b'); |
SELECT JSON_OBJECTAGG(f, f) AS ff FROM t HAVING (ff != 'foo' AND ff != 'bar'); |
Actual result, 10.5 baca5265 |
MariaDB [test]> SELECT JSON_OBJECTAGG(f, f) AS ff FROM t HAVING (ff != 'foo' AND ff != 'bar'); |
+----------------------+ |
| ff |
|
+----------------------+ |
| {"a":"a", "b":"b"}}} | |
+----------------------+ |
1 row in set (0.002 sec) |
Attachments
Issue Links
- relates to
-
MDEV-23069 Duplicate square brackets in JSON_ARRAYAGG upon query with HAVING
- Confirmed