TimesTen Query Hint TT_ROWLOCK(0) Causing wrong results
(Doc ID 2379189.1)
Last updated on MAY 08, 2018
Applies to:Oracle TimesTen In-Memory Database - Version 18.104.22.168.17 and later
Information in this document applies to any platform.
Below type of SQL returns wrong results when TT_ROWLOCK(0) hint being used. For Exalytics system this hint is mandatory
sum(T14215.Subscriber00007C07) as c1
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
when T14116.Network_Re00007C2A = 'XXXX' then 'XXXX'
select /*+ TT_ROWLOCK(0) TT_FASTPREPARE(1) */
D1.c1 as c8
As per result is concerned the SUM result is doubled for wrong result
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!