Update tests and documentation

Avogar · Avogar · commit 39d687f1b7f4 · 2024-12-11T17:36:15.000Z
diff --git a/docs/en/sql-reference/data-types/newjson.md b/docs/en/sql-reference/data-types/newjson.md
@@ -694,6 +694,39 @@ SELECT json, json.a, json.b, json.c FROM test;
 └──────────────────────────────┴────────┴─────────┴────────────┘
 ```
 
+## Comparison between values of the JSON type
+
+Values of the `JSON` column cannot be compared by `less/greater` functions, but can be compared using `equal` function.
+Two JSON objects considered equal when they have the same set of paths and value of each path have the same type and value in both objects.
+
+Example:
+```sql
+CREATE TABLE test (json1 JSON(a UInt32), json2 JSON(a UInt32)) ENGINE=Memory;
+INSERT INTO test FORMAT JSONEachRow
+{"json1" : {"a" : 42, "b" : 42, "c" : "Hello"}, "json2" : {"a" : 42, "b" : 42, "c" : "Hello"}}
+{"json1" : {"a" : 42, "b" : 42, "c" : "Hello"}, "json2" : {"a" : 43, "b" : 42, "c" : "Hello"}}
+{"json1" : {"a" : 42, "b" : 42, "c" : "Hello"}, "json2" : {"a" : 43, "b" : 42, "c" : "Hello"}}
+{"json1" : {"a" : 42, "b" : 42, "c" : "Hello"}, "json2" : {"a" : 42, "b" : 42, "c" : "World"}}
+{"json1" : {"a" : 42, "b" : [1, 2, 3], "c" : "Hello"}, "json2" : {"a" : 42, "b" : 42, "c" : "Hello"}}
+{"json1" : {"a" : 42, "b" : 42.0, "c" : "Hello"}, "json2" : {"a" : 42, "b" : 42, "c" : "Hello"}}
+{"json1" : {"a" : 42, "b" : "42", "c" : "Hello"}, "json2" : {"a" : 42, "b" : 42, "c" : "Hello"}};
+
+SELECT json1, json2, json1 == json2 FROM test;
+```
+
+```text
+┌─json1──────────────────────────────────┬─json2─────────────────────────┬─equals(json1, json2)─┐
+│ {"a":42,"b":"42","c":"Hello"}          │ {"a":42,"b":"42","c":"Hello"} │                    1 │
+│ {"a":42,"b":"42","c":"Hello"}          │ {"a":43,"b":"42","c":"Hello"} │                    0 │
+│ {"a":42,"b":"42","c":"Hello"}          │ {"a":43,"b":"42","c":"Hello"} │                    0 │
+│ {"a":42,"b":"42","c":"Hello"}          │ {"a":42,"b":"42","c":"World"} │                    0 │
+│ {"a":42,"b":["1","2","3"],"c":"Hello"} │ {"a":42,"b":"42","c":"Hello"} │                    0 │
+│ {"a":42,"b":42,"c":"Hello"}            │ {"a":42,"b":"42","c":"Hello"} │                    0 │
+│ {"a":42,"b":"42","c":"Hello"}          │ {"a":42,"b":"42","c":"Hello"} │                    0 │
+└────────────────────────────────────────┴───────────────────────────────┴──────────────────────┘
+```
+
+
 ## Tips for better usage of the JSON type
 
 Before creating `JSON` column and loading data into it, consider the following tips:
diff --git a/tests/queries/0_stateless/03282_json_equal_comparison.reference b/tests/queries/0_stateless/03282_json_equal_comparison.reference
@@ -1,16 +1,16 @@
-{"a":0}	{"a":0}	1
-{"a":42}	{"a":42}	1
-{"a":42}	{"a":43}	0
-{"a":42,"b":"42"}	{"a":42,"b":"42"}	1
-{"a":42,"b":"42"}	{"a":42,"b":"43"}	0
-{"a":42,"b":"42","c":"42"}	{"a":42,"b":"42","d":"42"}	0
-{"a":42,"b":"42","c":"42","d":"42"}	{"a":42,"b":"42","c":"42","d":"42"}	1
-{"a":42,"b":"42","c":"42","d":"42"}	{"a":42,"b":"42","c":"42","d":"43"}	0
-{"a":42,"b":"42","c":"42","d":"42"}	{"a":42,"b":"42","c":"43","d":"42"}	0
-{"a":42,"b":"42","d":"42"}	{"a":42,"b":"42","d":"42"}	1
-{"a":42,"b":"42","d":"42"}	{"a":42,"b":"42","c":"42","d":"42"}	0
-{"a":42,"b":"42","c":"42"}	{"a":42,"b":"42","c":"42"}	1
-{"a":42,"b":"42","c":"42"}	{"a":42,"b":"42","c":"42","d":"42"}	0
-{"a":42,"b":"42","c":"42","d":"42","e":"42"}	{"a":42,"b":"42","c":"42","d":"42","e":"42"}	1
-{"a":42,"b":"42","c":"42","d":"42","e":"42"}	{"a":42,"b":"42","c":"42","d":"42","e":"42"}	0
-{"a":42,"b":"42","c":"42","d":"42","e":"42"}	{"a":42,"b":"42","c":"42","d":"42","e":42}	0
+{"a":0}	{"a":0}	1	0
+{"a":42}	{"a":42}	1	0
+{"a":42}	{"a":43}	0	1
+{"a":42,"b":"42"}	{"a":42,"b":"42"}	1	0
+{"a":42,"b":"42"}	{"a":42,"b":"43"}	0	1
+{"a":42,"b":"42","c":"42"}	{"a":42,"b":"42","d":"42"}	0	1
+{"a":42,"b":"42","c":"42","d":"42"}	{"a":42,"b":"42","c":"42","d":"42"}	1	0
+{"a":42,"b":"42","c":"42","d":"42"}	{"a":42,"b":"42","c":"42","d":"43"}	0	1
+{"a":42,"b":"42","c":"42","d":"42"}	{"a":42,"b":"42","c":"43","d":"42"}	0	1
+{"a":42,"b":"42","d":"42"}	{"a":42,"b":"42","d":"42"}	1	0
+{"a":42,"b":"42","d":"42"}	{"a":42,"b":"42","c":"42","d":"42"}	0	1
+{"a":42,"b":"42","c":"42"}	{"a":42,"b":"42","c":"42"}	1	0
+{"a":42,"b":"42","c":"42"}	{"a":42,"b":"42","c":"42","d":"42"}	0	1
+{"a":42,"b":"42","c":"42","d":"42","e":"42"}	{"a":42,"b":"42","c":"42","d":"42","e":"42"}	1	0
+{"a":42,"b":"42","c":"42","d":"42","e":"42"}	{"a":42,"b":"42","c":"42","d":"42","e":"42"}	0	1
+{"a":42,"b":"42","c":"42","d":"42","e":"42"}	{"a":42,"b":"42","c":"42","d":"42","e":42}	0	1
diff --git a/tests/queries/0_stateless/03282_json_equal_comparison.sql b/tests/queries/0_stateless/03282_json_equal_comparison.sql
@@ -18,5 +18,5 @@ insert into test format JSONEachRow
 {"json1" : {"a" : 42, "b" : 42, "c" : 42, "d" : 42, "e" : 42}, "json2" : {"a" : 42, "b" : 42, "d" : 42, "c" : 42, "e" : "42"}}
 {"json1" : {"a" : 42, "b" : 42, "c" : 42, "d" : 42, "e" : 42}, "json2" : {"a" : 42, "b" : 42, "d" : 42, "c" : 42, "e" : 42.0}};
 
-select json1, json2, json1 == json2 from test;
+select json1, json2, json1 == json2, json1 != json2 from test;
 drop table test;
