-
Task
-
-
Major
-
Resolution:
Fixed
-
-
-
JSON_CONTAINS can be used to test for JSON object equality in some cases, but we seem to lack a clear JSON_EQUALS function.
Sergei Golubchik
made changes -
|
Labels
|
JSON
|
JSON beginner-friendly
|
Vicențiu Ciorbaru
made changes -
|
Labels
|
JSON beginner-friendly
|
JSON beginner-friendly gsoc21
|
Robert Bindar
made changes -
|
Assignee
|
|
Vicențiu Ciorbaru
[ cvicentiu
]
|
Sergei Golubchik
made changes -
|
Component/s
|
|
JSON
[ 13908
]
|
|
Component/s
|
Data types
[ 13906
]
|
|
|
Fix Version/s
|
|
10.7.0
[ 26072
]
|
|
Resolution
|
|
Fixed
[ 1
]
|
|
Status
|
Open
[ 1
]
|
Closed
[ 6
]
|
Sergei Golubchik
made changes -
|
Link
|
|
This issue relates to TODO-3118
[ TODO-3118
]
|
Roel Van de Paar
made changes -
|
Summary
|
missing a JSON_EQUALS function
|
Add JSON_EQUALS function
|
Roel Van de Paar
made changes -
|
Summary
|
Add JSON_EQUALS function
|
Add JSON_EQUALS function to check JSON equality
|
Sergei Golubchik
made changes -
|
Workflow
|
MariaDB v3
[ 111107
]
|
MariaDB v4
[ 134306
]
|
{"report":{"fcp":1894.4000000953674,"ttfb":712.5999999046326,"pageVisibility":"visible","entityId":89398,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"5817920c-040c-430c-93a1-f68bbb78000a","navigationType":0,"readyForUser":2012.9000000953674,"redirectCount":0,"resourceLoadedEnd":1561.3000001907349,"resourceLoadedStart":724.1999998092651,"resourceTiming":[{"duration":113.2000002861023,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":724.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":724.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":837.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":113.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":724.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":724.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":837.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":375.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":724.6999998092651,"connectEnd":724.6999998092651,"connectStart":724.6999998092651,"domainLookupEnd":724.6999998092651,"domainLookupStart":724.6999998092651,"fetchStart":724.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":833.6999998092651,"responseEnd":1100.1999998092651,"responseStart":860,"secureConnectionStart":724.6999998092651},{"duration":821.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":724.9000000953674,"connectEnd":724.9000000953674,"connectStart":724.9000000953674,"domainLookupEnd":724.9000000953674,"domainLookupStart":724.9000000953674,"fetchStart":724.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":833.8000001907349,"responseEnd":1546,"responseStart":856.9000000953674,"secureConnectionStart":724.9000000953674},{"duration":127.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":725,"connectEnd":725,"connectStart":725,"domainLookupEnd":725,"domainLookupStart":725,"fetchStart":725,"redirectEnd":0,"redirectStart":0,"requestStart":834,"responseEnd":852.4000000953674,"responseStart":848.0999999046326,"secureConnectionStart":725},{"duration":141.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":725.3000001907349,"connectEnd":725.3000001907349,"connectStart":725.3000001907349,"domainLookupEnd":725.3000001907349,"domainLookupStart":725.3000001907349,"fetchStart":725.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":834,"responseEnd":866.8000001907349,"responseStart":863.1999998092651,"secureConnectionStart":725.3000001907349},{"duration":141.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":725.5,"connectEnd":725.5,"connectStart":725.5,"domainLookupEnd":725.5,"domainLookupStart":725.5,"fetchStart":725.5,"redirectEnd":0,"redirectStart":0,"requestStart":834.0999999046326,"responseEnd":866.5999999046326,"responseStart":862.3000001907349,"secureConnectionStart":725.5},{"duration":112.2000002861023,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":725.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":725.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":837.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":141.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":725.8000001907349,"connectEnd":725.8000001907349,"connectStart":725.8000001907349,"domainLookupEnd":725.8000001907349,"domainLookupStart":725.8000001907349,"fetchStart":725.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":843.0999999046326,"responseEnd":867,"responseStart":865.3000001907349,"secureConnectionStart":725.8000001907349},{"duration":113,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":726,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":726,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":839,"responseStart":0,"secureConnectionStart":0},{"duration":152.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":726.1999998092651,"connectEnd":726.1999998092651,"connectStart":726.1999998092651,"domainLookupEnd":726.1999998092651,"domainLookupStart":726.1999998092651,"fetchStart":726.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":847.0999999046326,"responseEnd":878.5999999046326,"responseStart":867.0999999046326,"secureConnectionStart":726.1999998092651},{"duration":809.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":747.5,"connectEnd":747.5,"connectStart":747.5,"domainLookupEnd":747.5,"domainLookupStart":747.5,"fetchStart":747.5,"redirectEnd":0,"redirectStart":0,"requestStart":943.3000001907349,"responseEnd":1556.5999999046326,"responseStart":1530.6999998092651,"secureConnectionStart":747.5},{"duration":813.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":747.5,"connectEnd":747.5,"connectStart":747.5,"domainLookupEnd":747.5,"domainLookupStart":747.5,"fetchStart":747.5,"redirectEnd":0,"redirectStart":0,"requestStart":1048.6999998092651,"responseEnd":1561.3000001907349,"responseStart":1533,"secureConnectionStart":747.5},{"duration":313.19999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1335.8000001907349,"connectEnd":1335.8000001907349,"connectStart":1335.8000001907349,"domainLookupEnd":1335.8000001907349,"domainLookupStart":1335.8000001907349,"fetchStart":1335.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1618.6999998092651,"responseEnd":1649,"responseStart":1647.6999998092651,"secureConnectionStart":1335.8000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":542,"responseStart":712,"responseEnd":740,"domLoading":719,"domInteractive":2133,"domContentLoadedEventStart":2133,"domContentLoadedEventEnd":2191,"domComplete":3325,"loadEventStart":3325,"loadEventEnd":3325,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2077.300000190735},{"name":"bigPipe.sidebar-id.end","time":2078.199999809265},{"name":"bigPipe.activity-panel-pipe-id.start","time":2078.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":2082.4000000953674},{"name":"activityTabFullyLoaded","time":2225.9000000953674}],"measures":[],"correlationId":"5e769db0c5b19b","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":115,"dbReadsTimeInMs":21,"dbConnsTimeInMs":30,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
MDEV-26678 JSON_EQUALS validates invalid JSON and valid JSON as being equal when using a backslash
