Note: Since we don't have any documented differences between our implementation of JSON functions and Oracle's, here and further I will assume they are supposed to be result-compatible.
MariaDB 10.2
MariaDB [test]> select JSON_MERGE( NULL ,JSON_OBJECT( 'foo' , 1));
+ ----------------------------------------+
| JSON_MERGE( NULL ,JSON_OBJECT( 'foo' , 1)) |
+ ----------------------------------------+
| [ null , { "foo" : 1}] |
+ ----------------------------------------+
1 row in set (0.00 sec)
MySQL 5.7
MySQL [test]> select JSON_MERGE( NULL ,JSON_OBJECT( 'foo' , 1));
+ ----------------------------------------+
| JSON_MERGE( NULL ,JSON_OBJECT( 'foo' , 1)) |
+ ----------------------------------------+
| NULL |
+ ----------------------------------------+
1 row in set (0.00 sec)
It is also documented in MySQL manual:https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html#function_json-merge
Returns NULL if any argument is NULL
relates to
MDEV-9143
JSON_xxx functions
Closed
made changes -
2016-12-01 18:47
Link
This issue relates to TODO-873
[ TODO-873
]
made changes -
2016-12-02 13:24
Component/s
JSON
[ 13908
]
Component/s
OTHER
[ 10125
]
made changes -
2016-12-05 21:58
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
2016-12-05 21:58
Fix Version/s
10.2.3
[ 22115
]
Fix Version/s
10.2
[ 14601
]
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Closed
[ 6
]
made changes -
2021-12-06 21:43
Workflow
MariaDB v3
[ 78552
]
MariaDB v4
[ 151276
]
{"report":{"fcp":1098,"ttfb":435.7000000476837,"pageVisibility":"visible","entityId":59152,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"13297fda-f3d1-4113-838e-bda20300d2bc","navigationType":0,"readyForUser":1169.7000000476837,"redirectCount":0,"resourceLoadedEnd":1341.8000000715256,"resourceLoadedStart":441.10000002384186,"resourceTiming":[{"duration":191.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":441.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":441.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":632.6000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":191.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":441.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":441.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":632.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":220.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":441.60000002384186,"connectEnd":441.60000002384186,"connectStart":441.60000002384186,"domainLookupEnd":441.60000002384186,"domainLookupStart":441.60000002384186,"fetchStart":441.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":441.60000002384186,"responseEnd":661.8000000715256,"responseStart":661.8000000715256,"secureConnectionStart":441.60000002384186},{"duration":304.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":441.8000000715256,"connectEnd":441.8000000715256,"connectStart":441.8000000715256,"domainLookupEnd":441.8000000715256,"domainLookupStart":441.8000000715256,"fetchStart":441.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":441.8000000715256,"responseEnd":746.2000000476837,"responseStart":746.2000000476837,"secureConnectionStart":441.8000000715256},{"duration":307.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":442,"connectEnd":442,"connectStart":442,"domainLookupEnd":442,"domainLookupStart":442,"fetchStart":442,"redirectEnd":0,"redirectStart":0,"requestStart":442,"responseEnd":749.5,"responseStart":749.5,"secureConnectionStart":442},{"duration":307.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":442.2000000476837,"connectEnd":442.2000000476837,"connectStart":442.2000000476837,"domainLookupEnd":442.2000000476837,"domainLookupStart":442.2000000476837,"fetchStart":442.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":442.2000000476837,"responseEnd":750,"responseStart":750,"secureConnectionStart":442.2000000476837},{"duration":308,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":442.3000000715256,"connectEnd":442.3000000715256,"connectStart":442.3000000715256,"domainLookupEnd":442.3000000715256,"domainLookupStart":442.3000000715256,"fetchStart":442.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":442.3000000715256,"responseEnd":750.3000000715256,"responseStart":750.3000000715256,"secureConnectionStart":442.3000000715256},{"duration":357.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":442.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":442.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":799.5,"responseStart":0,"secureConnectionStart":0},{"duration":308.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":442.60000002384186,"connectEnd":442.60000002384186,"connectStart":442.60000002384186,"domainLookupEnd":442.60000002384186,"domainLookupStart":442.60000002384186,"fetchStart":442.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":442.60000002384186,"responseEnd":750.8000000715256,"responseStart":750.8000000715256,"secureConnectionStart":442.60000002384186},{"duration":356.89999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":442.8000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":442.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":799.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":308.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":442.90000009536743,"connectEnd":442.90000009536743,"connectStart":442.90000009536743,"domainLookupEnd":442.90000009536743,"domainLookupStart":442.90000009536743,"fetchStart":442.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":442.90000009536743,"responseEnd":751.3000000715256,"responseStart":751.3000000715256,"secureConnectionStart":442.90000009536743},{"duration":602.6999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":443.90000009536743,"connectEnd":443.90000009536743,"connectStart":443.90000009536743,"domainLookupEnd":443.90000009536743,"domainLookupStart":443.90000009536743,"fetchStart":443.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":443.90000009536743,"responseEnd":1046.6000000238419,"responseStart":1046.6000000238419,"secureConnectionStart":443.90000009536743},{"duration":884.6999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":447.90000009536743,"connectEnd":447.90000009536743,"connectStart":447.90000009536743,"domainLookupEnd":447.90000009536743,"domainLookupStart":447.90000009536743,"fetchStart":447.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":447.90000009536743,"responseEnd":1332.6000000238419,"responseStart":1332.6000000238419,"secureConnectionStart":447.90000009536743},{"duration":239.39999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":810.4000000953674,"connectEnd":810.4000000953674,"connectStart":810.4000000953674,"domainLookupEnd":810.4000000953674,"domainLookupStart":810.4000000953674,"fetchStart":810.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":810.4000000953674,"responseEnd":1049.8000000715256,"responseStart":1049.8000000715256,"secureConnectionStart":810.4000000953674},{"duration":276.7999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1056.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1056.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1333.5,"responseStart":0,"secureConnectionStart":0},{"duration":276.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1057.6000000238419,"connectEnd":1057.6000000238419,"connectStart":1057.6000000238419,"domainLookupEnd":1057.6000000238419,"domainLookupStart":1057.6000000238419,"fetchStart":1057.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":1057.6000000238419,"responseEnd":1334.3000000715256,"responseStart":1334.3000000715256,"secureConnectionStart":1057.6000000238419},{"duration":283.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1057.9000000953674,"connectEnd":1057.9000000953674,"connectStart":1057.9000000953674,"domainLookupEnd":1057.9000000953674,"domainLookupStart":1057.9000000953674,"fetchStart":1057.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1057.9000000953674,"responseEnd":1341.8000000715256,"responseStart":1341.8000000715256,"secureConnectionStart":1057.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":247,"responseStart":436,"responseEnd":440,"domLoading":439,"domInteractive":1358,"domContentLoadedEventStart":1358,"domContentLoadedEventEnd":1396,"domComplete":1693,"loadEventStart":1693,"loadEventEnd":1694,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1337.2000000476837},{"name":"bigPipe.sidebar-id.end","time":1337.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1338.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.end","time":1340.5},{"name":"activityTabFullyLoaded","time":1410.7000000476837}],"measures":[],"correlationId":"e097780add773f","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":129,"dbReadsTimeInMs":21,"dbConnsTimeInMs":30,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
MDEV-9143 JSON_xxx functions
