Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28152

Features for sequence

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 11.5.1
    • Sequences
    • None

    Description

      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

      Some suggested values:
      DATA_TYPE BIGINT
      DECLARED_DATA_TYPE BIGINT
      NUMERIC_PRECISION 19
      NUMERIC_PRECISION_RADIX 10
      DECLARED_DATA_TYPE NULL
      DECLARED_NUMERIC_PRECISION NULL
      DECLARED_NUMERIC_SCALE NULL

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33012 Alter sequence with second execution of prepare statement crashes server

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33734 sql_sequence.next fails with UBSAN in buildbot and outside

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33739 Assertion `0' failed in Type_handler_typelib::max_display_length_for_field

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33836 Assertion `(ulonglong) next_free_value % real_increment == (ulonglong) offset' failed in void sequence_definition::adjust_values(longlong)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33012 Alter sequence with second execution of prepare statement crashes server

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13005 Fixing bugs in SEQUENCE, part 3

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-25729 Fetch MariaDB Sequences metadata

          • Major - Major loss of function.
          • Closed

          BLOG-249 Loading...

          Activity

            Ascending order - Click to sort in descending order
            rucha174 Rucha Deodhar created issue -
            rucha174 Rucha Deodhar made changes -
            Field Original Value New Value
            Assignee Rucha Deodhar [ rucha174 ]
            rucha174 Rucha Deodhar made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 10.10 [ 27530 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.12 [ 28320 ]
            Fix Version/s 10.11 [ 27614 ]
            danblack Daniel Black made changes -
            Component/s Sequences [ 14009 ]
            Component/s Server [ 13907 ]
            ycp Yuchen Pei made changes -
            Assignee Rucha Deodhar [ rucha174 ] Yuchen Pei [ JIRAUSER52627 ]
            ycp Yuchen Pei made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            rucha174 Rucha Deodhar made changes -
            Description This is a list of trivial features for Sequence (originally mentioned as part of MDEV-13005)

            * Support syntax "CREATE SEQUENCE x AS BIGINT';

            * 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

            Some suggested values:
            DATA_TYPE BIGINT
            DECLARED_DATA_TYPE BIGINT
            NUMERIC_PRECISION 19
            NUMERIC_PRECISION_RADIX 10
            DECLARED_DATA_TYPE NULL
            DECLARED_NUMERIC_PRECISION NULL
            DECLARED_NUMERIC_SCALE NULL             		This is a list of trivial features for Sequence (originally mentioned as part of MDEV-13005)

            * Support syntax "CREATE SEQUENCE x AS <some_int_value>';
            <some_int_value> can mean all the integers that we support

            * 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

            Some suggested values:
            DATA_TYPE BIGINT
            DECLARED_DATA_TYPE BIGINT
            NUMERIC_PRECISION 19
            NUMERIC_PRECISION_RADIX 10
            DECLARED_DATA_TYPE NULL
            DECLARED_NUMERIC_PRECISION NULL
            DECLARED_NUMERIC_SCALE NULL
            rucha174 Rucha Deodhar made changes -
            Description This is a list of trivial features for Sequence (originally mentioned as part of MDEV-13005)

            * Support syntax "CREATE SEQUENCE x AS <some_int_value>';
            <some_int_value> can mean all the integers that we support

            * 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

            Some suggested values:
            DATA_TYPE BIGINT
            DECLARED_DATA_TYPE BIGINT
            NUMERIC_PRECISION 19
            NUMERIC_PRECISION_RADIX 10
            DECLARED_DATA_TYPE NULL
            DECLARED_NUMERIC_PRECISION NULL
            DECLARED_NUMERIC_SCALE NULL             		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

            * 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

            Some suggested values:
            DATA_TYPE BIGINT
            DECLARED_DATA_TYPE BIGINT
            NUMERIC_PRECISION 19
            NUMERIC_PRECISION_RADIX 10
            DECLARED_DATA_TYPE NULL
            DECLARED_NUMERIC_PRECISION NULL
            DECLARED_NUMERIC_SCALE NULL
            rucha174 Rucha Deodhar made changes -
            Description 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

            * 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

            Some suggested values:
            DATA_TYPE BIGINT
            DECLARED_DATA_TYPE BIGINT
            NUMERIC_PRECISION 19
            NUMERIC_PRECISION_RADIX 10
            DECLARED_DATA_TYPE NULL
            DECLARED_NUMERIC_PRECISION NULL
            DECLARED_NUMERIC_SCALE NULL             		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

            Some suggested values:
            DATA_TYPE BIGINT
            DECLARED_DATA_TYPE BIGINT
            NUMERIC_PRECISION 19
            NUMERIC_PRECISION_RADIX 10
            DECLARED_DATA_TYPE NULL
            DECLARED_NUMERIC_PRECISION NULL
            DECLARED_NUMERIC_SCALE NULL
            ycp Yuchen Pei made changes -
            Assignee Yuchen Pei [ JIRAUSER52627 ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Yuchen Pei [ JIRAUSER52627 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ycp Yuchen Pei made changes -
            Assignee Yuchen Pei [ JIRAUSER52627 ] Oleksandr Byelkin [ sanja ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.1 [ 28549 ]
            Fix Version/s 11.0 [ 28320 ]
            ycp Yuchen Pei made changes -
            Comment [ Hi Ralf,


            What does this change mean?

            Best,
            Yuchen
            ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.2 [ 28603 ]
            Fix Version/s 11.1 [ 28549 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.3 [ 28565 ]
            Fix Version/s 11.2 [ 28603 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.4 [ 29301 ]
            Fix Version/s 11.3 [ 28565 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Yuchen Pei [ JIRAUSER52627 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ycp Yuchen Pei made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            ycp Yuchen Pei made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            ycp Yuchen Pei made changes -
            Assignee Yuchen Pei [ JIRAUSER52627 ] Lena Startseva [ JIRAUSER50478 ]
            julien.fritsch Julien Fritsch made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            lstartseva Lena Startseva made changes -
            lstartseva Lena Startseva made changes -
            Assignee Lena Startseva [ JIRAUSER50478 ] Yuchen Pei [ JIRAUSER52627 ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            ycp Yuchen Pei made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 11.5 [ 29506 ]
            Fix Version/s 11.4 [ 29301 ]
            ycp Yuchen Pei made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            ycp Yuchen Pei made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            ycp Yuchen Pei made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            ycp Yuchen Pei made changes -
            Assignee Yuchen Pei [ JIRAUSER52627 ] Lena Startseva [ JIRAUSER50478 ]
            lstartseva Lena Startseva made changes -
            Assignee Lena Startseva [ JIRAUSER50478 ] Yuchen Pei [ JIRAUSER52627 ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            ycp Yuchen Pei made changes -
            Fix Version/s 11.5.1 [ 29634 ]
            Fix Version/s 11.5 [ 29506 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            elenst Elena Stepanova made changes -
            alice Alice Sherepa made changes -
            ycp Yuchen Pei made changes -
            julien.fritsch Julien Fritsch made changes -

            People

              ycp Yuchen Pei
              rucha174 Rucha Deodhar
              Votes:
              1 Vote for this issue
              Watchers:
              10 Start 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.