[Info-ingres] question about READ UNCOMMITTED

Karl Schendel schendel at kbcomputer.com
Wed Nov 11 10:39:09 UTC 2015


On Nov 11, 2015, at 12:04 AM, Paul White <paul.white at shift7solutions.com.au> wrote:

> I read something interesting about READ UNCOMMITTED and NOLOCK in MSSQL.
> ...
> Apparently it is possible to duplicate records from a simple join from
> several tables with unique primary keys.
> Does Ingres have this feature :-)

Internally it's called the "halloween" problem and yes it can happen,
e.g. if you're reading with a DIRECT cursor.

Karl




More information about the Info-ingres mailing list