Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5
-
None
Description
Currently state:
- One can create a partitioned S3 table with multiple partitions
- One can add a new table to a partitioned table with "alter table archive exchange partition"
One can't however add new partitions with ALTER TABLE ADD PARTITION
This tasks it ensure that most partition commands that doesn't change data should work with the S3 engine.
The current suggested implementation is focused to get all ALTER PARTITION commands to work, with the exception of:
REBUILD PARTITION
TRUNCATE PARTITION
REORGANIZE PARTITION
As part of this task, partitioned S3 tables are also properly replicated and can be discovered by remote servers that shares the same S3 instance.
Attachments
Issue Links
- relates to
-
MDEV-17841 S3 Storage engine
-
- Closed
-
-
-
- Open
-
-
MDEV-22168 Supporting multiple engines with table partitioning
-
- Stalled
-
-
-
- Open
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Parent |
|
|
| Issue Type | Bug [ 1 ] | Technical task [ 7 ] |
| Parent |
|
|
| Issue Type | Technical task [ 7 ] | Bug [ 1 ] |
| Link |
This issue relates to |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Summary | Add support for add partition to S3 | S3 partitioning support |
| Description |
Currently one can't add new partitions to a S3 partitioned table.
This tasks it ensure that most partition commands that doesn't change data should work. The current suggested implementation is focused to get all ALTER PARTITION commands to work, with the exception of: REBUILD PARTITION TRUNCATE PARTITION REORGANIZE PARTITION |
Currently state:
- One can create a partitioned S3 table with multiple partitions - One can add a new table to a partitioned table with "alter table archive exchange partition" One can't however add new partitions with ALTER TABLE ADD PARTITION This tasks it ensure that most partition commands that doesn't change data should work with the S3 engine. The current suggested implementation is focused to get all ALTER PARTITION commands to work, with the exception of: REBUILD PARTITION TRUNCATE PARTITION REORGANIZE PARTITION |
| Link | This issue relates to MDEV-22168 [ MDEV-22168 ] |
| Link | This issue relates to MDEV-22162 [ MDEV-22162 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| issue.field.resolutiondate | 2020-04-20 12:47:52.0 | 2020-04-20 12:47:52.917 |
| Fix Version/s | 10.5.3 [ 24263 ] | |
| Fix Version/s | 10.5.4 [ 24264 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Description |
Currently state:
- One can create a partitioned S3 table with multiple partitions - One can add a new table to a partitioned table with "alter table archive exchange partition" One can't however add new partitions with ALTER TABLE ADD PARTITION This tasks it ensure that most partition commands that doesn't change data should work with the S3 engine. The current suggested implementation is focused to get all ALTER PARTITION commands to work, with the exception of: REBUILD PARTITION TRUNCATE PARTITION REORGANIZE PARTITION |
Currently state:
- One can create a partitioned S3 table with multiple partitions - One can add a new table to a partitioned table with "alter table archive exchange partition" One can't however add new partitions with ALTER TABLE ADD PARTITION This tasks it ensure that most partition commands that doesn't change data should work with the S3 engine. The current suggested implementation is focused to get all ALTER PARTITION commands to work, with the exception of: REBUILD PARTITION TRUNCATE PARTITION REORGANIZE PARTITION As part of this task, partitioned S3 tables are also properly replicated and can be discovered by remote servers that shares the same S3 instance. |
| Link |
This issue relates to |
| Link | This issue relates to MDEV-22642 [ MDEV-22642 ] |
| Component/s | Partitioning [ 10802 ] |
| Link | This issue relates to MENT-1199 [ MENT-1199 ] |
| Workflow | MariaDB v3 [ 106370 ] | MariaDB v4 [ 157516 ] |
| Link | This issue relates to MENT-1611 [ MENT-1611 ] |