[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6728) SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums in a case sensitive database
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6728?page=c...
]
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