--source ../include/have_columnstore.inc
--disable_warnings

DROP DATABASE IF EXISTS json_keys_db;
--enable_warnings

CREATE DATABASE json_keys_db; 
USE json_keys_db;
--echo # ----------------------------------------------------------------------
--echo # Test of JSON_KEYS function.
--echo # ----------------------------------------------------------------------
CREATE TABLE t1(l TEXT) ENGINE = columnstore;
INSERT INTO t1 VALUES('{"key1":"value1", "key2":{"key3": "value2"}}');
INSERT INTO t1 VALUES('{"key1":"value1", "key2":{"key3": "value3", "key4":"value4"}}');
INSERT INTO t1 VALUES('{"key1":"value1" "key2":{"key3": "value3", "key4":"value4"}}');
SELECT JSON_KEYS(l) from t1;
SELECT JSON_KEYS(l, '$.key2') from t1;
SELECT JSON_KEYS(l, '$.key1') from t1;
SELECT JSON_KEYS(l, '$.key123') from t1;
DROP TABLE t1;
DROP DATABASE json_keys_db;