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

Fetch MariaDB Sequences metadata

    XMLWordPrintable

    Details

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

      Description

      We can fetch table's metadata using INFORMATION_SCHEMA.TABLES.

      Now I want to do something similar for SEQUENCES.

      I have been able get list of sequence names using the TABLE_TYPE = SEQUENCE filter in INFORMATION_SCHEMA.TABLES and I can get individual sequence information i.e max_value, min_value etc using

      SELECT * FROM sequenceName;

      But this creates difficulty since its difficult get all info at once. My present application design needs to get the information in bulk.

      Would it be possible to know in which server table is the sequence metadata stored and whether its accessible or not?

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            tanmaymajumdar Tanmay Majumdar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration