[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6728) SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums in a case sensitive database

[Rick Riemer (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=44312#comment-44312 ] 

Rick Riemer commented on HHH-6728:
----------------------------------

I have just attached a testcase to expose the issue. It shouldn't be too hard to fix. Its probably just removing the toLowerCase() call and changing the indexOf() calls into case-insensitive versions (e.g. by using (precompiled) regular expressions).

> SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums in a case sensitive database
> ---------------------------------------------------------------------------------------------
>
>                 Key: HHH-6728
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6728
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.6.7, 4.0.0.CR4
>         Environment: MS SQL Server 2008 with Latin1_General_CS_AS collation
>            Reporter: Andrei Zaitsev
>         Attachments: H6728Test.java
>
>
> SQLServer2005Dialect changes the original query in getLimitString() to lowercase. That leads to SQLGrammarExcepton with case sensitive collation and not-lowercase table and column names.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira