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.