Product: Aqua Data Studio
Version: 17.0.0-ga-10
From Issue #14061
Steps to reproduce the issue :
1) Connect to PostgreSQL 9.3.6 or PostgreSQL 9.4.2.
2) Create a Table.
CREATE TABLE "public"."invoice" (
"invoice_no" int4 NOT NULL,
"seller_no" int4 NULL,
"invoice_date" date NULL,
"invoice_amt" numeric(13,2) NULL,
PRIMARY KEY("invoice_no")
)
GO
3) Create a Materialized View on above Table.
CREATE MATERIALIZED VIEW "public"."sales_summary"
AS
SELECT invoice.seller_no,
invoice.invoice_date,
(sum(invoice.invoice_amt))::numeric(13,2) AS sales_amt
FROM invoice
WHERE (invoice.invoice_date < ('now'::text)::date)
GROUP BY invoice.seller_no, invoice.invoice_date
ORDER BY invoice.seller_no, invoice.invoice_date
WITH DATA
GO
4) Now Right click on materialized View "Sales_summary" and Select 'Tools -> Object Search' option.
5) In Object Search Window, Select Database and Select Schema in which we have created above materialized view.
From 'Object Types' section select "Materialized Views".
6) From 'Object Search' section, Select 'Object Names' and click on 'Search' Button.
Actual Result :
In 'Object Type' column 'MAT_VIEW' is displayed instead of 'MATERIALIZED VIEW'.
Expected Result :
Can we have materialized view objects read as type 'MATERIALIZED_VIEW' instead of 'MAT_VIEW'.
Please refer attached screen-shot "MaterializedViews_ObjectType.png".
Observation :
In Schema Script Generator window if we Save script in one file with 'Include Descriptive Header' option checked, In Descriptive Header also 'MAT_VIEW' is displayed as Object Type instead of 'MATERIALIZED VIEW'.
Issue #14077 |
New |
Completion |
No due date |
No fixed build |
No time estimate |