[ https://issues.apache.org/jira/browse/SYNCOPE-1308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16466025#comment-16466025 ]
ASF subversion and git services commented on SYNCOPE-1308: ---------------------------------------------------------- Commit 7cdeb5fa8aaae5e39e2453e7bd9fe057afc886b4 in syncope's branch refs/heads/master from [~ilgrosso] [ https://git-wip-us.apache.org/repos/asf?p=syncope.git;h=7cdeb5f ] [SYNCOPE-1308] Now working fine with latest PostgreSQL (needs dedicated views.xml) > Exception getting users with orderBy on SyncopeClient API with Postgres 10.3 > ---------------------------------------------------------------------------- > > Key: SYNCOPE-1308 > URL: https://issues.apache.org/jira/browse/SYNCOPE-1308 > Project: Syncope > Issue Type: Bug > Components: client > Affects Versions: 2.0.8 > Environment: Windows Server 2012 R2 64 > Java 8 > Tomcat 8 > Syncope 2.0.8 > JDBC Driver 42.2.2 > Postgres 10.3 > Reporter: Paul Fullbright > Assignee: Francesco Chicchiriccò > Priority: Major > Fix For: 2.0.9, 2.1.0 > > > To reproduce, I used the following code: > {{ UserService service = client.getService(UserService.class); }} > {{ AnyQuery query = new AnyQuery.Builder() }} > {{ .page(1) }} > {{ .size(1) }} > {{ .orderBy("email ASC") }} > {{ .realm("/") }} > {{ .build(); }} > {{ }} > {{ return service.search(query);}} > And then I received the following exception stack: > {{org.apache.syncope.common.lib.SyncopeClientException: > DataIntegrityViolation }} > {{[ERROR: UNION types integer and text cannot be matched }} > {{ Position: 158 {prepstmnt 1156037144 SELECT u.any_id,sva.stringvalue AS }} > {{email FROM (SELECT DISTINCT any_id FROM user_search WHERE id IS NOT NULL) > u, }} > {{(SELECT * FROM user_search_attr UNION SELECT * FROM user_search_null_attr) > }} > {{sva WHERE u.any_id=sva.any_id AND sva.schema_id='email' AND u.any_id IN }} > {{(SELECT any_id FROM user_search WHERE realm_id IN (SELECT id AS realm_id }} > {{FROM Realm WHERE id=?)) ORDER BY email ASC} [code=0, state=42804]] }} > {{ 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.$Proxy64.search(Unknown Source) }} > {{ at com.gal.ums.services.UsersService.getUsers(UsersService.java:65) }} > -- This message was sent by Atlassian JIRA (v7.6.3#76005)