Label queries fail on Sybase

XMLWordPrintable

    • Type: Bug
    • Resolution: Won't Fix
    • Priority: Medium
    • None
    • Affects Version/s: 2.2.8, 2.5, 2.6.0
    • Component/s: None
    • 7

      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.

            Assignee:
            Steve Haffenden (Inactive)
            Reporter:
            Tom Davies
            Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: