11gR2: function sdo_geom.sdo_union has a BUG?!
may be, we found the BUG of the function sdo_union from sdo_geom package for release 11.2.0.3.0 - Windows 64bit / AIX 64b.
This test case returns NULL, but previous version 10.2.0.4 returns right result. This wrong result i got also for the sdo_aggr_union too.
Test case:select sdo_geom.sdo_union(sdo_geometry('POLYGON ((-760545.75 -1094499.625, -760545.75 -1094748.625, -760233.75 -1094748.625, -760233.75 -1094499.625, -760233.75 -1094250.625, -760233.75 -1094001.625, -760233.75 -1093752.625, -760233.75 -1093503.625, -760129.75 -1093503.625, -760129.75 -1093254.625, -760129.75 -1093005.625, -760025.75 -1093005.625, -760025.75 -1092756.625, -759921.75 -1092756.625, -759921.75 -1092507.625, -759921.75 -1092258.625, -759921.75 -1092009.625, -759921.75 -1091760.625, -760025.75 -1091760.625, -760025.75 -1091511.625, -760129.75 -1091511.625, -760129.75 -1091262.625, -760233.75 -1091262.625, -760233.75 -1091013.625, -760129.75 -1091013.625, -760129.75 -1090764.625, -759921.75 -1090764.625, -759921.75 -1090515.625, -759817.75 -1090515.625, -759817.75 -1090266.625, -759713.75 -1090266.625, -759713.75 -1090017.625, -759505.75 -1090017.625, -759505.75 -1089934.625, -759297.75 -1089934.625, -759193.75 -1089934.625, -758985.75 -1089934.625, -758985.75 -1090017.625, -758673.75 -1090017.625, -758673.75 -1090183.625, -758361.75 -1090183.625, -758049.75 -1090183.625, -758049.75 -1090100.625, -757737.75 -1090100.625, -757737.75 -1089851.625, -757529.75 -1089851.625, -757217.75 -1089851.625, -757217.75 -1089685.625, -756905.75 -1089685.625, -756905.75