Also, there are plenty of wrong result bugs in 12.1 related to parallel
execution. Fortunately, some of them are fixed in 12.2.
Therefore, it’d be interesting to see whether you get the correct result with
the parallel execution disabled: /*+
opt_param('parallel_execution_enabled','false') */
Also, it’s worth checking whether the problem still exists in 12.2.
Best regards,
Nenad
http://nenadnoveljic.com/blog/
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Sayan Malakshinov
Sent: Donnerstag, 5. April 2018 21:43
To: Eriovaldo Andrietta
Cc: ORACLE-L
Subject: 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@xxxxxxxxx<mailto:ecandrietta@xxxxxxxxx>>:
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<http://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<http://area_c.id>
AND area_c.area_type = 2
AND lot.id<http://lot.id> = lot_f.lot_id
AND lot.addr_blocked_cfg_id =
addr_blocked_cfg.id<http://addr_blocked_cfg.id>(+)
AND op_serving_area_wcenter.op_serving_area_id =
area_c.id<http://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
____________________________________________________
Please consider the environment before printing this e-mail.
Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">p { font-family: Arial;font-size:9pt }</style>
</head>
<body>
<p>
<br>Important Notice</br>
<br>This message is intended only for the individual named. It may contain
confidential or privileged information. If you are not the named addressee you
should in particular not disseminate, distribute, modify or copy this e-mail.
Please notify the sender immediately by e-mail, if you have received this
message by mistake and delete it from your system.</br>
<br>E-mail transmission may not be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
processing of incoming e-mails cannot be guaranteed. All liability of the
Vontobel Group and its affiliates for any damages resulting from e-mail use is
excluded. You are advised that urgent and time sensitive messages should not be
sent by e-mail and if verification is required please request a printed
version.<br/>
</p>
</body>
</html>
