TimesTen Query Hint TT_ROWLOCK(0) Causing wrong results

(Doc ID 2379189.1)

Last updated on APRIL 16, 2018

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.8.17 and later
Information in this document applies to any platform.

Symptoms

Below type of SQL returns wrong results when TT_ROWLOCK(0) hint being used. For Exalytics system this hint is mandatory


WITH
SAWITH0 AS
(
select
sum(T14215.Subscriber00007C07) as c1
from
XXXXX T14163,
XXXX T14116,
FMvtDRgnMC T14215
where
(
T14163.Service_Pr00007D8C = T14215.Service_Pr00007D8C and
T14116.Network_Re00007C29 = T14215.Network_Re00007C29 and
T14116.Network_Re00007C2A = 'XXXX' and
T14163.Service_Pr00007D8E = 'Y' and
T14215.Year_Month0000D0DD = 201705
)
group by
case
when T14116.Network_Re00007C2A = 'XXXX' then 'XXXX'
end
)
select /*+ TT_ROWLOCK(0) TT_FASTPREPARE(1) */
D1.c1 as c8
from
SAWITH0 D1;

As per result is concerned the SUM result is doubled for wrong result

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms