× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
nishtha(*) reported 2015-12-21T10:40:24Z  · narendravatsaraj(*) last modified 2016-02-01T05:42:03Z

PostgreSQL - Materialized View icon is not displayed in front of materialized views in 'Object Search' window in results.


Priority Low
Complexity Unknown
Component DB - PostgreSQL
Version 17.0

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".
 

3 attachments

Issue #14061

Closed
Fixed
Resolved 2015-12-22T15:33:30Z
 
 
Completion
No due date
Fixed Build v17.0.0-ga-10, v18.0.0-dev-31
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017