Details
-
Bug
-
Resolution: Won't Fix
-
Medium
-
None
-
2.2.8, 2.5, 2.6.0
-
None
-
7
-
Description
Because some label queries use large Group By clauses, they fail on Sybase:
org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [The current query would generate a key size of 799 for a work table. This exceeds the maximum allowable limit of 600. ]; nested exception is com.sybase.jdbc3.jdbc.SybSQLException: The current query would generate a key size of 799 for a work table. This exceeds the maximum allowable limit of 600.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:94)
caused by: com.sybase.jdbc3.jdbc.SybSQLException: The current query would generate a key size of 799 for a work table. This exceeds the maximum allowable limit of 600.
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
The label_findSingleDegreeSeparationFromLabel and label_findSingleDegreeSeparationFromLabelBySpace queries need to be changed for Sybase.
Attachments
Issue Links
- is duplicated by
-
CONFSERVER-8336 Label query uses joining columns which are too wide for Sybase
- Closed
-
CONFSERVER-9796 Search by Labels generates a "group by" clause of more than 600 bytes, leading to an exception in Sybase
- Closed