liquibase-oracle

liquibase-oracle copied to clipboard

MaterializedViewRefreshType simple type referenced in refreshMaterializedView element definition for refreshType attribute (line 205) is not defined in the schema anywhere. This renders the whole schema invalid.

src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'simpleType definition' component.
src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'type definition' component.

┆Issue is synchronized with this Jira Bug by Unito

I'm no expert, but according to DBMS_MVIEW.REFRESH it looks like the xsd should be updated to contain something like:

<xsd:simpleType name="MaterializedViewRefreshType">
    <xsd:restriction base="xsd:string">
        <xsd:enumeration value="always"></xsd:enumeration>
        <xsd:enumeration value="complete"></xsd:enumeration>
        <xsd:enumeration value="fast"></xsd:enumeration>
        <xsd:enumeration value="force"></xsd:enumeration>
        <xsd:enumeration value="partitions"></xsd:enumeration>
    </xsd:restriction>
</xsd:simpleType>

This will require more than an xsd schema change though - the values expected can be found at RefreshMaterializedViewOracle.java#L42; most of the above are missing and the second complete should be force.

(I'd submit a PR, but I haven't programmed in Java for a couple of decades.)