Re: Interesting Issue related to sql result

Hi Eriovaldo,

You need to trace both queries with event 10053 and compare these traces. Usually such behavior is related to bugs during query transformation, so the easiest way is to analyze "final query after transformations" section and disable wrong transformation.
Or you can just add the hint no_query_transformarion and check if it returns right data.

чт, 5 апр. 2018 г., 22:26 Eriovaldo Andrietta <ecandrietta_at_gmail.com>:

> HI,
>
> Does anyone knows ​what happens in this cenary :
>
> I have a query like this.
>
> SELECT /*+ parallel
> (area_control,6)
> parallel (lot_f,6)
> */
> lot_f.id,
> lot_f.lot_id
> FROM op_serving_area_f area_control,
> lot_f lot_f,
> lot,
> addr_blocked_cfg,
> op_serving_area area_c,
> op_serving_area_wcenter
> WHERE sdo_relate(lot_f.geometry,
> area_control.geometry,
> 'mask=INSIDE+COVEREDBY') = 'TRUE'
> AND
> SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(area_control.geometry, 0.001) =
> 'TRUE'
> AND area_control.op_serving_area_id = area_c.id
> AND area_c.area_type = 2
> AND lot.id = lot_f.lot_id
> AND lot.addr_blocked_cfg_id = addr_blocked_cfg.id(+)
> AND op_serving_area_wcenter.op_serving_area_id = area_c.id
> and lot_f.lot_id = 218692
> /
>
> When I run it as is above it returns to me the line :
>
> 5679907 218692
>
> ​If I change it in order to return all lines, ​ changing only it :
>
> -- and lot_f.lot_id = 218692
>
> ​The line does not return in the result.
>
> Any experience with cenary like this ?
>
> Regards
>
> Eriovaldo
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l