Subpartitions not showing - 03/30/22 10:17 AM
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 Query
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: