Product: Aqua Data Studio
Version: 17.0.0-ga-9
Build #: 47896
Build Date: 2015-Dec-20 07:19:01 PM
Operating Environment: Linux (3.13.0-62-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072; Total=285,736,960; Free=178,942,096; CPUs=8
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 :
Existing Materialized views are displayed but materialized view icon is not displayed in front of them.
Also in 'Object Type' column 'MAT_VIEW' is displayed instead of 'MATERIALIZED VIEW'.
Expected Result :
Materialized view icon should be displayed in front of materialized views and in 'Object Type' column 'MATERIALIZED VIEW' should be displayed.
Please refer attached screenshot "Object Search_Materialized Views.png".
|
115 KB
|
114 KB
|
229 KB
There was an object type mismatching which was causing materialized views to not associate there icons. Fixed... Icons should now appear next to materialized views.
In ADS 17.0.0-ga-10, Icons appear next to materialized views.
But in 'Object Type' column 'MAT_VIEW' is displayed.
Is this correct or it should display 'MATERIALIZED VIEW' here ?
Please refer attached screenshot "14061_ADS17.0.0-ga-10.png".
In ADS 17.0.0-ga-10, Icons appear next to materialized views.
But in 'Object Type' column 'MAT_VIEW' is displayed.
Is this correct or it should display 'MATERIALIZED VIEW' here ?
Please refer attached screenshot "14061_ADS17.0.0-ga-10.png".
We have used MAT_VIEW as the object type through the app in other databases. When i initially did the support for object search for postgreSQL I added MATERIALIZED_VIEW which then didn't map to MAT_VIEW. I synced them to MAT_VIEW since it was already been used through. This associated it to the MAT_VIEW icon. If we want to change this type to MATERIALIZED_VIEW it will require modifications that will affect other databases. For now its best to just match what was already been used as this would cause the least amount of regression testing. If we wish to fill an issue for a future version to have materialized view objects read as type [MATERIALIZED_VIEW] instead of [MAT_VIEW] it is an easy fix, but should go through regression testing on all dbs supporting materialized views.
We have used MAT_VIEW as the object type through the app in other databases. When i initially did the support for object search for postgreSQL I added MATERIALIZED_VIEW which then didn't map to MAT_VIEW. I synced them to MAT_VIEW since it was already been used through. This associated it to the MAT_VIEW icon. If we want to change this type to MATERIALIZED_VIEW it will require modifications that will affect other databases. For now its best to just match what was already been used as this would cause the least amount of regression testing. If we wish to fill an issue for a future version to have materialized view objects read as type [MATERIALIZED_VIEW] instead of [MAT_VIEW] it is an easy fix, but should go through regression testing on all dbs supporting materialized views.
Verified in ADS 17.0.0-ga-10, Now icons appear next to materialized views.
Filed a new enhancement (Issue #14077) for displaying materialized view objects as [MATERIALIZED_VIEW] instead of [MAT_VIEW] as suggested by Ivan.
Verified in ADS 17.0.0-ga-10, Now icons appear next to materialized views.
Filed a new enhancement (Issue #14077) for displaying materialized view objects as [MATERIALIZED_VIEW] instead of [MAT_VIEW] as suggested by Ivan.
Issue #14061 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v17.0.0-ga-10, v18.0.0-dev-31 |
No time estimate |
There was an object type mismatching which was causing materialized views to not associate there icons. Fixed... Icons should now appear next to materialized views.