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
