[MDEV-25729] Fetch MariaDB Sequences metadata Created: 2021-05-19 Updated: 2023-02-03 Resolved: 2023-02-03 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Sequences |
| Fix Version/s: | 11.0 |
| Type: | Task | Priority: | Major |
| Reporter: | Tanmay Majumdar | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| 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? |
| Comments |
| Comment by Sergei Golubchik [ 2021-05-20 ] |
|
In the standard there is INFORMATION_SCHEMA.SEQUENCES view. We should implement it |
| Comment by Tanmay Majumdar [ 2021-06-04 ] |
|
@Sergei . Would it possible to include this in 10.6? |
| Comment by Sergei Golubchik [ 2021-06-05 ] |
|
unfortunately, it's not very likely, 10.6 should be be closed for new features basically in a few days |
| Comment by Yuchen Pei [ 2023-02-03 ] |
|
The present ticket is a duplicate of the third bullet point in MDEV-28152 |