1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-06-13 16:01:32 +03:00
Files
mariadb-columnstore-engine/mysql-test/columnstore/bugfixes/MCOL-5842-group-concat-json-object.test
Serguey Zefirov e37d621a12 fix(MCOL-5842): Fix JSON_OBJECT's handling of empty strings
JSON_OBJECT() (and probably some other JSON functions) now properly
handle empty strings in their arguments - JSON_OBJECT used to return
NULL, now it returns empty string.
2025-02-28 17:17:16 +04:00

13 lines
322 B
Plaintext

--disable_warnings
DROP DATABASE IF EXISTS MCOL5842;
--enable_warnings
CREATE DATABASE MCOL5842;
USE MCOL5842;
CREATE TABLE tcs(t TEXT) ENGINE=Columnstore;
INSERT INTO tcs(t) VALUES ('');
SELECT JSON_OBJECT('t', t, 'a', 'b') FROM tcs;
SELECT GROUP_CONCAT(JSON_OBJECT('t', t, 'a', 'b')) FROM tcs;
DROP DATABASE MCOL5842;