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

Attribute queries with order by failing in hsql

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 2.4.0.patch, 2.4.1
    • None
    • None
    • 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]

      Attachments

        Activity

          People

            shilen.patel@at.internet2.edu Shilen Patel (duke.edu)
            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: