RE: Interesting Issue related to sql result
Date: Fri, 6 Apr 2018 06:59:09 +0000
Message-ID: <27167_1522997960_5AC71AC8_27167_8271_1_ECDEF0CC6716EC4596FCBC871F48292AB1991CCA_at_ZRH-S231>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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_at_gmail.com<mailto:ecandrietta_at_gmail.com>>: HI,
Does anyone knows what happens in this cenary :
I have a query like this.
SELECT /*+ parallel (area_control,6)
When I run it as is above it returns to me the line :
5679907 218692
Any experience with cenary like this ?
Regards
Eriovaldo
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
/
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.
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>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 06 2018 - 08:59:09 CEST