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

Fetch MariaDB Sequences metadata

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • N/A
    • Sequences
    • 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

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-28152 Features for sequence

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

          Activity

            Ascending order - Click to sort in descending order
            tanmaymajumdar Tanmay Majumdar created issue -
            tanmaymajumdar Tanmay Majumdar made changes -
            Field Original Value New Value
            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 _schemaName_;

            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?             		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?
            serg Sergei Golubchik added a comment -

            In the standard there is INFORMATION_SCHEMA.SEQUENCES view. We should implement it

            serg Sergei Golubchik added a comment - In the standard there is INFORMATION_SCHEMA.SEQUENCES view. We should implement it
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            tanmaymajumdar Tanmay Majumdar added a comment -

            @Sergei . Would it possible to include this in 10.6?

            tanmaymajumdar Tanmay Majumdar added a comment - @Sergei . Would it possible to include this in 10.6?
            serg Sergei Golubchik added a comment -

            unfortunately, it's not very likely, 10.6 should be be closed for new features basically in a few days

            serg Sergei Golubchik added a comment - unfortunately, it's not very likely, 10.6 should be be closed for new features basically in a few days
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 121988 ] MariaDB v4 [ 131500 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            ycp Yuchen Pei added a comment -

            The present ticket is a duplicate of the third bullet point in MDEV-28152

            ycp Yuchen Pei added a comment - The present ticket is a duplicate of the third bullet point in MDEV-28152
            ycp Yuchen Pei made changes -
            Fix Version/s N/A [ 14700 ]
            Resolution Duplicate [ 3 ]
            Status Open [ 1 ] Closed [ 6 ]
            ycp Yuchen Pei made changes -
            Fix Version/s 11.0 [ 28320 ]
            Fix Version/s N/A [ 14700 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 11.0(EOL) [ 28320 ]

            People

              Unassigned Unassigned
              tanmaymajumdar Tanmay Majumdar
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.