Re: nh-1197 - Subselects fetching on PostgreSQL

Starting from H3.2 default behavior (in practices reverting r3020) and after
some hours rethinking how resolve NH1155 I end to the same (more near to
identical) solution applied for NH1155.
NH1155 introduce a NH specific feature and, in this case, NH behavior if
better than Hb behavior; I don't want lost the feature.

I don't have Postgre but I think that the solution is more easy than I think
when I start this work.
In practices I think that we only need to add an override of
GetLimitString(SqlString, int, int).

What I saw in Hb is that not all dialect override that method; for example
the FirebirdDialect in Hb don't override GetLimitString(SqlString, int, int)
but we do it in NH and the two failed-tests of NH-1197 work fine with
Firebird.
Probably the PostgreSQLDialect is too old in NH.

I'm going to leave a comment to the issue and hope somebody have Postgre can
create a very simple patch overriding GetLimitString(SqlString, int, int) in
PostgreSQLDialect.

-- 
Fabio Maulo

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php

_______________________________________________
Nhibernate-development mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nhibernate-development