Oracle - Layer is not valid - won't open with both 3002 and 3006 geometries?

[qgib]

Author Name: Bryan Hall (Bryan Hall)
Original Redmine Issue: 11748
Affected QGIS version: 2.6.0
Redmine category:data_provider/oracle

---

I verified that all geometries in the table/col are valid. There are a small number of 3006 multiline geometries mixed in with the bulk of 3002 single line geometries, as well as null geometries. SQL trace shows the following is being executed:

SQL> SELECT srid FROM mdsys.all_sdo_geom_metadata WHERE owner='CVC' AND table_name='C_PATH_SEGMENT' AND column_name='GEOMETRY_L';

      SRID
----------
      8307

SQL> SELECT DISTINCT t."GEOMETRY_L".sdo_gtype FROM "CVC"."C_PATH_SEGMENT" t WHERE rownum<=2;

GEOMETRY_L.SDO_GTYPE
--------------------

                3002

SQL> SELECT DISTINCT t."GEOMETRY_L".SDO_GTYPE FROM "CVC"."C_PATH_SEGMENT" t WHERE NOT t."GEOMETRY_L" IS NULL;

GEOMETRY_L.SDO_GTYPE
--------------------
                3006
                3002

SQL> SELECT srid FROM mdsys.all_sdo_geom_metadata WHERE owner='CVC' AND table_name='C_PATH_SEGMENT' AND column_name='GEOMETRY_L';

      SRID
----------
      8307

SQL> SELECT DISTINCT t."GEOMETRY_L".sdo_gtype FROM "CVC"."C_PATH_SEGMENT" t WHERE rownum<=2;

GEOMETRY_L.SDO_GTYPE
--------------------

                3002

SQL> SELECT DISTINCT t."GEOMETRY_L".SDO_GTYPE FROM "CVC"."C_PATH_SEGMENT" t WHERE NOT t."GEOMETRY_L" IS NULL;

GEOMETRY_L.SDO_GTYPE
--------------------
                3006
                3002

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• category_id was changed from Data Provider to Data Provider/Oracle

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0
• regression was configured as 0

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

End of life notice: QGIS 2.18 LTR

Source:
http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/

---

• resolution was changed from to end of life
• status_id was changed from Open to Closed