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

Features for sequence

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: 10.12
    • Component/s: Sequences
    • Labels:
      None

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              rucha174 Rucha Deodhar
              Reporter:
              rucha174 Rucha Deodhar
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start 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.