You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@netbeans.apache.org by "Stefan Sonnenberg-Carstens (Jira)" <ji...@apache.org> on 2020/09/18 17:03:00 UTC
[jira] [Updated] (NETBEANS-4816) NetBeans database explorer does
not handle partitioned tables in PostgreSQL correctly
[ https://issues.apache.org/jira/browse/NETBEANS-4816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Sonnenberg-Carstens updated NETBEANS-4816:
-------------------------------------------------
Description:
To reproduce:
connect to a PostgreSQL database (in my case 12.4)
issue the following commands:
{code:sql}
DROP TABLE IF EXISTS T1;
CREATE TABLE T1 (ID INTEGER, MESSAGE TEXT, TIMESTAMP TIMESTAMP) PARTITION BY RANGE (TIMESTAMP); CREATE TABLE T1_2020 PARTITION OF T1 FOR VALUES FROM ('2020-01-01') TO ('2020-12-31'); CREATE TABLE T1_2021 PARTITION OF T1 FOR VALUES FROM ('2021-01-01') TO ('2021-12-31'); CREATE TABLE T1_2022 PARTITION OF T1 FOR VALUES FROM ('2022-01-01') TO ('2022-12-31'); CREATE TABLE T1_2023 PARTITION OF T1 FOR VALUES FROM ('2023-01-01') TO ('2023-12-31');{code}
After successful execution you will see a picture like this below:
!image-2020-09-18-18-55-37-559.png!
The base table T1 is not visible at all and the sub-tables are shown as if they were regular tables.
The same schema will be shown in IntelliJ like this (which is correct imho):
!image-2020-09-18-19-00-36-938.png!
T1 will be shown as a regular table and the attached partition tables / sub-tables are shown below it. This makes clear, that t1 is partitioned.
At least all tables including t1 should be visible.
was:
To reproduce:
connect to a PostgreSQL database (in my case 12.4)
issue the following commands:
{code:sql}
DROP TABLE IF EXISTS T1;
CREATE TABLE T1 (ID INTEGER, MESSAGE TEXT, TIMESTAMP TIMESTAMP) PARTITION BY RANGE (TIMESTAMP); CREATE TABLE T1_2020 PARTITION OF T1 FOR VALUES FROM ('2020-01-01') TO ('2020-12-31'); CREATE TABLE T1_2021 PARTITION OF T1 FOR VALUES FROM ('2021-01-01') TO ('2021-12-31'); CREATE TABLE T1_2022 PARTITION OF T1 FOR VALUES FROM ('2022-01-01') TO ('2022-12-31'); CREATE TABLE T1_2023 PARTITION OF T1 FOR VALUES FROM ('2023-01-01') TO ('2023-12-31');{code}
After successful execution you will see a picture like this below:
!image-2020-09-18-18-55-37-559.png!
The base table T1 is not visible at all and the sub-tables are shown as if they were regular tables.
The same schema will be shown in IntelliJ like this (which is correct imho):
!image-2020-09-18-19-00-36-938.png!
T1 will be shown as a regular table and the attached partition tables / sub-tables are shown below it. This makes clear, that t1 is partitioned.
> NetBeans database explorer does not handle partitioned tables in PostgreSQL correctly
> -------------------------------------------------------------------------------------
>
> Key: NETBEANS-4816
> URL: https://issues.apache.org/jira/browse/NETBEANS-4816
> Project: NetBeans
> Issue Type: Improvement
> Components: db - Show Data
> Affects Versions: 12.1
> Reporter: Stefan Sonnenberg-Carstens
> Priority: Major
> Attachments: image-2020-09-18-18-55-37-559.png, image-2020-09-18-19-00-36-938.png
>
>
> To reproduce:
> connect to a PostgreSQL database (in my case 12.4)
> issue the following commands:
> {code:sql}
> DROP TABLE IF EXISTS T1;
> CREATE TABLE T1 (ID INTEGER, MESSAGE TEXT, TIMESTAMP TIMESTAMP) PARTITION BY RANGE (TIMESTAMP); CREATE TABLE T1_2020 PARTITION OF T1 FOR VALUES FROM ('2020-01-01') TO ('2020-12-31'); CREATE TABLE T1_2021 PARTITION OF T1 FOR VALUES FROM ('2021-01-01') TO ('2021-12-31'); CREATE TABLE T1_2022 PARTITION OF T1 FOR VALUES FROM ('2022-01-01') TO ('2022-12-31'); CREATE TABLE T1_2023 PARTITION OF T1 FOR VALUES FROM ('2023-01-01') TO ('2023-12-31');{code}
> After successful execution you will see a picture like this below:
> !image-2020-09-18-18-55-37-559.png!
> The base table T1 is not visible at all and the sub-tables are shown as if they were regular tables.
> The same schema will be shown in IntelliJ like this (which is correct imho):
> !image-2020-09-18-19-00-36-938.png!
> T1 will be shown as a regular table and the attached partition tables / sub-tables are shown below it. This makes clear, that t1 is partitioned.
> At least all tables including t1 should be visible.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@netbeans.apache.org
For additional commands, e-mail: commits-help@netbeans.apache.org
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists