Sdo_aggr_concat_lines On Parallel Table Gives Null Result (Doc ID 1122458.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

  • sdo_aggr_concat_lines on table with PARALLEL degree gives NULL result

  • The following sample demonstrates the problem:

    C:\>sqlplus scott/tiger

    SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jun 11 09:47:41 2010

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> drop table t_aggr;

    Table dropped.

    SQL> create table t_aggr (lijn mdsys.sdo_geometry)
    2 parallel;

    Table created.

    SQL> insert into t_aggr values(
    2 SDO_GEOMETRY(2002, 262150, NULL,
    3 SDO_ELEM_INFO_ARRAY(1, 2, 1),
    4 SDO_ORDINATE_ARRAY(121859553, 453553486, 121858480, 453552795)));

    1 row created.

    SQL> insert into t_aggr values(
    2 SDO_GEOMETRY(2002, 262150, NULL,
    3 SDO_ELEM_INFO_ARRAY(1, 2, 1),
    4 SDO_ORDINATE_ARRAY(121859678, 453557896, 121861611, 453554812)));

    1 row created.

    SQL> insert into t_aggr values(
    2 SDO_GEOMETRY(2002, 262150, NULL,
    3 SDO_ELEM_INFO_ARRAY(1, 2, 1),
    4 SDO_ORDINATE_ARRAY(121859678, 453557896, 121858607, 453557146,
    5 121858902, 453556549, 121856872, 453555246, 121858480, 453552795)));

    1 row created.

    SQL> insert into t_aggr values(
    2 SDO_GEOMETRY(2002, 262150, NULL,
    3 SDO_ELEM_INFO_ARRAY(1, 2, 1),
    4 SDO_ORDINATE_ARRAY(121859553, 453553486, 121861611, 453554812)));

    1 row created.

    SQL> select sdo_aggr_concat_lines(lijn)
    2 from t_aggr;

    SDO_AGGR_CONCAT_LINES(LIJN)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_IN
    --------------------------------------------------------------------------------


    SQL>

  • The same query brings back a result in 11.1.0.7 and 11.2.0.1:

    SQL> select sdo_aggr_concat_lines(lijn)
    2 from t_aggr
    3 ;

    SDO_AGGR_CONCAT_LINES(LIJN)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_IN
    --------------------------------------------------------------------------------
    SDO_GEOMETRY(2002, 262150, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRA
    Y(121861611, 453554812, 121859678, 453557896, 121858607, 453557146, 121858902, 4
    53556549, 121856872, 453555246, 121858480, 453552795, 121859553, 453553486, 1218
    61611, 453554812))


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms