Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-2370

Attribute queries with order by failing in hsql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.4.0.patch, 2.4.1
    • Component/s: None
    • Labels:
      None

      Description

      There are several queries that fail with errors like:

       

      Caused by: java.sql.SQLSyntaxErrorException: invalid ORDER BY expression in statement [select count(attributea1_.id) as col_0_0_ from grouper_groups group0_ cross join grouper_attribute_assign attributea1_ cross join grouper_attribute_def_name attributed2_ cross join grouper_attribute_def attributed3_ cross join grouper_memberships_all_v membership4_ cross join grouper_memberships_all_v membership5_ where membership5_.owner_group_id=group0_.id and (membership5_.field_id in (? , ?)) and (membership5_.member_id in (? , ?)) and membership5_.immediate_mship_enabled='T' and attributea1_.attribute_def_name_id=attributed2_.id and group0_.id=attributea1_.owner_group_id and attributed3_.id=attributed2_.attribute_def_id and attributea1_.attribute_assign_type='group' and membership4_.owner_attr_def_id=attributed2_.attribute_def_id and (membership4_.field_id in (? , ?)) and (membership4_.member_id in (? , ?)) and membership4_.immediate_mship_enabled='T' and attributea1_.enabled='T' and (attributed2_.id in (?)) order by group0_.display_name asc]

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              shilen.patel@at.internet2.edu Shilen Patel (duke.edu)
              Reporter:
              shilen.patel@at.internet2.edu Shilen Patel (duke.edu)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: