Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2.2-1, 10.2.2-2
Description
Not all table partitioning has the ability to add a so called "catch all". The catch all is present in range partitioning:
partition last values less than(MAXVALUE)
The proposal is to add similar statements to list partitioning: Proposed syntax:
partition last values not in other
Benefits: No more insert exceptions, giving the DBA more choices in applying this partitioning with less effort.
Oracle uses the following syntax for this:
CREATE TABLE h2 (c1 NUMBER,c2 NUMBER)
PARTITION BY LIST(c1) (
PARTITION p0 VALUES (1, 4, 7),
PARTITION p1 VALUES (2, 5, 8),
PARTITION p3 VALUES(DEFAULT)
We should probably use the DEFAULT syntax for this.
Attachments
Issue Links
- is part of
-
MDEV-10137 Providing compatibility to other databases
-
- Open
-
- relates to
-
-
- Open
-
-
MDEV-10763 Wrong result - server does not return NULL values from default list partition after ALTER table
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
MDEV-22163 Adding OVERFLOW partition
-
- Open
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Not all table partitioning has the ability to add a so called "catch all". The catch all is present in range partitioning: partition last values less than(MAXVALUE) The proposal is to add similar statements to list partitioning: Proposed syntax: partition last values not in other Benefits: No more insert exceptions, giving the DBA more choices in applying this partitioning with less effort. |
Not all table partitioning has the ability to add a so called "catch all". The catch all is present in range partitioning:
partition last values less than(MAXVALUE) The proposal is to add similar statements to list partitioning: Proposed syntax: partition last values not in other Benefits: No more insert exceptions, giving the DBA more choices in applying this partitioning with less effort. Oracle uses the following syntax for this: CREATE TABLE h2 (c1 NUMBER,c2 NUMBER) PARTITION BY LIST(c1) ( PARTITION p0 VALUES (1, 4, 7), PARTITION p1 VALUES (2, 5, 8), PARTITION p3 VALUES(DEFAULT) We should probably use the DEFAULT syntax for this. |
| Link | This issue is part of MDEV-10137 [ MDEV-10137 ] |
| Assignee | Oleksandr Byelkin [ sanja ] |
| Labels | Compatibility |
| Sprint | Compatibility-1 [ 88 ] |
| Fix Version/s | 10.2 [ 14601 ] |
| Sprint | Compatibility-1 [ 88 ] | 10.2.2-1 [ 89 ] |
| Rank | Ranked higher |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Sprint | 10.2.2-1 [ 89 ] | 10.2.2-1, 10.2.2-2 [ 89, 92 ] |
| Rank | Ranked lower |
| Assignee | Oleksandr Byelkin [ sanja ] | Michael Widenius [ monty ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Link | This issue relates to MDEV-10760 [ MDEV-10760 ] |
| Assignee | Michael Widenius [ monty ] | Oleksandr Byelkin [ sanja ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.2.3 [ 22115 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Fix Version/s | 10.2.2 [ 22013 ] | |
| Fix Version/s | 10.2.3 [ 22115 ] |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Labels | Compatibility | Approved Compatibility |
| Labels | Approved Compatibility | Compatibility |
| Labels | Compatibility | Approved Compatibility |
| Epic Link | MDEV-10872 [ 58182 ] |
| Attachment | MDEV-8348.zip [ 42679 ] |
| Labels | Approved Compatibility | Approved Compatibility NRE-307517 |
| NRE Projects | NRE-307517 |
| Labels | Approved Compatibility NRE-307517 | Approved Compatibility |
| NRE Approved | Yes [ 10304 ] |
| Labels | Approved Compatibility | Compatibility |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Link | This issue relates to MDEV-22163 [ MDEV-22163 ] |
| Workflow | MariaDB v3 [ 70100 ] | MariaDB v4 [ 132638 ] |