Dear colleagues, my name is Smail and I'm new to this community and I hope you go easy on me.
I'm using MySql for 7 years now, even before MariaDb was a thing.
We believed Monty and migrated immediately, but since then nothing happened.
PostgreSql is way ahead of you these days, I would have migrated again, if our system was small.
Recently I was excited about the upcoming features namely "Window Functions" and JSON, but then I was disappointed when I found out that you don't plan to support JSON DATA TYPE (MySql 5.7.8).
Dynamic Column != JSON, they don't have anything in common.
If I have to create columns, why would I use JSON, I can just create normal tables.
engine=Connect -> I strongly recommend dropping that one, It's way too new and doesn't support transactions.
10.2 has JSON functions, but not the JSON data type, because SQL standard specifies that JSON should be stored in normal VARCHARs, there should be no special JSON type.
Nevertheless, we have a task for JSON type (MDEV-9144), but it's not planned for 10.2 or 10.3.
Sergei Golubchik
added a comment - 10.2 has JSON functions, but not the JSON data type, because SQL standard specifies that JSON should be stored in normal VARCHARs, there should be no special JSON type.
Nevertheless, we have a task for JSON type ( MDEV-9144 ), but it's not planned for 10.2 or 10.3.
People
Sergei Golubchik
Smail Mustafa
Votes:
0Vote for this issue
Watchers:
2Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":783.5999999940395,"ttfb":180.40000000596046,"pageVisibility":"visible","entityId":60021,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"25e5a195-13de-40c6-b4c2-d5f773aded5c","navigationType":0,"readyForUser":847.0999999940395,"redirectCount":0,"resourceLoadedEnd":890,"resourceLoadedStart":185.5,"resourceTiming":[{"duration":106.19999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":185.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":185.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":291.69999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":106.09999999403954,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":185.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":185.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":292,"responseStart":0,"secureConnectionStart":0},{"duration":114.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":186,"connectEnd":186,"connectStart":186,"domainLookupEnd":186,"domainLookupStart":186,"fetchStart":186,"redirectEnd":0,"redirectStart":0,"requestStart":186,"responseEnd":300.69999998807907,"responseStart":300.69999998807907,"secureConnectionStart":186},{"duration":183.09999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":186.19999998807907,"connectEnd":186.19999998807907,"connectStart":186.19999998807907,"domainLookupEnd":186.19999998807907,"domainLookupStart":186.19999998807907,"fetchStart":186.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":186.19999998807907,"responseEnd":369.2999999821186,"responseStart":369.2999999821186,"secureConnectionStart":186.19999998807907},{"duration":186.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":186.40000000596046,"connectEnd":186.40000000596046,"connectStart":186.40000000596046,"domainLookupEnd":186.40000000596046,"domainLookupStart":186.40000000596046,"fetchStart":186.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":186.40000000596046,"responseEnd":373.09999999403954,"responseStart":373.09999999403954,"secureConnectionStart":186.40000000596046},{"duration":187,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":186.59999999403954,"connectEnd":186.59999999403954,"connectStart":186.59999999403954,"domainLookupEnd":186.59999999403954,"domainLookupStart":186.59999999403954,"fetchStart":186.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":186.59999999403954,"responseEnd":373.59999999403954,"responseStart":373.59999999403954,"secureConnectionStart":186.59999999403954},{"duration":187.2000000178814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":186.7999999821186,"connectEnd":186.7999999821186,"connectStart":186.7999999821186,"domainLookupEnd":186.7999999821186,"domainLookupStart":186.7999999821186,"fetchStart":186.7999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":186.7999999821186,"responseEnd":374,"responseStart":374,"secureConnectionStart":186.7999999821186},{"duration":254.2999999821186,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":187,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":441.2999999821186,"responseStart":0,"secureConnectionStart":0},{"duration":187.40000000596046,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":187.09999999403954,"connectEnd":187.09999999403954,"connectStart":187.09999999403954,"domainLookupEnd":187.09999999403954,"domainLookupStart":187.09999999403954,"fetchStart":187.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":187.09999999403954,"responseEnd":374.5,"responseStart":374.5,"secureConnectionStart":187.09999999403954},{"duration":254.10000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":187.2999999821186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.2999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":441.40000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":187.59999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":187.40000000596046,"connectEnd":187.40000000596046,"connectStart":187.40000000596046,"domainLookupEnd":187.40000000596046,"domainLookupStart":187.40000000596046,"fetchStart":187.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":187.40000000596046,"responseEnd":375,"responseStart":375,"secureConnectionStart":187.40000000596046},{"duration":287.59999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":188.40000000596046,"connectEnd":188.40000000596046,"connectStart":188.40000000596046,"domainLookupEnd":188.40000000596046,"domainLookupStart":188.40000000596046,"fetchStart":188.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":188.40000000596046,"responseEnd":476,"responseStart":476,"secureConnectionStart":188.40000000596046},{"duration":355,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":188.5,"connectEnd":188.5,"connectStart":188.5,"domainLookupEnd":188.5,"domainLookupStart":188.5,"fetchStart":188.5,"redirectEnd":0,"redirectStart":0,"requestStart":188.5,"responseEnd":543.5,"responseStart":543.5,"secureConnectionStart":188.5},{"duration":68.10000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":467.7999999821186,"connectEnd":467.7999999821186,"connectStart":467.7999999821186,"domainLookupEnd":467.7999999821186,"domainLookupStart":467.7999999821186,"fetchStart":467.7999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":467.7999999821186,"responseEnd":535.9000000059605,"responseStart":535.9000000059605,"secureConnectionStart":467.7999999821186},{"duration":37.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/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":704.7999999821186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":704.7999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":742.2999999821186,"responseStart":0,"secureConnectionStart":0},{"duration":184.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/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":705.6999999880791,"connectEnd":705.6999999880791,"connectStart":705.6999999880791,"domainLookupEnd":705.6999999880791,"domainLookupStart":705.6999999880791,"fetchStart":705.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":705.6999999880791,"responseEnd":890,"responseStart":890,"secureConnectionStart":705.6999999880791},{"duration":188.59999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/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":706,"connectEnd":706,"connectStart":706,"domainLookupEnd":706,"domainLookupStart":706,"fetchStart":706,"redirectEnd":0,"redirectStart":0,"requestStart":706,"responseEnd":894.5999999940395,"responseStart":894.5999999940395,"secureConnectionStart":706}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":29,"responseStart":180,"responseEnd":182,"domLoading":183,"domInteractive":893,"domContentLoadedEventStart":893,"domContentLoadedEventEnd":936,"domComplete":1103,"loadEventStart":1103,"loadEventEnd":1103,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":875.1999999880791},{"name":"bigPipe.sidebar-id.end","time":875.9000000059605},{"name":"bigPipe.activity-panel-pipe-id.start","time":876.0999999940395},{"name":"bigPipe.activity-panel-pipe-id.end","time":876.7999999821186},{"name":"activityTabFullyLoaded","time":953.0999999940395}],"measures":[],"correlationId":"4e8bf3b567e9cf","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":97,"dbReadsTimeInMs":10,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Task
Critical
10.2 has JSON functions, but not the JSON data type, because SQL standard specifies that JSON should be stored in normal VARCHARs, there should be no special JSON type.
Nevertheless, we have a task for JSON type (
MDEV-9144), but it's not planned for 10.2 or 10.3.