Subpartitions not showing - 03/30/22 10:17 AM
Hello,
Subpartitions are not shown in table view page.
Example:
14.0.6:
![[Linked Image]](https://forums.allroundautomations.com/ubb//ubbthreads.php?ubb=download&Number=130&filename=ver14.png)
15.0.0 Beta 8:
![ver14.png Attached picture ver14.png](/ubb/ubbthreads.php?ubb=download&Number=130&filename=ver14.png)
![ver15.png Attached picture ver15.png](/ubb/ubbthreads.php?ubb=download&Number=131&filename=ver15.png)
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:
![[Linked Image]](https://forums.allroundautomations.com/ubb//ubbthreads.php?ubb=download&Number=130&filename=ver14.png)
15.0.0 Beta 8:
![[Linked Image]](https://forums.allroundautomations.com/ubb//ubbthreads.php?ubb=download&Number=131&filename=ver15.png)
![ver14.png Attached picture ver14.png](/ubb/ubbthreads.php?ubb=download&Number=130&filename=ver14.png)
![ver15.png Attached picture ver15.png](/ubb/ubbthreads.php?ubb=download&Number=131&filename=ver15.png)