Expressions cannot be selected by XML queries - response to "select relate(..." ------------------------------------------------------------------------------- Key: TEIIDDES-5 URL: https://jira.jboss.org/jira/browse/TEIIDDES-5 Project: Teiid Designer Issue Type: Bug Environment: fedora 10 Reporter: Paul Nittel Assignee: Steven Hawkins Attachments: FedTools51_MPS.zip I ran the E2E XML Relate Context script and found I could not execute queries. I get the subject error when I do so. This is the query: select relate(rentals.rentsVehicle,rentals.company,rentals.vehicle, 'rentals.rentsVehicle.companyID=rentals.company.companyID and rentals.rentsVehicle.vehicleID=rentals.vehicle.vehicleID') from "VehicleRentalsVDB"."VehicleRentalsDoc.rentalsDocument" Here's the accompanying exception: Error 2008-12-18 14:08:25.526 Error processing query com.metamatrix.jdbc.MMSQLException: Expressions cannot be selected by XML Queries at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:85) at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:66) at com.metamatrix.jdbc.MMStatement.setException(MMStatement.java:364) at com.metamatrix.jdbc.MMStatement.processQueryMessage(MMStatement.java:441) at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:540) at com.metamatrix.jdbc.MMStatement.execute(MMStatement.java:387) at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.processQuery(SqlExecProgress.java:192) at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.run(SqlExecProgress.java:121) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) Caused by: [QueryResolverException]Expressions cannot be selected by XML Queries at com.metamatrix.query.resolver.command.XMLQueryResolver.resolveXMLSelect(XMLQueryResolver.java:203) at com.metamatrix.query.resolver.command.XMLQueryResolver.resolveCommand(XMLQueryResolver.java:88) at com.metamatrix.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:176) at com.metamatrix.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:128) at com.metamatrix.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:100) at com.metamatrix.dqp.internal.process.Request.resolveCommand(Request.java:353) at com.metamatrix.dqp.internal.process.Request.prepareCommand(Request.java:314) at com.metamatrix.dqp.internal.process.Request.generatePlan(Request.java:506) at com.metamatrix.dqp.internal.process.Request.processRequest(Request.java:619) at com.metamatrix.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:365) at com.metamatrix.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:210) at com.metamatrix.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:46) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Model Project Set attached.