[
https://issues.jboss.org/browse/TEIID-3116?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3116:
---------------------------------------
This is expected behavior. If no database version is set on a translator that
automatically determines capabilities, then it will not allow planning to proceed. So if
you expect the source to be unavailable, then you should manually set the database
version.
Teiid Partial Results Mode: unavailability of datasource causes error
(which is not masked)
-------------------------------------------------------------------------------------------
Key: TEIID-3116
URL:
https://issues.jboss.org/browse/TEIID-3116
Project: Teiid
Issue Type: Bug
Components: Server
Affects Versions: 8.7.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Priority: Critical
Description of problem:
Querying a vdb-table which is formed as union of two tables from different datasources.
Even though "set partialresultsmode true" is run as initial query, instead of
retreiving 0 rows from a datasources that is down, exception is promoted.
Version-Release number of selected component (if applicable):
DV 6.1 ER1
How reproducible:
Every time
Steps to Reproduce:
1. Define one valid and one invalid datasource(invalid connection-url).
2. Create vdb which maps tables from both datasources.
3. Set partialresultsmode to true
4. Execute query on the given vdb-table
Actual results:
TeiidSQLException
TEIID30498 Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498
Capabilities for ORBQT were not avaialable. The command could not be planned properly.
Expected results:
0 rows from invalid datasource.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)