Re: nh-1197 - Subselects fetching on PostgreSQL

Yes, doing it without params will work, but I don't think that this is a
good solution.
The HB impl uses parameters as well.
The main problem with this bug is that lazy loading make it a pure _bitch_
to try to debug.


On Sun, Jun 29, 2008 at 10:29 PM, Fabio Maulo <[email protected]> wrote:

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

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