Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
Background is this question on stackexchange:
https://dba.stackexchange.com/questions/208481/mariadb-compare-json
The task is to provide a function that can be used to compare 2 json documents for equality, then name can be e.g JSON_NORMALIZE
JSON_COMPACT already takes care of removing spaces, but this is not sufficient.
Keys need to be (recursively) sorted , and if spaces are removed, then documents can be compared as binary strings.
Attachments
Issue Links
- relates to
-
MDEV-28922 JSON_NORMALIZE handling of duplicate keys
-
- Open
-
-
-
- Closed
-
-
-
- Confirmed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Background is this question on stackexchange:
https://dba.stackexchange.com/questions/208481/mariadb-compare-json The task is to provide a function that can be used to compare 2 json documents for equality, then name can be e.g JSON_NORMALIZE JSON_COMPACT already takes care of removing spaces, but this is not sufficient. Keys need to be (recursively) sorted , and if spaces are removed, then equal documents can be compared as binary strings. |
Background is this question on stackexchange:
https://dba.stackexchange.com/questions/208481/mariadb-compare-json The task is to provide a function that can be used to compare 2 json documents for equality, then name can be e.g JSON_NORMALIZE JSON_COMPACT already takes care of removing spaces, but this is not sufficient. Keys need to be (recursively) sorted , and if spaces are removed, then documents can be compared as binary strings. |
| Fix Version/s | 10.4 [ 22408 ] |
| Link |
This issue relates to |
| Labels | beginner-friendly |
| Labels | beginner-friendly | beginner-friendly gsoc21 |
| Assignee | Vicențiu Ciorbaru [ cvicentiu ] |
| Fix Version/s | 10.7.0 [ 26072 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Link | This issue relates to TODO-3118 [ TODO-3118 ] |
| Summary | Function to normalize a json value | Add JSON_NORMALIZE function to normalize JSON values |
| Workflow | MariaDB v3 [ 87633 ] | MariaDB v4 [ 133570 ] |
| Link | This issue blocks MENT-1456 [ MENT-1456 ] |
| Link | This issue relates to MDEV-28922 [ MDEV-28922 ] |
| Link | This issue relates to MDEV-29026 [ MDEV-29026 ] |