--source ../include/have_columnstore.inc
--disable_warnings
DROP DATABASE IF EXISTS json_equals_db;
--enable_warnings

CREATE DATABASE json_equals_db; 
USE json_equals_db;
--echo # ----------------------------------------------------------------------
--echo # Test of JSON_EQUALS function.
--echo # ----------------------------------------------------------------------
--echo # Return 1 
CREATE TABLE t1(l LONGTEXT, r LONGTEXT) ENGINE = columnstore;
INSERT INTO t1 VALUES('{"a":1,"b":2}','{"a":1,"b":2}');
INSERT INTO t1 VALUES('{"a":1,"b":2}','{"b":2,"a":1}');
INSERT INTO t1 VALUES('{"a":1,"b":2}','{"a":  1,"b":  2}');
INSERT INTO t1 VALUES('{"a":    1,"b":2}','{"b":2,"a":1}');
INSERT INTO t1 VALUES('[1,2]','[1,2]');
INSERT INTO t1 VALUES('[1,2]','[1   ,  2]');
INSERT INTO t1 VALUES(1,1);
SELECT JSON_EQUALS(l, r) FROM t1;
--echo # Return 0
TRUNCATE t1;
INSERT INTO t1 VALUES('{"a":1,"b":3}','{"a":1,"b":2}');
INSERT INTO t1 VALUES('[1,2]','[2,1]');
INSERT INTO t1 VALUES(1,2);
SELECT JSON_EQUALS(l, r) FROM t1;
--echo # NULL
TRUNCATE t1;
INSERT INTO t1 VALUES('["a",true,{"e":false},null','["a",true,{"e":false},null');
INSERT INTO t1 VALUES('s1',"s1");
SELECT JSON_EQUALS(l, r) FROM t1;

DROP TABLE t1;
DROP DATABASE json_equals_db;