[ https://issues.jboss.org/browse/TEIID-2045?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2045: ---------------------------------- Summary: Error with INSERT using a query expression (was: SQL Error occurs trying to load External Materialized table when the 2 source models are using the same -ds.xml) Fix Version/s: 7.7.1 8.1 Description: INSERT INTO tbl SELECT * FROM other Against a source that supports insert with query expression will fail with: org.teiid.query.sql.symbol.AllSymbol cannot be cast to org.teiid.query.sql.symbol.SingleElementSymbol was: A Customer was testing external materialization in Teiid/EDS, he created physical model mv_views based on External_CacheViews.supplierinfo (Parts3.vdb attached, uses the partssupplier db). Supplierinfo is a join between parts SourceB and SourceA, well if you assign the same Datasource (using the same ds.xml file) it errors trying to load the table. INSERT INTO mv_views.supplierinfo SELECT * FROM External_CacheViews.supplierinfo OPTION NOCACHE Error: org.teiid.query.sql.symbol.AllSymbol cannot be cast to org.teiid.query.sql.symbol.SingleElementSymbol SQLState: 38000 ErrorCode: 0 The issue is that the we are picking up the virtual command as the atomic request. This is not correct as we need the planned query, which will have a proper select clause among other things. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2045?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2045: ------------------------------------------- Bugzilla Update: Perform -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-2045?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2045: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 823583|https://bugzilla.redhat.com/show_bug.cgi?id=823583] from MODIFIED to CLOSED -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira