Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.5.21, 10.3(EOL), 10.4(EOL), 10.6
-
None
Description
When wanting to do a selective restore of a backup taken with mariabackup DISCARD TABLESPACE / IMPORT TABLESPACE is used after preparing the backup with mariabackup --prepare --export
When having a SEQUENCE backed by an InnoDB table the related .ibd tablespace file can't be discarded though:
MariaDB [test]> alter table test_sequence discard tablespace;
|
ERROR 1031 (HY000): Storage engine SEQUENCE of the table `test`.`test_sequence` doesn't have this option
|
So there does not seem to be a way to restore such a sequence from a physical backup like mariabackup.
IMHO the SEQUENCE engine here should not just outright refuse such ALTER attempts, but pass them through to the underlying engine actually used for sequence storage.
Attachments
Issue Links
- relates to
-
MDEV-35144 CREATE TABLE ... LIKE uses current innodb_compression_default instead of the create value
-
- Closed
-
-
MDEV-10139 Support for SEQUENCE objects
-
- Closed
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
2d 46m | 1 |
|
262d 3h 46m | 1 |
|
62d 3h 28m | 1 |
|
43d 19h 10m | 1 |
|
1d 2h 57m | 1 |
|
4d 20h 51m | 1 |
|
2d 3h 4m | 1 |