Jiri Cincura schrieb am 15.09.2012 um 13:40 (+0200):
> 
> … I went across bugs and found DNET-337. Read it, think about it.

http://tracker.firebirdsql.org/browse/DNET-337

> What my idea is, is to change ReadCommitted and ReadUncommitted to
> have same [1] TPB and use rec_version [2].
> 
> [1] Because there's no "uncommitted" mode in Firebird and I think it's
> better than throw an exception.
> [2] Because of reasons mentioned in ticket.
> 
> What do you think?

A. ReadUncommitted

Firebird doesn't do ReadUncommitted, so raising an ArgumentException
when ReadUncommitted is requested would seem to make sense to me.
Falling back to ReadCommitted, on the other hand, would not be what
was requested. Firebird people clearly agree that Firebird doesn't
do ReadUncommitted, so why try faking it?

B. ReadCommitted

For ReadCommitted, I found this discussion from 12/2005, which the
ticket in question reads like an echo of:

firebird-devel - NO_REC_VERSION
http://firebird.1100200.n4.nabble.com/NO-REC-VERSION-td1109867.html

Looks like they didn't change the default of isc_tpb_no_rec_version in
the C API (see ApiGuide.pdf p.66) in order not to break existing code.

> This will, for sure, be version 3.0 because it's huge breaking change.
> As much as I don't like breaking changes, this looks like one worth
> it. Of course, there will be huge screaming read exclamation point
> everywhere around this version.

An argument in favour of changing ReadCommitted to default to
isc_tpb_rec_version would be that a couple knowledgeable people
say it has usability advantages and makes more sense that way.

An argument against it might be that it deviates from the C API.

As for me, first time I'm even hearing about the issue, so I don't
have an opinion on what's wrong or right for ReadCommitted in .NET.

Here's another related and probably relevant discussion (too tired to
read it now):

firebird-devel - ReadCommitted isolation mode in Firebird's drivers
http://firebird.1100200.n4.nabble.com/ReadCommitted-isolation-mode-in-Firebird-s-drivers-td2311647.html

Michael

------------------------------------------------------------------------------
How fast is your code?
3 out of 4 devs don\\\'t know how their code performs in production.
Find out how slow your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219672;13503038;z?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to