Alexander Tsvetkov created SYNCOPE-1304: -------------------------------------------
Summary: Order Groups by userOwner throws DataIntegrityViolation exception Key: SYNCOPE-1304 URL: https://issues.apache.org/jira/browse/SYNCOPE-1304 Project: Syncope Issue Type: Bug Components: core Affects Versions: 2.0.8 Reporter: Alexander Tsvetkov Fix For: 2.0.8 In java code when I search groups with request {code:java} {"realm":"/","details":null,"fiql":null,"page":1,"size":50,"orderBy":"userOwner DESC"} {code} I got exception: {noformat} 16:06:33.151 [http-nio-8090-exec-7] ERROR o.a.s.c.l.RestClientExceptionMapper - Exception thrown org.apache.syncope.common.lib.SyncopeClientException: DataIntegrityViolation [ERROR: column sv.userowner does not exist Position: 17 {prepstmnt 950849233 SELECT u.any_id,sv.userOwner FROM (SELECT DISTINCT any_id FROM group_search WHERE id IS NOT NULL) u,group_search sv WHERE u.any_id=sv.any_id AND u.any_id IN (SELECT any_id FROM group_search WHERE realm_id IN (SELECT id AS realm_id FROM Realm WHERE id=? OR id=? OR id=? OR id=?)) ORDER BY sv.userOwner DESC} [code=0, state=42703]] at org.apache.syncope.common.lib.SyncopeClientException.build(SyncopeClientException.java:37) at org.apache.syncope.client.lib.RestClientExceptionMapper.checkSyncopeClientCompositeException(RestClientExceptionMapper.java:143) at org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:53) at org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:42) at org.apache.cxf.jaxrs.client.ClientProxyImpl.checkResponse(ClientProxyImpl.java:313) at org.apache.cxf.jaxrs.client.ClientProxyImpl.handleResponse(ClientProxyImpl.java:876) at org.apache.cxf.jaxrs.client.ClientProxyImpl.doChainedInvocation(ClientProxyImpl.java:789) at org.apache.cxf.jaxrs.client.ClientProxyImpl.invoke(ClientProxyImpl.java:235) at com.sun.proxy.$Proxy118.search(Unknown Source) {noformat} The same problem is reproduced in swagger. Request: {noformat} http://localhost:8080/syncope/rest/groups?page=1&size=20&orderby=userOwner&realm=%2F {noformat} Response: {noformat} { "status": 409, "type": "DataIntegrityViolation", "elements": [ "ERROR: column sv.userowner does not exist\n Position: 17 {prepstmnt 1083964178 SELECT u.any_id,sv.userOwner FROM (SELECT DISTINCT any_id FROM group_search WHERE id IS NOT NULL) u,group_search sv WHERE u.any_id=sv.any_id AND u.any_id IN (SELECT any_id FROM group_search WHERE realm_id IN (SELECT id AS realm_id FROM Realm WHERE id=? OR id=? OR id=? OR id=?)) ORDER BY sv.userOwner ASC} [code=0, state=42703]" ] } {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)