Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.1(EOL) , 10.2(EOL) , 10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.11 , 11.1(EOL) , 11.2(EOL) , 11.4 , 11.5(EOL) , 11.6(EOL)
MariaDB [test]> select @@enforce_storage_engine;
+--------------------------+
| @@enforce_storage_engine |
+--------------------------+
| InnoDB |
+--------------------------+
1 row in set (0.00 sec)
MariaDB [test]> set sql_mode=NO_ENGINE_SUBSTITUTION;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test]> create table t (i int) engine=MyISAM;
ERROR 1286 (42000): Unknown storage engine 'MyISAM'
It is of course expected that CREATE would produce an error, just not the error. If there is no suitable one, maybe it should be created.
relates to
MDEV-6858
enforce_storage_engine option
Closed
made changes -
2015-08-13 18:43
Status
Open
[ 1
]
Confirmed
[ 10101
]
made changes -
2018-11-13 21:01
Component/s
Server
[ 13907
]
Component/s
OTHER
[ 10125
]
Fix Version/s
10.2
[ 14601
]
Fix Version/s
10.3
[ 22126
]
Fix Version/s
10.4
[ 22408
]
Affects Version/s
10.2
[ 14601
]
Affects Version/s
10.3
[ 22126
]
Affects Version/s
10.4
[ 22408
]
Priority
Minor
[ 4
]
Major
[ 3
]
made changes -
2020-12-01 12:38
Fix Version/s
10.1
[ 16100
]
made changes -
2021-10-10 18:59
Assignee
Jan Lindström
[ jplindst
]
Oleksandr Byelkin
[ sanja
]
made changes -
2021-10-10 18:59
Assignee
Oleksandr Byelkin
[ sanja
]
Rucha Deodhar
[ rucha174
]
made changes -
2021-12-06 21:36
Workflow
MariaDB v3
[ 70924
]
MariaDB v4
[ 143844
]
made changes -
2022-08-04 09:20
Fix Version/s
10.2
[ 14601
]
made changes -
2023-04-27 14:23
Fix Version/s
10.3
[ 22126
]
made changes -
2024-03-19 20:12
Assignee
Rucha Deodhar
[ rucha174
]
Oleksandr Byelkin
[ sanja
]
Status
Confirmed
[ 10101
]
In Review
[ 10002
]
made changes -
2024-03-25 12:12
Assignee
Oleksandr Byelkin
[ sanja
]
Rucha Deodhar
[ rucha174
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
made changes -
2024-08-26 02:08
Fix Version/s
10.5
[ 23123
]
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.11
[ 27614
]
Fix Version/s
11.1
[ 28549
]
Fix Version/s
11.2
[ 28603
]
Fix Version/s
11.4
[ 29301
]
Fix Version/s
11.5
[ 29506
]
Fix Version/s
10.4
[ 22408
]
Affects Version/s
10.5
[ 23123
]
Affects Version/s
10.6
[ 24028
]
Affects Version/s
10.11
[ 27614
]
Affects Version/s
11.1
[ 28549
]
Affects Version/s
11.2
[ 28603
]
Affects Version/s
11.4
[ 29301
]
Affects Version/s
11.5
[ 29506
]
Affects Version/s
11.6
[ 29515
]
made changes -
2024-09-10 15:27
Fix Version/s
11.1
[ 28549
]
made changes -
2024-09-10 15:45
Fix Version/s
11.5
[ 29506
]
made changes -
2024-10-18 19:43
Fix Version/s
10.5.27
[ 29902
]
Fix Version/s
10.6.20
[ 29903
]
Fix Version/s
10.11.10
[ 29904
]
Fix Version/s
11.2.6
[ 29906
]
Fix Version/s
11.4.4
[ 29907
]
Fix Version/s
10.5
[ 23123
]
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.11
[ 27614
]
Fix Version/s
11.2
[ 28603
]
Fix Version/s
11.4
[ 29301
]
Resolution
Fixed
[ 1
]
Status
Stalled
[ 10000
]
Closed
[ 6
]
{"report":{"fcp":1868.8000001907349,"ttfb":359.5,"pageVisibility":"visible","entityId":52524,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"83071316-677c-4dae-99b9-51e6e1b6e544","navigationType":0,"readyForUser":1957.7000002861023,"redirectCount":0,"resourceLoadedEnd":1650.4000000953674,"resourceLoadedStart":365.59999990463257,"resourceTiming":[{"duration":737.8000001907349,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":365.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":365.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1103.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":737.9000000953674,"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":365.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":365.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1103.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":917,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":366.09999990463257,"connectEnd":366.09999990463257,"connectStart":366.09999990463257,"domainLookupEnd":366.09999990463257,"domainLookupStart":366.09999990463257,"fetchStart":366.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":1108.5999999046326,"responseEnd":1283.0999999046326,"responseStart":1188.4000000953674,"secureConnectionStart":366.09999990463257},{"duration":1087.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":366.30000019073486,"connectEnd":366.30000019073486,"connectStart":366.30000019073486,"domainLookupEnd":366.30000019073486,"domainLookupStart":366.30000019073486,"fetchStart":366.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":1109.5999999046326,"responseEnd":1453.4000000953674,"responseStart":1293,"secureConnectionStart":366.30000019073486},{"duration":805.5999999046326,"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":366.40000009536743,"connectEnd":366.40000009536743,"connectStart":366.40000009536743,"domainLookupEnd":366.40000009536743,"domainLookupStart":366.40000009536743,"fetchStart":366.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":1109.8000001907349,"responseEnd":1172,"responseStart":1171.4000000953674,"secureConnectionStart":366.40000009536743},{"duration":821.6000003814697,"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":366.59999990463257,"connectEnd":366.59999990463257,"connectStart":366.59999990463257,"domainLookupEnd":366.59999990463257,"domainLookupStart":366.59999990463257,"fetchStart":366.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":1109.8000001907349,"responseEnd":1188.2000002861023,"responseStart":1187.2000002861023,"secureConnectionStart":366.59999990463257},{"duration":805.5999999046326,"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":366.90000009536743,"connectEnd":366.90000009536743,"connectStart":366.90000009536743,"domainLookupEnd":366.90000009536743,"domainLookupStart":366.90000009536743,"fetchStart":366.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":1110,"responseEnd":1172.5,"responseStart":1172,"secureConnectionStart":366.90000009536743},{"duration":738.3000001907349,"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":367.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":367.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1105.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":762.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":367.2000002861023,"connectEnd":1107,"connectStart":1107,"domainLookupEnd":1107,"domainLookupStart":1107,"fetchStart":367.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1110.5999999046326,"responseEnd":1129.7000002861023,"responseStart":1126.2000002861023,"secureConnectionStart":1107},{"duration":739.4000000953674,"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":367.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":367.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1106.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":765,"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":367.5,"connectEnd":367.5,"connectStart":367.5,"domainLookupEnd":367.5,"domainLookupStart":367.5,"fetchStart":367.5,"redirectEnd":0,"redirectStart":0,"requestStart":1110.7000002861023,"responseEnd":1132.5,"responseStart":1128.0999999046326,"secureConnectionStart":367.5},{"duration":1119.3999996185303,"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":373.7000002861023,"connectEnd":373.7000002861023,"connectStart":373.7000002861023,"domainLookupEnd":373.7000002861023,"domainLookupStart":373.7000002861023,"fetchStart":373.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1476.2000002861023,"responseEnd":1493.0999999046326,"responseStart":1490.8000001907349,"secureConnectionStart":373.7000002861023},{"duration":1276.5999999046326,"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":373.80000019073486,"connectEnd":373.80000019073486,"connectStart":373.80000019073486,"domainLookupEnd":373.80000019073486,"domainLookupStart":373.80000019073486,"fetchStart":373.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":1638.3000001907349,"responseEnd":1650.4000000953674,"responseStart":1649.5999999046326,"secureConnectionStart":373.80000019073486},{"duration":197.7999997138977,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1473.3000001907349,"connectEnd":1473.3000001907349,"connectStart":1473.3000001907349,"domainLookupEnd":1473.3000001907349,"domainLookupStart":1473.3000001907349,"fetchStart":1473.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1637.0999999046326,"responseEnd":1671.0999999046326,"responseStart":1669.9000000953674,"secureConnectionStart":1473.3000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":105,"responseStart":359,"responseEnd":366,"domLoading":363,"domInteractive":2034,"domContentLoadedEventStart":2034,"domContentLoadedEventEnd":2099,"domComplete":4720,"loadEventStart":4720,"loadEventEnd":4721,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1991.9000000953674},{"name":"bigPipe.sidebar-id.end","time":1992.7000002861023},{"name":"bigPipe.activity-panel-pipe-id.start","time":1992.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":2002.5999999046326},{"name":"activityTabFullyLoaded","time":2120.300000190735}],"measures":[],"correlationId":"62a81b6c470caf","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":195,"dbReadsTimeInMs":31,"dbConnsTimeInMs":42,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
MDEV-6858 enforce_storage_engine option
let's use ER_OPTION_PREVENTS_STATEMENT