QGIS » QGIS Application

If a layer has mixed SDO_GEOMETRY Point definition, SDO_POINT_TYPE or SDO_ELEM_INFO_ARRAY and SDO_ORDINATE_ARRAY, QOciSpatial replaced points defined by SDO_POINT_TYPE by the preceding point defined with SDO_ELEM_INFO_ARRAY and SDO_ORDINATE_ARRAY. It seems that QOCISpatialResultPrivate.sdoobj is not well cleared between rows.

In qsql_ocispatial:2524 the length of SDO_ELEM_INFO_ARRAY is read:

  int nElems;
  if ( !getArraySize( sdoobj->elem_info, nElems ) )
  {
    qWarning() << "could not determine element info array size";
    return false;
  }

nElems has to be equal to 0, if the point has been defined with SDO_POINT_TYPE. But it is not if a preceding Point has been defined with SDO_ELEM_INFO_ARRAY and SDO_ORDINATE_ARRAY like that:

CREATE TABLE QGIS.POINT_DATA ( "pk" INTEGER PRIMARY KEY, GEOM SDO_GEOMETRY);
INSERT INTO QGIS.POINT_DATA ("pk", GEOM)
 SELECT 1, SDO_GEOMETRY( 2001,4326,SDO_POINT_TYPE(1, 2, NULL), NULL, NULL) from dual
  UNION ALL SELECT 2, SDO_GEOMETRY( 3001,4326,SDO_POINT_TYPE(1, 2, 3), NULL, NULL) from dual
  UNION ALL SELECT 3, SDO_GEOMETRY( 3005,4326,NULL, sdo_elem_info_array (1,1,1, 4,1,1), sdo_ordinate_array (1,2,3, 4,5,6)) from dual
  UNION ALL SELECT 4, SDO_GEOMETRY( 2005,4326,NULL, sdo_elem_info_array (1,1,1, 3,1,1), sdo_ordinate_array (1,2, 3,4)) from dual
  UNION ALL SELECT 5, SDO_GEOMETRY( 3005,4326,NULL, sdo_elem_info_array (1,1,2), sdo_ordinate_array (1,2,3, 4,5,6)) from dual
  UNION ALL SELECT 6, SDO_GEOMETRY( 2001,4326,NULL, sdo_elem_info_array (1,1,1), sdo_ordinate_array (1,2)) from dual
  UNION ALL SELECT 7, SDO_GEOMETRY( 2001,4326, SDO_POINT_TYPE(3, 4, NULL), NULL, NULL) from dual
  UNION ALL SELECT 8, SDO_GEOMETRY( 2001,4326,NULL, sdo_elem_info_array (1,1,1), sdo_ordinate_array (5,6)) from dual;

In this case, the 7th Point will be the same has the 6th.

A pull request has been created to test and fix this issue: https://github.com/qgis/QGIS/pull/6923