DROP DATABASE IF EXISTS json_array_db;
CREATE DATABASE json_array_db;
USE json_array_db;
# ----------------------------------------------------------------------
# Test of JSON_ARRAY function.
# ----------------------------------------------------------------------
CREATE TABLE t1(l text) ENGINE = COLUMNSTORE;
INSERT INTO t1 VALUES('1');
SELECT JSON_ARRAY() FROM t1;
JSON_ARRAY()
[]
SELECT JSON_ARRAY(l) FROM t1;
JSON_ARRAY(l)
["1"]
SELECT JSON_ARRAY(l, null, 'My name is "Foo"', 3.1415, 6) FROM t1;
JSON_ARRAY(l, null, 'My name is "Foo"', 3.1415, 6)
["1", null, "My name is \"Foo\"", 3.1415, 6]
SELECT JSON_ARRAY(l, true, false, "true", "false") FROM t1;
JSON_ARRAY(l, true, false, "true", "false")
["1", true, false, "true", "false"]
SELECT JSON_ARRAY(l, '{"key1":"value1"}') FROM t1;
JSON_ARRAY(l, '{"key1":"value1"}')
["1", "{\"key1\":\"value1\"}"]
SELECT JSON_ARRAY(l, JSON_COMPACT( '{"key1":"value1"}' ) ) FROM t1;
JSON_ARRAY(l, JSON_COMPACT( '{"key1":"value1"}' ) )
["1", "{\"key1\":\"value1\"}"]
DROP TABLE t1;
DROP DATABASE json_array_db;