1

GDAL 2.2.4 (64bit Windows) throws an error during opening of a cyclic OGRVRT file.

There was no problem with cyclic VRTs in GDAL 1.10.1 (32bit Windows).

Here is a sample VRT file, which I used to join an ORACLE table with a MSSQL table:

<!-- file: myJoin.ovf -->
<OGRVRTDataSource>
    <OGRVRTLayer name="mssql">
        <SrcDataSource relativeToVRT="1">mssql.ovf</SrcDataSource>
        <GeometryType>wkbNone</GeometryType>
        <SrcSQL>SELECT * from mssql</SrcSQL>
    </OGRVRTLayer>
    <OGRVRTLayer name="oracle">
        <SrcDataSource relativeToVRT="1">oracle.ovf</SrcDataSource>
        <GeometryType>wkbPoint</GeometryType>
        <SrcLayer>oracle</SrcLayer>
    </OGRVRTLayer>
    <OGRVRTLayer name="myJoin">
        <SrcDataSource relativeToVRT="1">myJoin.ovf</SrcDataSource>
        <GeometryType>wkbPoint</GeometryType>
        <SrcSQL dialect="sqlite">
        SELECT o.*,m.ui_status from oracle o left join mssql m on o.uwi = m.ui
        </SrcSQL>
    </OGRVRTLayer>
</OGRVRTDataSource>

ogrinfo (GDAL 2.2.4) throws an error:

D:\data>ogrinfo -ro myJoin.ovf
INFO: Open of `myJoin.ovf'
      using driver `OGR_VRT' successful.
1: MSSQL (None)
2: ORACLE (Point)
3: MYJOINERROR 1: Cyclic VRT opening detected !
 (None)

Is there any mechanism/flag, that prevents the "Cyclic VRT" detection and allows to use cyclic VRT files again?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.