[Info-ingres] question about READ UNCOMMITTED

[Karl Schendel]

On Nov 11, 2015, at 5:40 AM, Martin Bowes <martin.bowes at ctsu.ox.ac.uk> wrote:

> Halloween?
> 
> I would have though repeated records would have been Groundhog Day.
> 
> Marty


The code predated the film.

Karl


> 
> -----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