create table t1 (i int);
|
explain insert into t1 values (1),(2);
|
select * from t1;
|
MariaDB [test]> select * from t1;
|
+------+
|
| i |
|
+------+
|
| 1 |
|
| 2 |
|
+------+
|
2 rows in set (0.00 sec)
|
bzr version-info
|
revision-id: psergey@askmonty.org-20130926104732-aq7wcma425u5skrw
|
revno: 3700
|
branch-nick: 10.0-base-explain-slowquerylog
|
It may not return an execution plan if we don't want it to, but it certainly shouldn't insert any records.
- relates to
-
MDEV-3798
Add EXPLAIN for UPDATE/DELETE (mwl #51)
-
-
Closed
{"report":{"fcp":1661.5,"ttfb":555,"pageVisibility":"visible","entityId":25904,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"012b426d-fd23-4a97-8760-96e5b04b0a54","navigationType":0,"readyForUser":1738.199999988079,"redirectCount":0,"resourceLoadedEnd":2138.699999988079,"resourceLoadedStart":562.6999999880791,"resourceTiming":[{"duration":610.3999999761581,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":562.6999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":562.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1173.0999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":610.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":563,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":563,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1173.5,"responseStart":0,"secureConnectionStart":0},{"duration":619.6000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":563.1999999880791,"connectEnd":563.1999999880791,"connectStart":563.1999999880791,"domainLookupEnd":563.1999999880791,"domainLookupStart":563.1999999880791,"fetchStart":563.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":563.1999999880791,"responseEnd":1182.800000011921,"responseStart":1182.800000011921,"secureConnectionStart":563.1999999880791},{"duration":689.5999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":563.3000000119209,"connectEnd":563.3000000119209,"connectStart":563.3000000119209,"domainLookupEnd":563.3000000119209,"domainLookupStart":563.3000000119209,"fetchStart":563.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":563.3000000119209,"responseEnd":1252.8999999761581,"responseStart":1252.8999999761581,"secureConnectionStart":563.3000000119209},{"duration":693.3999999761581,"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":563.5,"connectEnd":563.5,"connectStart":563.5,"domainLookupEnd":563.5,"domainLookupStart":563.5,"fetchStart":563.5,"redirectEnd":0,"redirectStart":0,"requestStart":563.5,"responseEnd":1256.8999999761581,"responseStart":1256.8999999761581,"secureConnectionStart":563.5},{"duration":693.6000000238419,"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":563.6999999880791,"connectEnd":563.6999999880791,"connectStart":563.6999999880791,"domainLookupEnd":563.6999999880791,"domainLookupStart":563.6999999880791,"fetchStart":563.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":563.6999999880791,"responseEnd":1257.300000011921,"responseStart":1257.300000011921,"secureConnectionStart":563.6999999880791},{"duration":694,"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":563.8999999761581,"connectEnd":563.8999999761581,"connectStart":563.8999999761581,"domainLookupEnd":563.8999999761581,"domainLookupStart":563.8999999761581,"fetchStart":563.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":563.8999999761581,"responseEnd":1257.8999999761581,"responseStart":1257.8999999761581,"secureConnectionStart":563.8999999761581},{"duration":769.3000000119209,"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":564.0999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":564.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1333.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":694.3000000119209,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":564.1999999880791,"connectEnd":564.1999999880791,"connectStart":564.1999999880791,"domainLookupEnd":564.1999999880791,"domainLookupStart":564.1999999880791,"fetchStart":564.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":564.1999999880791,"responseEnd":1258.5,"responseStart":1258.5,"secureConnectionStart":564.1999999880791},{"duration":769.1000000238419,"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":564.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":564.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1333.5,"responseStart":0,"secureConnectionStart":0},{"duration":694.5,"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":564.5999999642372,"connectEnd":564.5999999642372,"connectStart":564.5999999642372,"domainLookupEnd":564.5999999642372,"domainLookupStart":564.5999999642372,"fetchStart":564.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":564.5999999642372,"responseEnd":1259.0999999642372,"responseStart":1259.0999999642372,"secureConnectionStart":564.5999999642372},{"duration":1376.5,"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":568.1999999880791,"connectEnd":568.1999999880791,"connectStart":568.1999999880791,"domainLookupEnd":568.1999999880791,"domainLookupStart":568.1999999880791,"fetchStart":568.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":568.1999999880791,"responseEnd":1944.699999988079,"responseStart":1944.699999988079,"secureConnectionStart":568.1999999880791},{"duration":1568.800000011921,"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":569.8999999761581,"connectEnd":569.8999999761581,"connectStart":569.8999999761581,"domainLookupEnd":569.8999999761581,"domainLookupStart":569.8999999761581,"fetchStart":569.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":569.8999999761581,"responseEnd":2138.699999988079,"responseStart":2138.699999988079,"secureConnectionStart":569.8999999761581},{"duration":600.8999999761581,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1345.699999988079,"connectEnd":1345.699999988079,"connectStart":1345.699999988079,"domainLookupEnd":1345.699999988079,"domainLookupStart":1345.699999988079,"fetchStart":1345.699999988079,"redirectEnd":0,"redirectStart":0,"requestStart":1345.699999988079,"responseEnd":1946.5999999642372,"responseStart":1946.5999999642372,"secureConnectionStart":1345.699999988079},{"duration":562.6000000238419,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1654.699999988079,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1654.699999988079,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2217.300000011921,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":286,"domainLookupEnd":339,"connectStart":339,"connectEnd":365,"secureConnectionStart":348,"requestStart":366,"responseStart":555,"responseEnd":569,"domLoading":558,"domInteractive":2168,"domContentLoadedEventStart":2168,"domContentLoadedEventEnd":2213,"domComplete":2848,"loadEventStart":2848,"loadEventEnd":2849,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2142.399999976158},{"name":"bigPipe.sidebar-id.end","time":2143.199999988079},{"name":"bigPipe.activity-panel-pipe-id.start","time":2143.300000011921},{"name":"bigPipe.activity-panel-pipe-id.end","time":2146.300000011921},{"name":"activityTabFullyLoaded","time":2229.599999964237}],"measures":[],"correlationId":"8e22694cab168e","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":111,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Not repeatable with the latest tree.