mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-18 21:44:02 +03:00
cdd41f05f3
The following functions are created: Create function JSON_VALID and test cases Create function JSON_DEPTH and test cases Create function JSON_LENGTH and test cases Create function JSON_EQUALS and test cases Create function JSON_NORMALIZE and test cases Create function JSON_TYPE and test cases Create function JSON_OBJECT and test cases Create function JSON_ARRAY and test cases Create function JSON_KEYS and test cases Create function JSON_EXISTS and test cases Create function JSON_QUOTE/JSON_UNQUOTE and test cases Create function JSON_COMPACT/DETAILED/LOOSE and test cases Create function JSON_MERGE and test cases Create function JSON_MERGE_PATCH and test cases Create function JSON_VALUE and test cases Create function JSON_QUERY and test cases Create function JSON_CONTAINS and test cases Create function JSON_ARRAY_APPEND and test cases Create function JSON_ARRAY_INSERT and test cases Create function JSON_INSERT/REPLACE/SET and test cases Create function JSON_REMOVE and test cases Create function JSON_CONTAINS_PATH and test cases Create function JSON_OVERLAPS and test cases Create function JSON_EXTRACT and test cases Create function JSON_SEARCH and test cases Note: Some functions output differs from MDB because session variables that affects functions output,e.g JSON_QUOTE/JSON_UNQUOTE This depends on MCOL-5212
45 lines
1.2 KiB
Plaintext
45 lines
1.2 KiB
Plaintext
DROP DATABASE IF EXISTS json_equals_db;
|
|
CREATE DATABASE json_equals_db;
|
|
USE json_equals_db;
|
|
# ----------------------------------------------------------------------
|
|
# Test of JSON_EQUALS function.
|
|
# ----------------------------------------------------------------------
|
|
# 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;
|
|
JSON_EQUALS(l, r)
|
|
1
|
|
1
|
|
1
|
|
1
|
|
1
|
|
1
|
|
1
|
|
# 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;
|
|
JSON_EQUALS(l, r)
|
|
0
|
|
0
|
|
0
|
|
# 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;
|
|
JSON_EQUALS(l, r)
|
|
NULL
|
|
NULL
|
|
DROP TABLE t1;
|
|
DROP DATABASE json_equals_db;
|