[Info-ingres] question about READ UNCOMMITTED

[Paul White]

Hi all,


I read something interesting about READ UNCOMMITTED and NOLOCK in MSSQL.

Along with the expected Dirty Reads, Non-Repeatable Reads, and Phantom
Reads, there is something called "Same Data is Read Twice".  

This page describes the MSSQL feature.
http://sqlblog.com/blogs/tamarick_hill/archive/2013/05/06/pros-cons-of-using
-read-uncommitted-and-nolock.aspx

Apparently it is possible to duplicate records from a simple join from
several tables with unique primary keys.
Does Ingres have this feature :-)


Paul

&
Shift Seven Solutions
84 Annie Drive Peregian Beach QLD 4573
Mob 0414 681799
Ph 07 5448 2137
www.shift7solutions.com.au