[Hibernate-JIRA] Created: (HHH-6728) SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums in a case sensitive database
12:13 p.m.
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: 4.0.0.CR4, 3.6.7
Environment: MS SQL Server 2008 with Latin1_General_CS_AS collation
Reporter: Andrei Zaitsev
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
1:13 p.m.
New subject: [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...
]
Strong Liu commented on HHH-6728:
---------------------------------
test case please
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
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
9:48 a.m.
New subject: [Hibernate-JIRA] Updated: (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 updated HHH-6728:
-----------------------------
Attachment: H6728Test.java
A testcase to expose the casing issue.
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
9:50 a.m.
New subject: [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
8:58 a.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-6728) SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums in a case sensitive database
[
https://hibernate.onjira.com/browse/HHH-6728?page=com.atlassian.jira.plug...
]
Strong Liu reassigned HHH-6728:
-------------------------------
Assignee: Lukasz Antoniak
SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums
in a case sensitive database
---------------------------------------------------------------------------------------------
Key: HHH-6728
URL: https://hibernate.onjira.com/browse/HHH-6728
Project: Hibernate ORM
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
Assignee: Lukasz Antoniak
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
1:37 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-6728) SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums in a case sensitive database
[
https://hibernate.onjira.com/browse/HHH-6728?page=com.atlassian.jira.plug...
]
Lukasz Antoniak resolved HHH-6728.
----------------------------------
Resolution: Fixed
Fix Version/s: 4.1.4
SQLServer2005Dialect - Paging doesn't work with UPPERCASE colums
in a case sensitive database
---------------------------------------------------------------------------------------------
Key: HHH-6728
URL: https://hibernate.onjira.com/browse/HHH-6728
Project: Hibernate ORM
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
Assignee: Lukasz Antoniak
Fix For: 4.1.4
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
4610
days inactive
4824
days old
hibernate-issues@lists.jboss.org
5 comments
4 participants
participants (4)
-
Andrei Zaitsev (JIRA) -
Lukasz Antoniak (JIRA)
-
Rick Riemer (JIRA)
-
Strong Liu (JIRA)