1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-18 21:44:02 +03:00
mariadb-columnstore-engine/mysql-test/columnstore/bugfixes/MCOL-5842-group-concat-json-object.test
Serguey Zefirov 4b7016e67b 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-03-04 12:56:33 +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;