[Fdo-trac] [fdo-trac] #1003: Materialized Views not filtered

FDO trac_fdo at osgeo.org
Tue Jun 13 08:06:08 PDT 2023


#1003: Materialized Views not filtered
--------------------------------+-----------------------
   Reporter:  dfanetti          |      Owner:  gregboone
       Type:  defect            |     Status:  new
   Priority:  major             |  Milestone:  4.1.0
  Component:  PostGIS Provider  |    Version:  4.1.0
   Severity:  3                 |   Keywords:
External ID:                    |
--------------------------------+-----------------------
 In the file
 Providers/GenericRdbms/Src/PostGis/SchemaMgr/Ph/Rd/DbObjectReader.cpp, the
 function MakeQueryReader does not filter the materialized views present in
 the database. When trying to search for a view by providing the schema
 name and table name, the result obtained is a set consisting of the
 desired view and all the materialized views present in the database (which
 are not filtered).

 The proposed solution would be to extend the input filter to also include
 the part of the query after UNION that searches for materialized views.
-- 
Ticket URL: <https://trac.osgeo.org/fdo/ticket/1003>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list