Bug 1232169
| Summary: | Infinispan-dsl-cache translator: Exception is thrown when order by clause is used | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Filip Elias <felias> | ||||
| Component: | Teiid | Assignee: | Van Halbert <vhalbert> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Filip Elias <felias> | ||||
| Severity: | urgent | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 6.2.0 | CC: | felias, vhalbert | ||||
| Target Milestone: | ER3 | Keywords: | QA-Closed | ||||
| Target Release: | 6.2.0 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: |
DV 6.2 ER2
|
|||||
| Last Closed: | 2016-02-10 08:54:15 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
Filip, I need your VDB and the pojo jar that contains the protobuf file. I ran this against the quick start and didn't have the issue. Was able to issue query: - select name, email, id from Person where id > 0 Order by id where id is an integer. Van Unable to duplicate this issue when using the model/vdb that was created by using the Teiid Connection importer to create the source model. I'm executing against my DV server that's accessing the QE JDG server using this query: Select intKey, stringKey from SmallA order by intKey Will mark this as MODIFIED and then will move to ON_QA, with the assumption that QE will recreate their VDB/model using Teiid Connection importer before retrying. Van Halbert <vhalbert> updated the status of jira TEIID-3532 to Closed Verfied on DV 6.2 ER4 |
Created attachment 1039306 [details] Server log Infinispan-dsl-cache translator will fail if order by clause is pushed down. Sample query: select intKey from smalla where intkey > 1 order by intKey Exception: Connector worker process failed for atomic-request=iLuNd1gO/2N0.4.0.7: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[38] returned server error (status=0x85): org.hibernate.hql.ParsingException: HQLPARSER000002: The query FROM org.jboss.qe.jdg_remote.protobuf.SmallA _gen0 WHERE _gen0.intKey > 1 ORDER BY _gen0.null ASC is not valid; Parser error messages: [[statement, statementElement, selectStatement, orderByClause, sortSpecification, sortKey, concatenation, additiveExpression, multiplyExpression, unaryExpression, atom, identPrimary]: line 1:89 mismatched token: [@32,89:92='null',<124>,1:89]; expecting type IDENTIFIER]. at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:298) at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:88) at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:74) Full log is in the attachment.