Timesten: Incorrect query output during parallel updates (Doc ID 2270641.1)

Last updated on JUNE 01, 2017

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.8.7 to 11.2.2.8.20 [Release 11.2]
Information in this document applies to any platform.

Symptoms

This the brief scenario where the results are shown wrong

Select query is used to fetch selected columns from multiple tables, query uses DISTINCT .

Query: SELECT DISTINCT(c.column2), a.column1, c.column3, d.column2, d.column4, c.column4, c.column5 FROM tableA a,tableB b, tableC c, tableD d WHERE a.column2 = b.column2 AND c.column1 = b.column2 AND c.column3 = b.column3 AND c.column2 = d.column3 AND d.column5 = b.column3;

Parallely from another sessions updates are issued on the tables

update tableA set column7=568 where column1='878767888';

In this case , select query is resulting garbage outputs .

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