Lets consider the requirement "A normal user should only be able to flush tables in ones own catalog":
Does it relate only to the case when no tables listed in the statement. In other words, should we allow flushing of tables in someone's else catalog if these tables are explicitly listed in table_list
e.g.
where cat_1.table_1, cat_2.table_2 - are tables located in not ones owned catalogs?
The following question is about the requirement "flush table with read lock should only affect tables in the current catalog"
Do we consider here only the case when no tables listed explicitly for the statement 'FLUSH TABLES WITH READ LOCK'. That is, does this requirement mean that the next statement
should work correct notwithstanding the fact that tables table_1 and table_t are from different catalog not ones owned?
The following question is about the requirement "The 'def' root user should be able flush tables for all catalogs":
Does 'root user' here mean the user located in the 'def' catalog and that has the privilege SUPER_ACL ?
Dmitry Shulga
added a comment - - edited Lets consider the requirement "A normal user should only be able to flush tables in ones own catalog":
Does it relate only to the case when no tables listed in the statement. In other words, should we allow flushing of tables in someone's else catalog if these tables are explicitly listed in table_list
e.g.
FLUSH TABLES table_in_own_catalog, cat_1.table_1, cat_2.table_2
where cat_1.table_1, cat_2.table_2 - are tables located in not ones owned catalogs?
The following question is about the requirement "flush table with read lock should only affect tables in the current catalog"
Do we consider here only the case when no tables listed explicitly for the statement 'FLUSH TABLES WITH READ LOCK'. That is, does this requirement mean that the next statement
FLUSH TABLES cat_1.table_1, cat_2.table_2 WITH READ LOCK
should work correct notwithstanding the fact that tables table_1 and table_t are from different catalog not ones owned?
The following question is about the requirement "The 'def' root user should be able flush tables for all catalogs":
Does 'root user' here mean the user located in the 'def' catalog and that has the privilege SUPER_ACL ?
People
Dmitry Shulga
Michael Widenius
Votes:
0Vote for this issue
Watchers:
5Start watching this issue
Dates
Created:
Updated:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":710.3000001907349,"ttfb":162.60000038146973,"pageVisibility":"visible","entityId":123481,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"b13a731c-8a16-4ff6-988f-e2a90dc2f054","navigationType":0,"readyForUser":761.4000005722046,"redirectCount":0,"resourceLoadedEnd":306.4000005722046,"resourceLoadedStart":167.80000019073486,"resourceTiming":[{"duration":5.40000057220459,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":167.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":167.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":173.20000076293945,"responseStart":0,"secureConnectionStart":0},{"duration":6,"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":168.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":168.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":174.10000038146973,"responseStart":0,"secureConnectionStart":0},{"duration":99.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":168.30000019073486,"connectEnd":168.30000019073486,"connectStart":168.30000019073486,"domainLookupEnd":168.30000019073486,"domainLookupStart":168.30000019073486,"fetchStart":168.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":177.30000019073486,"responseEnd":267.6000003814697,"responseStart":196.60000038146973,"secureConnectionStart":168.30000019073486},{"duration":138,"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":168.4000005722046,"connectEnd":168.4000005722046,"connectStart":168.4000005722046,"domainLookupEnd":168.4000005722046,"domainLookupStart":168.4000005722046,"fetchStart":168.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":177.80000019073486,"responseEnd":306.4000005722046,"responseStart":207.30000019073486,"secureConnectionStart":168.4000005722046},{"duration":34.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":168.5,"connectEnd":168.5,"connectStart":168.5,"domainLookupEnd":168.5,"domainLookupStart":168.5,"fetchStart":168.5,"redirectEnd":0,"redirectStart":0,"requestStart":179,"responseEnd":203,"responseStart":202.4000005722046,"secureConnectionStart":168.5},{"duration":51.30000019073486,"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":168.5,"connectEnd":168.5,"connectStart":168.5,"domainLookupEnd":168.5,"domainLookupStart":168.5,"fetchStart":168.5,"redirectEnd":0,"redirectStart":0,"requestStart":180.4000005722046,"responseEnd":219.80000019073486,"responseStart":219.30000019073486,"secureConnectionStart":168.5},{"duration":12,"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":168.70000076293945,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":168.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":180.70000076293945,"responseStart":0,"secureConnectionStart":0},{"duration":60.5,"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":168.70000076293945,"connectEnd":168.70000076293945,"connectStart":168.70000076293945,"domainLookupEnd":168.70000076293945,"domainLookupStart":168.70000076293945,"fetchStart":168.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":182.10000038146973,"responseEnd":229.20000076293945,"responseStart":228.9000005722046,"secureConnectionStart":168.70000076293945},{"duration":59.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":168.9000005722046,"connectEnd":168.9000005722046,"connectStart":168.9000005722046,"domainLookupEnd":168.9000005722046,"domainLookupStart":168.9000005722046,"fetchStart":168.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":184,"responseEnd":228.80000019073486,"responseStart":228.30000019073486,"secureConnectionStart":168.9000005722046},{"duration":13.700000762939453,"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":169,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":182.70000076293945,"responseStart":0,"secureConnectionStart":0},{"duration":61.10000038146973,"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":169,"connectEnd":169,"connectStart":169,"domainLookupEnd":169,"domainLookupStart":169,"fetchStart":169,"redirectEnd":0,"redirectStart":0,"requestStart":185.5,"responseEnd":230.10000038146973,"responseStart":229.30000019073486,"secureConnectionStart":169},{"duration":29.800000190734863,"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":177.30000019073486,"connectEnd":191.9000005722046,"connectStart":191.9000005722046,"domainLookupEnd":191.9000005722046,"domainLookupStart":191.9000005722046,"fetchStart":177.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":192,"responseEnd":207.10000038146973,"responseStart":204.5,"secureConnectionStart":191.9000005722046},{"duration":31.199999809265137,"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":177.4000005722046,"connectEnd":177.4000005722046,"connectStart":177.4000005722046,"domainLookupEnd":177.4000005722046,"domainLookupStart":177.4000005722046,"fetchStart":177.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":192.60000038146973,"responseEnd":208.60000038146973,"responseStart":205.60000038146973,"secureConnectionStart":177.4000005722046},{"duration":207.70000076293945,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":474,"connectEnd":474,"connectStart":474,"domainLookupEnd":474,"domainLookupStart":474,"fetchStart":474,"redirectEnd":0,"redirectStart":0,"requestStart":649.4000005722046,"responseEnd":681.7000007629395,"responseStart":681,"secureConnectionStart":474},{"duration":159.39999961853027,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":689.2000007629395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":689.2000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":848.6000003814697,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":49,"responseStart":163,"responseEnd":176,"domLoading":167,"domInteractive":812,"domContentLoadedEventStart":813,"domContentLoadedEventEnd":855,"domComplete":1184,"loadEventStart":1185,"loadEventEnd":1185,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":789.9000005722046},{"name":"bigPipe.sidebar-id.end","time":790.7000007629395},{"name":"bigPipe.activity-panel-pipe-id.start","time":790.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":792},{"name":"activityTabFullyLoaded","time":871.1000003814697}],"measures":[],"correlationId":"eee2d2f251c328","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":65,"dbReadsTimeInMs":10,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Lets consider the requirement "A normal user should only be able to flush tables in ones own catalog":
Does it relate only to the case when no tables listed in the statement. In other words, should we allow flushing of tables in someone's else catalog if these tables are explicitly listed in table_list
e.g.
FLUSH TABLES table_in_own_catalog, cat_1.table_1, cat_2.table_2
where cat_1.table_1, cat_2.table_2 - are tables located in not ones owned catalogs?
The following question is about the requirement "flush table with read lock should only affect tables in the current catalog"
Do we consider here only the case when no tables listed explicitly for the statement 'FLUSH TABLES WITH READ LOCK'. That is, does this requirement mean that the next statement
should work correct notwithstanding the fact that tables table_1 and table_t are from different catalog not ones owned?
The following question is about the requirement "The 'def' root user should be able flush tables for all catalogs":
Does 'root user' here mean the user located in the 'def' catalog and that has the privilege SUPER_ACL ?