mezonix
Member
Hello,
Subpartitions are not shown in table view page.
Example:
14.0.6:
15.0.0 Beta 8:
Subpartitions are not shown in table view page.
Example:
SQL:
create table test_subpartition
( type_id integer
, event_date timestamp(6) with local time zone
, value number
) partition by list (type_id)
subpartition by range (event_date)
(
partition p1 values (1)
( subpartition p1_past values less than (timestamp'2000-01-01 00:00:00.000000000+00:00')
, subpartition p1_01 values less than (timestamp'2001-01-01 00:00:00.000000000+00:00')
, subpartition p1_02 values less than (timestamp'2002-01-01 00:00:00.000000000+00:00')
),
partition p2 values (2)
( subpartition p2_past values less than (timestamp'2000-01-01 00:00:00.000000000+00:00')
, subpartition p2_01 values less than (timestamp'2001-01-01 00:00:00.000000000+00:00')
, subpartition p2_02 values less than (timestamp'2002-01-01 00:00:00.000000000+00:00')
)
);
14.0.6:
15.0.0 Beta 8: