Re: [nhusers] Re: Subquery in From Clause

If you submit a patch file with a failing unit test for this issue to the
Jira (and send me an email) I'll take a look at it. No promises, but I will
look at it. :)

 -Will

On Wed, Jul 9, 2008 at 9:03 AM, Sukhjinder Sidhu <[email protected]> wrote:

>  There are certainly some problems we're still having with SQL 2005
> paging.  Even with 2.0 beta 1 these problems occur and I've had to fall back
> to the 2000 dialect for things to work properly.
>
>
>
> I've reported NH-1350 (http://jira.nhibernate.org/browse/NH-1350) and I
> think NH-1349 is linked.
>
> Regards,
>
> Sukhjinder Sidhu
>
>
>
> *From:* [email protected] [mailto:
> [email protected]] *On Behalf Of *Will
> Shaver
> *Sent:* 09 July 2008 16:58
> *To:* the NHibernate development list
> *Subject:* Re: [NHibernate-development] [nhusers] Re: Subquery in From
> Clause
>
>
>
>   SQL 2005 paging is broken.
>
>
>
> Is it still? I fixed a couple of the JIRA issues around this... which ones
> are still open?
>
>
>
> It certainly is implemented in a strange way... but I'd argue that whoever
> decided on the syntax for doing paging in SQL 2005 wasn't sane. It's about
> the most complicated thing I've ever seen in SQL. Cross Joins, Group By,
> Nested Case Statements... I can handle all of these things in my head
> without any thought. SQL 2005 paging is messed up.
>
>
>
> ..
>
>
>
> Building a better SQL assember would work, but may not be neccessary. If
> the road were mine to plan here is what I'd recommend:
>
>
>
> 1) Improve the Linq implementation to where it works for 99% of users.
>
> 2) Move the Linq implementation into the core
>
> 3) Encourage all users to use the Linq implementation in documentation
>
> 4) Replace backend Linq -> SQL with whatever seems good at the time
>
> 5) Phase out HQL and Criteria as a way of getting to entities
>
> 6) Re-write Linq backend whenever we feel like it. Now that everyone is on
> Linq it really doesn't matter to the user how the translation is happening.
>
>
>
> Lots of work. Step 2 is critical.
>
>  -Will
>
>
>
>
>
>  -Will
>
>
>
>
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> Nhibernate-development mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/nhibernate-development
>
>

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08

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