[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