This is a list of trivial features for Sequence (originally mentioned as part of MDEV-13005)
Support syntax "CREATE SEQUENCE x AS <some_int_type>';
<some_int_type> can mean all the integers that we support
Currently (as per documentation) maximum value that sequence can support is 9223372036854775806.
But unsigned bigint can have maximum (unsigned) value: 18446744073709551615
So adding support for this maximum (unsigned) value is needed.
Also, set maximum minimum based on the datatype
Allow in parser very big numbers (decimal) for MAXVALUE but change these to LONGLONG_MAX-1, with a note for the user. This is needes as it's common practice to use
MAXVALUE 9999999999999999999999999999 in Oracle examples.
Create information_schema.sequences that lists all sequences and their information. Should work similar to views:
select * from information_schema.sequences where table_schema="test";
The column names are:
SEQUENCE_CATALOG, SEQUENCE_SCHEMA, SEQUENCE_NAME, DATA_TYPE, NUMERIC_PRECISION, NUMERIC_PRECISION_RADIX, NUMERIC_SCALE, START_VALUE, MINIMUM_VALUE, MAXIMUM_VALUE, INCREMENT, CYCLE_OPTION, DECLARED_DATA_TYPE, DECLARED_NUMERIC_PRECISION, DECLARED_NUMERIC_SCALE
4d2224702fc upstream/bb-11.4-mdev-28152 MDEV-28152 Features for sequences
09a710036b6 MDEV-33169 Reset sequence used fields after check in alter sequence
Yuchen Pei
added a comment - Hi lstartseva , could you test the patch on top of the MDEV-33169 patch that fixes MDEV-33012 ?
4d2224702fc upstream/bb-11.4-mdev-28152 MDEV-28152 Features for sequences
09a710036b6 MDEV-33169 Reset sequence used fields after check in alter sequence
Really, it looks like patch for MDEV-33169 fixes problems MDEV-33012. Tests passed.
Feature is ok to push with this changes.
Lena Startseva
added a comment - Really, it looks like patch for MDEV-33169 fixes problems MDEV-33012 . Tests passed.
Feature is ok to push with this changes.
Thanks lstartseva. The fixversion was changed to 11.5 and the feature was not included in 11.4-preview, so we have to wait for an 11.5 branch to be created first.
Yuchen Pei
added a comment - - edited Thanks lstartseva . The fixversion was changed to 11.5 and the feature was not included in 11.4-preview, so we have to wait for an 11.5 branch to be created first.
11.5 branch has been created with the MDEV-33169 patch included. I have verified that MDEV-33012 is fixed by it. So I have applied the patch on top as 374783c3d9a87170b313a05240dadaa813ec6034 and pushed it to 11.5.
Yuchen Pei
added a comment - - edited 11.5 branch has been created with the MDEV-33169 patch included. I have verified that MDEV-33012 is fixed by it. So I have applied the patch on top as 374783c3d9a87170b313a05240dadaa813ec6034 and pushed it to 11.5.
People
Yuchen Pei
Rucha Deodhar
Votes:
1Vote for this issue
Watchers:
10Start 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":1453.5,"ttfb":300,"pageVisibility":"visible","entityId":109025,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"43837e04-8f6e-445c-b397-e2b74a28a1a3","navigationType":0,"readyForUser":1541,"redirectCount":0,"resourceLoadedEnd":1164.2999999523163,"resourceLoadedStart":323.2999999523163,"resourceTiming":[{"duration":337.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":323.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":323.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":660.3999998569489,"responseStart":0,"secureConnectionStart":0},{"duration":345.39999985694885,"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":323.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":323.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":669.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":618.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":323.7999999523163,"connectEnd":323.7999999523163,"connectStart":323.7999999523163,"domainLookupEnd":323.7999999523163,"domainLookupStart":323.7999999523163,"fetchStart":323.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":691.5,"responseEnd":942.0999999046326,"responseStart":728.2999999523163,"secureConnectionStart":323.7999999523163},{"duration":826.6000001430511,"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":324.09999990463257,"connectEnd":324.09999990463257,"connectStart":324.09999990463257,"domainLookupEnd":324.09999990463257,"domainLookupStart":324.09999990463257,"fetchStart":324.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":671.7999999523163,"responseEnd":1150.7000000476837,"responseStart":717.0999999046326,"secureConnectionStart":324.09999990463257},{"duration":403.89999985694885,"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":324.2000000476837,"connectEnd":324.2000000476837,"connectStart":324.2000000476837,"domainLookupEnd":324.2000000476837,"domainLookupStart":324.2000000476837,"fetchStart":324.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":691.7000000476837,"responseEnd":728.0999999046326,"responseStart":724.7000000476837,"secureConnectionStart":324.2000000476837},{"duration":417.2999999523163,"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":324.5,"connectEnd":324.5,"connectStart":324.5,"domainLookupEnd":324.5,"domainLookupStart":324.5,"fetchStart":324.5,"redirectEnd":0,"redirectStart":0,"requestStart":705.2999999523163,"responseEnd":741.7999999523163,"responseStart":738.7000000476837,"secureConnectionStart":324.5},{"duration":417.2999999523163,"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":324.7999999523163,"connectEnd":324.7999999523163,"connectStart":324.7999999523163,"domainLookupEnd":324.7999999523163,"domainLookupStart":324.7999999523163,"fetchStart":324.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":710.5999999046326,"responseEnd":742.0999999046326,"responseStart":739.2999999523163,"secureConnectionStart":324.7999999523163},{"duration":362.7999999523163,"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":325,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":325,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":687.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":417.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":325.2000000476837,"connectEnd":325.2000000476837,"connectStart":325.2000000476837,"domainLookupEnd":325.2000000476837,"domainLookupStart":325.2000000476837,"fetchStart":325.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":710.7999999523163,"responseEnd":742.2999999523163,"responseStart":739.7999999523163,"secureConnectionStart":325.2000000476837},{"duration":363.7999999523163,"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":325.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":325.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":689.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":417.90000009536743,"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":325.39999985694885,"connectEnd":325.39999985694885,"connectStart":325.39999985694885,"domainLookupEnd":325.39999985694885,"domainLookupStart":325.39999985694885,"fetchStart":325.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":710.8999998569489,"responseEnd":743.2999999523163,"responseStart":740.2999999523163,"secureConnectionStart":325.39999985694885},{"duration":835.2000000476837,"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":326.89999985694885,"connectEnd":326.89999985694885,"connectStart":326.89999985694885,"domainLookupEnd":326.89999985694885,"domainLookupStart":326.89999985694885,"fetchStart":326.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":885.5999999046326,"responseEnd":1162.0999999046326,"responseStart":1155.5999999046326,"secureConnectionStart":326.89999985694885},{"duration":837.2999999523163,"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":327,"connectEnd":327,"connectStart":327,"domainLookupEnd":327,"domainLookupStart":327,"fetchStart":327,"redirectEnd":0,"redirectStart":0,"requestStart":988.2999999523163,"responseEnd":1164.2999999523163,"responseStart":1160.3999998569489,"secureConnectionStart":327},{"duration":202.69999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1087.2000000476837,"connectEnd":1087.2000000476837,"connectStart":1087.2000000476837,"domainLookupEnd":1087.2000000476837,"domainLookupStart":1087.2000000476837,"fetchStart":1087.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1255.3999998569489,"responseEnd":1289.8999998569489,"responseStart":1288.7000000476837,"secureConnectionStart":1087.2000000476837},{"duration":217.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1403.8999998569489,"connectEnd":1403.8999998569489,"connectStart":1403.8999998569489,"domainLookupEnd":1403.8999998569489,"domainLookupStart":1403.8999998569489,"fetchStart":1403.8999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1588.7999999523163,"responseEnd":1621.7999999523163,"responseStart":1619.3999998569489,"secureConnectionStart":1403.8999998569489},{"duration":240.89999985694885,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1445,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1445,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1685.8999998569489,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":90,"responseStart":300,"responseEnd":308,"domLoading":321,"domInteractive":1695,"domContentLoadedEventStart":1695,"domContentLoadedEventEnd":1756,"domComplete":2094,"loadEventStart":2094,"loadEventEnd":2095,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1653},{"name":"bigPipe.sidebar-id.end","time":1653.8999998569489},{"name":"bigPipe.activity-panel-pipe-id.start","time":1654.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":1656},{"name":"activityTabFullyLoaded","time":1773.7000000476837}],"measures":[],"correlationId":"2d04dc58acdf33","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":113,"dbReadsTimeInMs":19,"dbConnsTimeInMs":29,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Testing is completed but
MDEV-33012needs to be fixed before pushing