[Info-ingres] question about READ UNCOMMITTED

[Martin Bowes]

Halloween?

I would have though repeated records would have been Groundhog Day.

Marty

-----Original Message-----
From: Karl Schendel [mailto:schendel at kbcomputer.com] 
Sent: 11 November 2015 10:39
To: Ingres and related product discussion forum
Subject: Re: [Info-ingres] question about READ UNCOMMITTED


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

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres