-
Bug
-
-
Minor
-
Resolution:
Not a Bug
-
N/A
-
-
-
sys.table_exists shows TEMPORARY SEQUENCE - for temporary sequence, but just TEMPORARY if there exist also base table with the same name:
MariaDB [db]> create temporary sequence s1;
|
Query OK, 0 rows affected (0,003 sec)
|
|
MariaDB [db]> create temporary sequence s2;
|
Query OK, 0 rows affected (0,004 sec)
|
|
MariaDB [db]> create sequence s1;
|
Query OK, 0 rows affected (0,018 sec)
|
|
MariaDB [db]> show full tables;
|
+--------------+--------------------+
|
| Tables_in_db | Table_type |
|
+--------------+--------------------+
|
| s2 | TEMPORARY SEQUENCE |
|
| s1 | TEMPORARY SEQUENCE |
|
| s1 | SEQUENCE |
|
+--------------+--------------------+
|
3 rows in set (0,003 sec)
|
|
MariaDB [db]> CALL sys.table_exists('db', 's1', @table_type); SELECT @table_type;
|
Query OK, 0 rows affected (0,005 sec)
|
|
+-------------+
|
| @table_type |
|
+-------------+
|
| TEMPORARY |
|
+-------------+
|
1 row in set (0,001 sec)
|
|
MariaDB [db]> CALL sys.table_exists('db', 's2', @table_type); SELECT @table_type;
|
Query OK, 0 rows affected (0,005 sec)
|
|
+--------------------+
|
| @table_type |
|
+--------------------+
|
| TEMPORARY SEQUENCE |
|
+--------------------+
|
1 row in set (0,001 sec)
|
maybe we should change that procedure – currently there is:
SET v_table_type = (SELECT GROUP_CONCAT(TABLE_TYPE) FROM information_schema.TABLES WHERE
|
TABLE_SCHEMA = in_db AND TABLE_NAME = in_table);
|
IF v_table_type LIKE '%,%' THEN
|
SET out_exists = 'TEMPORARY';
|
- relates to
-
MDEV-12459
The information_schema tables for getting temporary tables info is missing, at least for innodb there is no INNODB_TEMP_TABLE_INFO
-
-
Closed
{"report":{"fcp":791.2999992370605,"ttfb":119.39999961853027,"pageVisibility":"visible","entityId":123671,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"66393ddf-e4de-4ce0-976f-f9a3e5ea3bc3","navigationType":0,"readyForUser":851.2999992370605,"redirectCount":0,"resourceLoadedEnd":1026.1999998092651,"resourceLoadedStart":124.79999923706055,"resourceTiming":[{"duration":231.70000076293945,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":124.79999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":124.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":356.5,"responseStart":0,"secureConnectionStart":0},{"duration":231.5999994277954,"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":125,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":125,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":356.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":240.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":125.19999980926514,"connectEnd":125.19999980926514,"connectStart":125.19999980926514,"domainLookupEnd":125.19999980926514,"domainLookupStart":125.19999980926514,"fetchStart":125.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":125.19999980926514,"responseEnd":365.69999980926514,"responseStart":365.69999980926514,"secureConnectionStart":125.19999980926514},{"duration":265.6000003814697,"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":125.29999923706055,"connectEnd":125.29999923706055,"connectStart":125.29999923706055,"domainLookupEnd":125.29999923706055,"domainLookupStart":125.29999923706055,"fetchStart":125.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":125.29999923706055,"responseEnd":390.8999996185303,"responseStart":390.8999996185303,"secureConnectionStart":125.29999923706055},{"duration":269.0999994277954,"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":125.5,"connectEnd":125.5,"connectStart":125.5,"domainLookupEnd":125.5,"domainLookupStart":125.5,"fetchStart":125.5,"redirectEnd":0,"redirectStart":0,"requestStart":125.5,"responseEnd":394.5999994277954,"responseStart":394.5999994277954,"secureConnectionStart":125.5},{"duration":269.79999923706055,"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":125.5,"connectEnd":125.5,"connectStart":125.5,"domainLookupEnd":125.5,"domainLookupStart":125.5,"fetchStart":125.5,"redirectEnd":0,"redirectStart":0,"requestStart":125.5,"responseEnd":395.29999923706055,"responseStart":395.29999923706055,"secureConnectionStart":125.5},{"duration":270.8999996185303,"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":125.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":125.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":396.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":270.19999980926514,"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":125.69999980926514,"connectEnd":125.69999980926514,"connectStart":125.69999980926514,"domainLookupEnd":125.69999980926514,"domainLookupStart":125.69999980926514,"fetchStart":125.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":125.69999980926514,"responseEnd":395.8999996185303,"responseStart":395.8999996185303,"secureConnectionStart":125.69999980926514},{"duration":270.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":125.79999923706055,"connectEnd":125.79999923706055,"connectStart":125.79999923706055,"domainLookupEnd":125.79999923706055,"domainLookupStart":125.79999923706055,"fetchStart":125.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":125.79999923706055,"responseEnd":396.5999994277954,"responseStart":396.5999994277954,"secureConnectionStart":125.79999923706055},{"duration":271.19999980926514,"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":126,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":126,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":397.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":271.30000019073486,"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":126.09999942779541,"connectEnd":126.09999942779541,"connectStart":126.09999942779541,"domainLookupEnd":126.09999942779541,"domainLookupStart":126.09999942779541,"fetchStart":126.09999942779541,"redirectEnd":0,"redirectStart":0,"requestStart":126.09999942779541,"responseEnd":397.3999996185303,"responseStart":397.3999996185303,"secureConnectionStart":126.09999942779541},{"duration":893.6000003814697,"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":131.89999961853027,"connectEnd":131.89999961853027,"connectStart":131.89999961853027,"domainLookupEnd":131.89999961853027,"domainLookupStart":131.89999961853027,"fetchStart":131.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":131.89999961853027,"responseEnd":1025.5,"responseStart":1025.5,"secureConnectionStart":131.89999961853027},{"duration":893.8000001907349,"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":132.39999961853027,"connectEnd":132.39999961853027,"connectStart":132.39999961853027,"domainLookupEnd":132.39999961853027,"domainLookupStart":132.39999961853027,"fetchStart":132.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":132.39999961853027,"responseEnd":1026.1999998092651,"responseStart":1026.1999998092651,"secureConnectionStart":132.39999961853027},{"duration":350.3999996185303,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":596.8999996185303,"connectEnd":596.8999996185303,"connectStart":596.8999996185303,"domainLookupEnd":596.8999996185303,"domainLookupStart":596.8999996185303,"fetchStart":596.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":596.8999996185303,"responseEnd":947.2999992370605,"responseStart":947.2999992370605,"secureConnectionStart":596.8999996185303},{"duration":259.80000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":770.7999992370605,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":770.7999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1030.5999994277954,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":119,"responseEnd":131,"domLoading":123,"domInteractive":1047,"domContentLoadedEventStart":1047,"domContentLoadedEventEnd":1082,"domComplete":1650,"loadEventStart":1650,"loadEventEnd":1651,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1031.8999996185303},{"name":"bigPipe.sidebar-id.end","time":1032.5999994277954},{"name":"bigPipe.activity-panel-pipe-id.start","time":1032.7999992370605},{"name":"bigPipe.activity-panel-pipe-id.end","time":1035},{"name":"activityTabFullyLoaded","time":1087.2999992370605}],"measures":[],"correlationId":"402906f5347083","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":64,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}