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

AliSQL: [Feature] Issue #41 Sequence Engine

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Fix Version/s: N/A
    • Component/s: Sequences
    • Labels:
      None

      Description

      Description:
      ------------
      SEQUENCE engine as an embedded logical engine, it mainly used to generate unique number,
      it is the middle layer engine that use InnoDB or other storage engine as the based table engine,
      All query on sequence table will be changed into the operation on based table.
      the cache or other sequence value management is decided by SEQUENCE engine handler.
       
      According to the setting which is defined by 'CREATE SEQUENCE ... ' or 'CREATE SEQUENCE TABLE... + INSERT VALUES'.
      user can query the nextval or currval from sequence.
      In order to distinguish the normal SELECT statement, we supply new Syntax 'SELECT NEXTVAL FOR SEQUENCE';
        1. 'SELECT NEXTVAL FROM SEQUENCE' will return the based table record directly.
        2. 'SELECT NEXTVAL FOR SEQUENCE' will return the iteratored record.
       
      Syntax:
      -------
      CREATE SEQUENCE SYNTAX:
       
      CREATE SEQUENCE [IF NOT EXISTS] schema.sequence_name
         [START WITH <constant>]
         [MINVALUE <constant>]
         [MAXVALUE <constant>]
         [INCREMENT BY <constant>]
         [CACHE <constant> | NOCACHE]
         [CYCLE | NOCYCLE]
        ;
       
      OR:
        CREATE SEQUENCE schema.sequence_name (
        `currval` bigint(21) NOT NULL COMMENT 'current value',
        `nextval` bigint(21) NOT NULL COMMENT 'next value',
        `minvalue` bigint(21) NOT NULL COMMENT 'min value',
        `maxvalue` bigint(21) NOT NULL COMMENT 'max value',
        `start` bigint(21) NOT NULL COMMENT 'start value',
        `increment` bigint(21) NOT NULL COMMENT 'increment value',
        `cache` bigint(21) NOT NULL COMMENT 'cache size',
        `cycle` bigint(21) NOT NULL COMMENT 'cycle state',
        `round` bigint(21) NOT NULL COMMENT 'already how many round'
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
       
      INSERT INTO schema.sequence_name VALUES(0,0,1,9223372036854775807,1,1,10000,1,0);
      COMMIT;
       
      Strongly recommend the first CREATE SEQUENCE syntax.
       
      SHOW SYNTAX:
        SHOW CREATE SEQUENCE schema.sequence_name;
        SHOW CREATE TABLE schema.sequence_name;
       
      QUERY SYNTAX:
        SELECT [nextval | currval | *] FOR schema.sequence_name;
        SELECT [nextval | currval | *] FROM schema.sequence_name;
       
      Usage:
      ------
      FOR EXAMPLE:
        create sequence s;
        create table t(id int);
        select nextval for s;
        insert into t select nextval for s;
      

      https://github.com/alibaba/AliSQL/commit/b2f60ae9106156b456ddc76fc148b0edbca1c66e

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              monty Michael Widenius
              Reporter:
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: