Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
12.3
-
None
Description
First output is simple aliasing however the non-equal results is something more substantial
CURRENT_TEST: main.func_json_unicode_escape
|
--- /home/buildbot/src/mysql-test/main/func_json_unicode_escape.result 2026-07-21 05:31:43.000000000 +0000
|
+++ /home/buildbot/src/mysql-test/main/func_json_unicode_escape.reject 2026-07-21 06:02:24.596193105 +0000
|
@@ -41,21 +41,20 @@
|
1
|
SELECT JSON_CONTAINS(JSON_QUOTE(JSON_UNQUOTE('"A"')),
|
JSON_QUOTE(JSON_UNQUOTE(CAST(0x225C753030343122 AS CHAR))));
|
-JSON_CONTAINS(JSON_QUOTE(JSON_UNQUOTE('"A"')),
|
-JSON_QUOTE(JSON_UNQUOTE(CAST(0x225C753030343122 AS CHAR))))
|
+Name_exp_1
|
1
|
#
|
# More Unicode escape equivalences
|
#
|
# \u0048\u0065\u006C\u006C\u006F = "Hello"
|
SELECT JSON_CONTAINS('"Hello"', '"\\u0048\\u0065\\u006C\\u006C\\u006F"');
|
-JSON_CONTAINS('"Hello"', '"\\u0048\\u0065\\u006C\\u006C\\u006F"')
|
+Name_exp_1
|
1
|
SELECT JSON_EQUALS('"Hello"', '"\\u0048\\u0065\\u006C\\u006C\\u006F"');
|
JSON_EQUALS('"Hello"', '"\\u0048\\u0065\\u006C\\u006C\\u006F"')
|
1
|
SELECT JSON_OVERLAPS('"Hello"', '"\\u0048\\u0065\\u006C\\u006C\\u006F"');
|
-JSON_OVERLAPS('"Hello"', '"\\u0048\\u0065\\u006C\\u006C\\u006F"')
|
+Name_exp_1
|
1
|
# Mixed literal and escape in the same string: "H\u0065llo" = "Hello"
|
SELECT JSON_EQUALS('"Hello"', '"H\\u0065llo"');
|
@@ -83,23 +82,23 @@
|
#
|
SET NAMES utf8mb4;
|
SELECT JSON_EQUALS('"ð"', '"\\uD83D\\uDE00"');
|
-JSON_EQUALS('"?"', '"\\uD83D\\uDE00"')
|
-1
|
+JSON_EQUALS('"ðŸËâ¬"', '"\\uD83D\\uDE00"')
|
+0
|
SELECT JSON_CONTAINS('"ð"', '"\\uD83D\\uDE00"');
|
-JSON_CONTAINS('"?"', '"\\uD83D\\uDE00"')
|
-1
|
+JSON_CONTAINS('"ðŸËâ¬"', '"\\uD83D\\uDE00"')
|
+0
|
SELECT JSON_OVERLAPS('"ð"', '"\\uD83D\\uDE00"');
|
-JSON_OVERLAPS('"?"', '"\\uD83D\\uDE00"')
|
-1
|
+JSON_OVERLAPS('"ðŸËâ¬"', '"\\uD83D\\uDE00"')
|
+0
|
SELECT JSON_EQUALS('"ð"', '"\\uD83D\\uDE0A"');
|
-JSON_EQUALS('"?"', '"\\uD83D\\uDE0A"')
|
-1
|
+JSON_EQUALS('"ðŸËÅ "', '"\\uD83D\\uDE0A"')
|
+0
|
SELECT JSON_CONTAINS('["ð", "hello"]', '["\\uD83D\\uDE00"]');
|
-JSON_CONTAINS('["?", "hello"]', '["\\uD83D\\uDE00"]')
|
-1
|
+JSON_CONTAINS('["ðŸËâ¬", "hello"]', '["\\uD83D\\uDE00"]')
|
+0
|
SELECT JSON_EQUALS('{"emoji": "ð"}', '{"emoji": "\\uD83D\\uDE00"}');
|
-JSON_EQUALS('{"emoji": "?"}', '{"emoji": "\\uD83D\\uDE00"}')
|
-1
|
+JSON_EQUALS('{"emoji": "ðŸËâ¬"}', '{"emoji": "\\uD83D\\uDE00"}')
|
+0
|
#
|
# Escaped object keys: \u006B\u0065\u0079 = "key"
|
#
|
@@ -113,17 +112,17 @@
|
# BMP non-ASCII: é = U+00E9, literal UTF-8 vs escape
|
#
|
SELECT JSON_EQUALS('"é"', '"\\u00E9"');
|
-JSON_EQUALS('"é"', '"\\u00E9"')
|
-1
|
+JSON_EQUALS('"é"', '"\\u00E9"')
|
+0
|
SELECT JSON_CONTAINS('"é"', '"\\u00E9"');
|
-JSON_CONTAINS('"é"', '"\\u00E9"')
|
-1
|
+JSON_CONTAINS('"é"', '"\\u00E9"')
|
+0
|
SELECT JSON_OVERLAPS('["é"]', '["\\u00E9"]');
|
-JSON_OVERLAPS('["é"]', '["\\u00E9"]')
|
-1
|
+JSON_OVERLAPS('["é"]', '["\\u00E9"]')
|
+0
|
#
|
# CJK: ä¸ = U+4E2D
|
#
|
SELECT JSON_EQUALS('"ä¸"', '"\\u4E2D"');
|
-JSON_EQUALS('"ä¸"', '"\\u4E2D"')
|
-1
|
+JSON_EQUALS('"ä¸Â"', '"\\u4E2D"')
|
+0
|
|
|
Result length mismatch
|
Attachments
Issue Links
- relates to
-
MDBF-1201 add --view tests to branch protection
-
- Closed
-
-
MDEV-39995 JSON_CONTAINS and JSON_EQUALS do not compare string based on semantic
-
- Closed
-